Project and Portfolio Management Practitioners Forum
cancel

Auditing the field changes

Highlighted
sam.greg
Honored Contributor.

Auditing the field changes

Hi,

We have enabled 'Transaction History' for a field.

Is there a way to run a report or create a portlet to check if the original data entered to this field is changed or not and if possible display these values?
5 REPLIES
Mahen M
Acclaimed Contributor.

Re: Auditing the field changes

I hope you can write a Query from KNTA_TRANSACTIONS and releted DETAILS table to get the desired results.

Regards,
Mahendran M
sam.greg
Honored Contributor.

Re: Auditing the field changes

Hi Mahendran,

Yes KNTA_TRANSACTIONS table audits this, but I don't see any possible way to pull the data using reports or portlet.

Can you please help me with this?
Sascha Mohr
Acclaimed Contributor.

Re: Auditing the field changes

You need a custom data source and a sql query that retrieves the info you want. Than you can create a portlet definition to display the info in a portlet. Report would be more effort though.
sam.greg
Honored Contributor.

Re: Auditing the field changes

Hi Sacha,

Can you please share me the custom data source and a sql query that retrieves the info?
Sascha Mohr
Acclaimed Contributor.

Re: Auditing the field changes

Depends on your needs, you could start with something like this:
SELECT t.COLUMN_PROMPT || ' was changed from ' || t.OLD_VISIBLE_COLUMN_VALUE || ' TO ' || t.NEW_VISIBLE_COLUMN_VALUE || ' by ' || (SELECT u.full_name FROM knta_users_v u WHERE u.user_id = t.LAST_UPDATED_BY) || ' on ' || t.LAST_UPDATE_DATE
FROM kcrt_transactions t
WHERE request_id =

Then replace with the ID of the request.