Project and Portfolio Management Practitioners Forum
cancel
Showing results for 
Search instead for 
Did you mean: 

How to display Last Update Date

SOLVED
Go to solution
Highlighted
Greg_Shrout
Collector

How to display Last Update Date

When a user opens up a request after it has been created and wants to do further editing, I would like to have field that display Last Update Date and Last Updated By. But when I go to add a field to the request type or header, I can only add new User Defined fields; these two fields are auto-updated by the system - I just want to display the contents of KCRT_REQUEST_DETAILS.Last_Update_Date and KCRT_REQUEST_DETAILS.Last_Updated_By.
Seems like this ought to be simple.
Thanks for your help.
3 REPLIES
Semenov Alexand
Esteemed Contributor
Solution

Re: How to display Last Update Date

Good Day.
As variant you can create any rule in Request Tape and create 2 castum field 'last update date' and 'last apdated by'.
in rule set update any fields and set value for this 2 field from KCRT_REQUEST_DETAILS.Last_Update_Date ,KCRT_REQUEST_DETAILS.Last_Updated_By via SQL script.
I think it's can be work. Let's try.
Good Luck
Greg_Shrout
Collector

Re: How to display Last Update Date

Works great! Thanks!
Here's the query I used for Last Updated By:
select rdb.last_updated_by,
u.first_name||' '||u.last_name Full_Name
from
KCRT_REQUEST_DETAILS rdb,
knta_users u
where
request_id = [REQ.REQUEST_ID]
and u.user_id = rdb.last_updated_by
and rownum = 1
Greg_Shrout
Collector

Re: How to display Last Update Date

Pls see previous comments.
//Add this to "OnDomLoad" event