I am currently working on client requirement of displaying a new field in change request page.
As we know "change request" details page "detail_chg.htmpl" uses attributes of "chg" table.
For the new requirement i need to fetch attributes of "view_change_to_change_act_log" table to this page to define the logic.
actually i need to display a field which shows the detail for how much time(in hours) the CR is pending in particular group.for which i need "timestamp" att of "view_change_to_change_act_log" table to subtract from current date/time....
Can anyone help me defining the logic here?
How can i achieve the difference between two attributes of different tables and display it in htmpl page which is not mapped to it?
Looking at your requirement this sounds like something you can possibly achieve using OOTB means, without the need to modify forms and doing own calculations. See if perhaps Service Targets can help?
How to Create Service Targets - CA Service Management - 14.1 - CA Technologies Documentation