Welcome Serena Central users! CLICK HERE
The migration of the Serena Central community is currently underway. Be sure to read THIS MESSAGE to get your new login set up to access your account.
Highlighted
Patch Absent Member.
Absent Member.
224 views

How to Access a Request's Attribute History

Jump to solution
I have a request type, for example, MY_REQUEST_PR, which has "Save history" as an enabled option. There is a user-defined Attribute called "PR_CLASSIFICATION". The "PR_CLASSIFICATION" attribute, has the local property "Keep history" option ticked.

In the desktop client. When you right-click on the request MY_REQUEST_PR_001 and click on History, it will show in the 'Update Note' column that "Request attribute(s) updated".

QUESTION: How is it possible to view the change history of the attribute "PR_CLASSIFICATION"? See what it was previously, and what it has changed to, and when?

Note (FYI), Additionally, the attribute "PR_CLASSIFICATION" has an associated valid set "PR_CLASSIFICATION_VS".

This is my first post. Sorry for my ignorance.
Thanks in advance.
0 Likes
1 Solution

Accepted Solutions
vcodd Absent Member.
Absent Member.

Re: How to Access a Request's Attribute History

Jump to solution
Hi Patrick

You can use the Published View called PCMS_CHDOC_HISTORY_WITH_ATTR to query this information directly from the database. Details of how to install the Published Views can be found in the Reports Guide and this document also contains a detailed description of all the views and their columns. When you query the data back for this particular view you will see an entry for the existing attribute value and another column called OLD_ATTR_VAL which contains the previous value.

If you don't have a copy of the document mentioned you can download all Dimensions CM documentation from http://help.serena.com/doc_center/doc_center.html#dcm

Vince

View solution in original post

0 Likes
2 Replies
vcodd Absent Member.
Absent Member.

Re: How to Access a Request's Attribute History

Jump to solution
Hi Patrick

You can use the Published View called PCMS_CHDOC_HISTORY_WITH_ATTR to query this information directly from the database. Details of how to install the Published Views can be found in the Reports Guide and this document also contains a detailed description of all the views and their columns. When you query the data back for this particular view you will see an entry for the existing attribute value and another column called OLD_ATTR_VAL which contains the previous value.

If you don't have a copy of the document mentioned you can download all Dimensions CM documentation from http://help.serena.com/doc_center/doc_center.html#dcm

Vince

View solution in original post

0 Likes
Patch Absent Member.
Absent Member.

Re: How to Access a Request's Attribute History

Jump to solution
Thank you very much for the info Vince.
0 Likes
The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.