2) Is it possible to use the API's to implement the Revert to the previous record logic.

Thanks

Wed Sep 14, 2011 12:40 pm

SysOpSite Admin

Joined: 26 Nov 2006Posts: 6509

Quote:

1) Is it possible to customize the Web Based reporting?

What do you mean by customize? Customize what exactly?
Just in case, you can create custom reports without customizing anything. Use Reports / User-defined Reports menu

Quote:

2) Is it possible to use the API's to implement the Revert to the previous record logic.

API provides programmatic and command line interfaces to the security and audit management and reporting functions available in web and GUI consoles. It allows integration of these functions into 3rd- party and custom solutions

Wed Sep 14, 2011 10:11 pm

raviraj

Joined: 31 Aug 2011Posts: 16Country: India

Hi,

Customizing in the sense that I can filter the reports based on some criteria and I can provide check box in front of each record. If user selects any check box then system should revert back the current record to the selected record.

Thanks

Thu Sep 15, 2011 3:50 am

SysOpSite Admin

Joined: 26 Nov 2006Posts: 6509

You would need to create a custom web page that will display checkboxes and display records deleted, inserted and updated. For updated records only these having status NEW. You can use the API to pull this data or you can get it directly from the database, but to do the "revert" you will need to execute a couple of direct SQL queries, to delete the existing record, if use selected an updated or inserted record to be reverted, and in case of update and delete, reinsert what was there before (copy record having status OLD from audit trail to the target table)