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
    6
  • Subscribers subscribers
    4
  • Views views
    774
  • 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 send the values from history table for an asset in an email

Indrakumar Gowda

Dears,

I need to send an email to my customer for verification of some important columns.Example as below.

I have already enabled the history on the needed columns. which ever column is updated with that transactions need to highlight and send as an email.

Please let me know.

  CurrentValue Previous Value
HostName ABC  
Application Owner Indra Kumar
Appliaction Name CTS CBS
Criticality Critical  

Thank you.

Regards,

Indra 

Parents
  • 0

    Please review the History table structure via Designer application.  Since the "link" to this table from the context table is in reverse (ie. n-1), use of the 'ID of link Referenced object (lHistObjId)' with the context table primary key will help identify which history table records to pull into the email notification.  The context table elements with "Keep history" attribute enabled can be identified by the respective SQLName stored under 'Field or link (Field)' of history table.

Reply
  • 0

    Please review the History table structure via Designer application.  Since the "link" to this table from the context table is in reverse (ie. n-1), use of the 'ID of link Referenced object (lHistObjId)' with the context table primary key will help identify which history table records to pull into the email notification.  The context table elements with "Keep history" attribute enabled can be identified by the respective SQLName stored under 'Field or link (Field)' of history table.

Children
  • 0 in reply to 

    Please let me know how to write the same query inside the messaging, for example if i write [Computer.tcpiphostname] it will get the value of host name. if i write [History.PreviousVal] it will give the previous val of the last updated column in the table for this record, but i need to show all the columns. could you share any example if you have.

    Thank you.

    Regards,

    Indra

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.