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.
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
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