SoftTree Technologies SoftTree Technologies
Technical Support Forums
RegisterSearchFAQMemberlistUsergroupsLog in
Customizing Web Based Reports

 
Reply to topic    SoftTree Technologies Forum Index » DB Audit, DB Mail, DB Tools View previous topic
View next topic
Customizing Web Based Reports
Author Message
raviraj



Joined: 31 Aug 2011
Posts: 16
Country: India

Post Customizing Web Based Reports Reply with quote
Hi,

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

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 View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 7833

Post Reply with quote
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 View user's profile Send private message
raviraj



Joined: 31 Aug 2011
Posts: 16
Country: India

Post Reply with quote
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 View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 7833

Post Reply with quote
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)
Thu Sep 15, 2011 1:26 pm View user's profile Send private message
Display posts from previous:    
Reply to topic    SoftTree Technologies Forum Index » DB Audit, DB Mail, DB Tools All times are GMT - 4 Hours
Page 1 of 1

 
Jump to: 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


 

 

Powered by phpBB © 2001, 2005 phpBB Group
Design by Freestyle XL / Flowers Online.