Search within Java in General
Register / Login
Win a copy of
Data Structures the Fun Way: An Amusing Adventure with Coffee-Filled Examples
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 14 years ago
Number of slices to send:
Optional 'thank-you' note:
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
It's fun to be me, and still legal in 9 states! Wanna see my tiny ad?
the value of filler advertising in 2021
Boost this thread!
XSD date restriction
Mysql Date Format
Getting date format from Locale