report of changes user ID
- j0eman
- Topic Author
- Offline
- New Member
-
Less
More
- Posts: 5
- Thank you received: 0
9 years 5 months ago #17953
by j0eman
report of changes user ID was created by j0eman
how to create a report to show the user id that has changed today, by displaying the old value and the new value.
Thanks
Thanks
Please Log in or Create an account to join the conversation.
- jpb
-
- Offline
- Moderator
-
- retired . . . ¯\_(ツ)_/¯
Less
More
- Posts: 2859
- Thank you received: 650
9 years 5 months ago #17957
by jpb
Replied by jpb on topic report of changes user ID
For a generic report (showing only the changed fields) you will have to write a routine to select the data and build up the report line by line.
If you are only interested in specific fields you can use JQL code like this :
LIST F.USER WITH DATE.TIME LIKE 150824... COMPANY.RESTR EVAL"CURR.NO - 1;@ID;@2:';':@1;SUBR('ENQ.TRANS','USER$HIS',@3,'COMPANY.RESTR')" AS OLD.COMPANY.RESTR
If you are only interested in specific fields you can use JQL code like this :
LIST F.USER WITH DATE.TIME LIKE 150824... COMPANY.RESTR EVAL"CURR.NO - 1;@ID;@2:';':@1;SUBR('ENQ.TRANS','USER$HIS',@3,'COMPANY.RESTR')" AS OLD.COMPANY.RESTR
Please Log in or Create an account to join the conversation.
Time to create page: 0.083 seconds