Verified Answers


If an answer to your question is correct, click on "Verify Answer" under the "More" button. The answer will now appear with a checkmark. Please be sure to always mark answers that resolve your issue as verified. Your fellow Community members will appreciate it!  Learn more

  • State Verified Answer
  • Replies replies
    2
  • Subscribers subscribers
    8
  • Views views
    262
  • Users 0 members are here
  • Locked Locked
Related
Options
This discussion has been locked.
You can no longer post new replies to this discussion. If you have a question you can start a new discussion

How to Access a Request's Attribute History

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

  • Verified Answer

    0
    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
  • 0
    Thank you very much for the info Vince.

Resources

Support
Documentation
Learning Services
Partner Programs
Privacy
Compliance
Help
Company
Privacy Policy
Terms of Use
Cookies Preferences
Accessibility
Anti-Slavery Statement
Support
Contact Us
Careers
Code of Business Conduct and Ethics
The opinions expressed above are the personal opinions of the authors, not of OpenText. By using this site, you accept the Terms of Use. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.), Hewlett Packard Enterprise Company, or Micro Focus. As of January 31, 2023, the Material is now offered by OpenText, a separately owned and operated company. Any reference to the HP, Hewlett Packard Enterprise/HPE, and Micro Focus marks is historical in nature and the HP, Hewlett Packard Enterprise/HPE, and Micro Focus marks are the property of their respective owners.