I would like to create a report listing all Standard Change Templates, and include the fields from the 'Change Request Values' tab.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
11-30-2018 04:47 PM
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!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
12-01-2018 09:29 AM
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!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
01-28-2019 01:12 PM
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-12-2022 01:18 AM
Hi ,
Any idea how it was done?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
10-26-2023 06:07 AM
Can you tell how to decode these values from encoded query ?