Register / Login
Win a copy of
Java Database Connections & Transactions (e-book only)
this week in the
this forum made possible by our volunteer staff, including ...
Stephan van Hulst
Java in General
To display ChangeLog results in peculiar scenario
posted 11 years ago
I have the tables called,USERROLES and USERROLE_ADT, In my application,User has some set of roles assigned. Administrator can add or delete the roles.
Whenever he modifies the role, we are deleting the all roles and inserting the roles newly(As we can't update the USERROLE table due to some database integrity).
Now i need to display the changelog for the userroles, whenever roles are changed for the user, we need to display those details are in below format
field currentvalue oldvalue changed date change by
role1 active deleted today(dd/mm/yyyy) adminName
role2 deleted active yesterday(dd/mm/yyyy) adminName2
Could any one comeup with Query level or
Nothing? Or something? Like this tiny ad:
how do I do my own kindle-like thing - without amazon
Boost this thread!
XSD date restriction
Mysql Date Format
Getting date format from Locale