Read audit file

[SriksAdi]

Hi All,
I am aware of a function ttstpaudread.search.audited.records() which accepts XML constructs to fetch the rows from audit file.

I could fetch the table field values from the audit file using this function. Now, I need to check if the record which is fetched is a new record inserted in the table or an existing record which is modified.

I am aware of the Type of Operation flag of the audit file, but how to read it ? Please help.


regards
Sriks

[SriksAdi]

Got the solution. xmlGetAttribute() solved the problem.



regards

[NPRao]

Sriks,

I am aware of the Type of Operation flag of the audit file,

I couldnt find a flag for type of operation. This is the prototype in our BaaN version.

long search.audited.records.for.gw( domain ttaud.tabl i.table, long i.selection.criteria.tree, long i.setsize, long io.next.node.id.tree, long o.data.xml.tree, long gwnetlisterrordoc )

long ttstpaudread.search.audited.records( domain ttaud.tabl i.table, long i.selection.criteria.tree, long i.setsize, long io.next.node.id.tree, long o.data.xml.tree )

Now, I need to check if the record which is fetched is a new record inserted in the table or an existing record which is modified.
You can do it with - aud.get.next.action()

State
If meta.data.changed is true, the internal meta data information on the fields have been refreshed. This information must be retrieved using functions aud.get.field.ids()and aud.get.field.info().

If action.type is 'I', 'U' or 'D' then the row information on the action is available for retrieval using functions aud.get.field.status(), aud.put.old.field.value() and aud.put.new.field.value(). See the following table:

Action type aud.get.field.status aud.get.old.field.value aud.get.new.field.value
'C' (Create table)
no
no
no

'L' (Clear table)
no
no
no

'R' (Drop table)
no
no
no

'I' (Insert row)
yes
no
yes

'D' (Delete row)
yes
yes
no

'U' (Update row)
yes
yes
yes

Note: The old and new field value is not available if the status shows the field is not logged in the audit trail. See aud.get.field.status().

[Amol.123]

Hi ,
CAn you please let me know if we can use this function in Baan LN also.

Thanks In Advance