Where used and audit

dataservices job design
1

Repository view ALVW_PARENT_CHILD contains the ‘where-used’ relationships of BODS objects. However, when a custom function is used in an audit rule it does not pop-up there. How can I find out the ‘where-used’ of custom functions including the audit rules?

The only way I can think of is to parse/scan the language in field TEXT_VALUE of table AL_LANGTEXT. The audit rule is kept in a piece of XML:

<AuditRules>
<AuditRule RuleType="2">
<UIValue1></UIValue1>
<UIValue2></UIValue2>
<UIValue3></UIValue3>
<Custom>my_custom_function( ) = 0</Custom>
</AuditRule>

It’s quite a tedious task to do that, though not impossible.

I would appreciate an easier solution. Any suggestion is welcome!

lamanp :netherlands: (BOB member since 2008-09-02)

2

That is the only way I have found. Also the only way if you are looking for tables used inside custom SQL in a lookup_ext().

  • E

eepjr24 :us: (BOB member since 2005-09-16)