Can you access data from an unrelated business object

ask180

Probably not best practice, but I have a business object (AuditLog) to log all data changes to all business objects. Attributes are:

Business object name (text 40)
Business object unique reference (number) - unique within each business object, set on insert.
Details (t-1200) - before and after values

On the Main (edit/view) form of the other business objects, I'd like to add an Audit tab, that lists entries from the AuditLog business object that are specific to the business object instance being displayed.

So, I add an AuditLog attribute (allowing multiple) to my other business objects, but I can't see where I can enter run-time join criteria.

Can this be done? Or is there a better way to achieve my objective.

tford

So, I add an AuditLog attribute (allowing multiple) to my other business objects, but I can't see where I can enter run-time join criteria.

I use a similar concept on a couple of BOs in one of my BSVs.

After the AuditLog instance is create, simply have the rule that creates the AuditLog instance include this:

INSERT AuditLog In BoBeingLogged.AuditLog

ask180

Great suggestion. I will do that. Thanks.

pureist

but you don't even need the centralized 'Auditlog' BO.
you can just use a BO group object to compile all the individual BO audit transactions.

BenHayat

When this thread was opened, it was in the middle of the night of my timezone. I gave it some thought and ended up with 3 solutions. But the last and most streamlined was using ObjectGroup (as Purist suggested) and have a common attribute in each object to provide the Object name. (BTW, is there a function that returns the name of object?)

Then the log object will have a reference to the Object Group and use the Object Name to store in Log Object for future grouping and etc. But the Log Object will have a Peer relationship with Object Group.