I would like to create a report listing all Standard Change Templates, and include the fields from the 'Change Request Values' tab.

NSB2
Kilo Contributor

I haven't been able to link from the Standard Change table to the Change Request Values (dot walking).  If you could help identify the right starting table, and the field to use to dot walk to another table, I'd appreciate your help!

4 REPLIES 4

Alikutty A
Tera Sage

 

Hello,

You can get the required data from std_change_template table, This is where the actual template values are stored. You can navigate to this table and then add the Template column on your list view. The template column contains the Change Request values as an encoded query. This is how the data is stored for all templates as it is condition string.

Thanks!

NSB2
Kilo Contributor

Thank you!  Our DevOps team was able to decode and provide in the report writer, so I'm now able to report off of it.

Priya Mohan
Mega Contributor

Hi ,

Any idea how it was done?

Can you tell how to decode these values from encoded query ?