Project and Portfolio Management Practitioners Forum
cancel

Show updated by

SOLVED
Go to solution
Highlighted
swaroop.nani
Respected Contributor.

Show updated by

Can we show who updated a field and when was it updated in an ITG?
9 REPLIES
HimaPV
Regular Contributor.

Re: Show updated by

Try the below query

SELECT PROMPT,LAST_UPDATED_BY,LAST_UPDATE_DATE FROM knta_parameter_set_fields
WHERE parameter_token like 'Test' -- Give you field Token
AND product_scope_code = 'RI'
and parameter_set_context_id IN (
SELECT parameter_set_context_id
FROM knta_parameter_set_contexts
WHERE context_value IN (
SELECT TO_CHAR (request_type_id)
FROM kcrt_request_types
WHERE request_type_name ='Test' )) -- Give the request type name
swaroop.nani
Respected Contributor.

Re: Show updated by

Hi HimaPV,

No luck, query is not returning any result.

My requrirement is, I have a field called 'A' using 'Text field' validation, if any user updates this field how can we find who has updated it and when was that updated.

In PPM can we add a field and update this field with the user name who has last updated field 'A'?
HimaPV
Regular Contributor.

Re: Show updated by

Hello,

This query should return the value. did u replace 'Test' with your request type name and parameter token? Is your field is a request header field? , if yes it requires a change.

You can update the last updated by field with a apply on field change rule.
swaroop.nani
Respected Contributor.

Re: Show updated by

Hi,

I am creating a rule.
I have used the following query to update the field but it is not updating the field

select LAST_UPDATED_BY from kcrt_transactions where request_id = [REQ.REQUEST_ID] AND column_prompt like 'Test%' -- field name
Jim Esler
Acclaimed Contributor.

Re: Show updated by

On the field definition, you can set Notes History to Yes and every change to the field will generate a Notes entry on the request. You will have a complete record of all changes, not just a record of who changed the field last.
swaroop.nani
Respected Contributor.

Re: Show updated by

Hi Jim,

Thanks for the update, I found that information, but I want only the last value.

Can we achieve this?
Jim Esler
Acclaimed Contributor.
Solution

Re: Show updated by

To do this in a rule, you would have a read only field for the id of the person doing the update (validation PPM - User Names - All or something similar) and a read only field for the time of the update. The rule would be set for 'Apply on field change' and the one field would be listed in Dependencies. The Updater and Update Date fields would be listed as Result Fields. The query would be something like:

select '[SYS.USER_ID]','[SYS.USERNAME]',sysdate,sysdate from dual
Raj Ghimire
Outstanding Contributor.

Re: Show updated by

I may have not understood the question properly, but when I want to find the last_update_by for a particular field, I usually directly query the table where the field value is stored in.

Eg.
Select krd.last_update_by,ku.full_name
from kcrt_request_details krd, knta_users ku
where
request_id = Your Request ID
and krd.batch_number = batch_num for field
and last_updated_by = ku.user_id

And while updating I udpate the same but also update last_update_date and entity_last_update_date values.
-Raj
swaroop.nani
Respected Contributor.

Re: Show updated by

Hi Jim,

Thanks a lot, it worked.