How do you query standard change templates based on the fields configured to be used in the change?

[Kristian Johns3]

For instance, if I wanted to find all standard change templates that would create standard changes for the Database Administrator group, how could I do that? It doesn't look like the Change Request Values available in the proposal definition are available in the list builder of the std_change_record_producer table. It's similar to reporting on request item variables, but there doesn't seem to be an obvious way.

Specifically, I need to find all standard changes templates that assign changes to a group without a manager. Any suggestions?

[rahulpandey]

Hi,

The values which you define on templates are not actual variables/fields but the UI macro which are dynamically/programmatically created elements. So to get list of off standard change template which assign changes to a group would not be possible.

[Alikutty A]

Hello,

The change request values are stored in a table named "std_change_template" in encoded query format. You may not be able to directly report on it as it is a condition string and not field value pairs.

Ideally You will need to maintain a relationship with the change to its related template(reference) to easily report on the changes for Database group. The template should then be set on the change request values, so when a change is created it would be auto populated. You could then report on the group and template fields to get your required data.

Alternate way is to keep your change short description as read only and then report on it to determine changes assigned to your database group with the specific short description but this is not a standard approach.

Thanks!

[Alikutty A]

If I have answered your query, request you to mark a response as correct answer and close this thread. Thanks!

[Andrea H]

If you're just looking to find a list of the standard templates, there actually is a way you can do this as someone with admin access. You'll need to know the sys_id of the group you want to query by. Enter std_change_template.list in the filter navigator. Add Template to your list of columns. Either enter * then the sys_id of the group in the search row under Template or use the filter and select Template contains the sys_id of the group.