audit fields value changes on a form

[xren]

Hi,

Is there any audit functions provided by ebase to record fields values on a form changed by user when submit from old to new and we can record that values are changed and old values are xxx and new data are xxx


Thanks,
Xiaoli

[Jon]

This sounds the same question as this http://forum.ebasetech.com/forum/viewtopic.php?t=1013

[xren]

Yes and No.

What we want to do is to remember all input fields' value before page render, then check if any field's value changed, if yes then save both old value and new value to audit table for future reference.

If no available function from ebase, is there a way at the back to iterate all fields to get their name and value?

Thanks,
Xiaoli

[Steve James]

is there a way at the back to iterate all fields to get their name and value?

Have a look at http://dev-docs.verj.io/ufs/doc/javadoc ... ields.html

Code: Select all

for ( var field in Iterator(fields.iterator()) )
 {
    log(field.elementName);
 } 

As for before and after values, I occasional create a copy of the db backed table and then can compare values when the user hits the save button.

[t4nu]

are your controls link to the field of the table or to the item in the fields?
if the input controls is linked to the items in the field tab then you can compare the value in that item with the item in the field table, if something change then save otherwise go to other thing.

if the input controls are linked to the field in the table, then seems you have to have a backup database resource that will be fetched then the values are compared to the values of the input fields.

Yes and No.

What we want to do is to remember all input fields' value before page render, then check if any field's value changed, if yes then save both old value and new value to audit table for future reference.

If no available function from ebase, is there a way at the back to iterate all fields to get their name and value?

Thanks,
Xiaoli

[xren]

Thank you all for the input.

[mkushwaha]

@Steve James

Could you provide a proper link that works to check out the documentation for http://dev-docs.verj.io/ufs/doc/javadoc ... ields.html

log(field.elementName) just prints the element name. How does one print element value ?

Thanks.

[t4nu]

Is log(field.value) work?

@Steve James

Could you provide a proper link that works to check out the documentation for http://dev-docs.verj.io/ufs/doc/javadoc ... ields.html

log(field.elementName) just prints the element name. How does one print element value ?

Thanks.

[Hovik]

The url has changed to http://dev-docs.verj.io/ebase/doc/javad ... ields.html

field.elementName gives you the field name.
e.g.
for ( var field in Iterator(fields.iterator()) )
{
log("Field " + field.elementName + " has value of: " + field.value );
}

[mkushwaha]

Thanks Hovik& t4nu, that works!

I did the same thing with Tables.

Code: Select all

for (var table in Iterator(tables.iterator())){
	log("table:"+table.elementName);
}

How does one prints values for each row and columns ?

[Jon]

Something like this:

Code: Select all

for (var table in Iterator(tables.iterator())){
   log("table:"+table.elementName);
   var rows = table.rows;
   while (rows.next()) {
   	 for each (var column in table.columns) {
   	 	 log("column:"+column.elementName + " value: " + column.value);
   	 }
    }
} 

[Jon]

Or you could use the new table.toJSON() method in V5.1:

Code: Select all

for (var table in Iterator(tables.iterator())){
   log("table:"+table.elementName);
   log(table.toJSON());
}