Anyone know what the table is or how to find all policy actions??

Wendy Peterson · ‎01-23-2018

We have a value on change requests that is hidden. I wanted to know if there is a easy way to identify all the values on that table without going into each UI Policy to see what actions are below it? TIA

jimnicholson · ‎01-23-2018

Hi Wendy,

I believe the table you need is sys_ui_policy_action (sys_ui_policy_action.list in navigator)

Something like one of these would return all UI Policy Actions on the change_request table.

{your instance}/nav_to.do?uri=/sys_ui_policy_action_list.do%3Fsysparm_query%3Dui_policy.table%253Dchange_request%26sysparm_first_row%3D1%26sysparm_view%3D

or

{your instance}/nav_to.do?uri=/sys_ui_policy_action_list.do%3Fsysparm_first_row%3D1%26sysparm_query%3Dtable%253Dchange_request%26sysparm_view%3D

View solution in original post

Wendy Peterson · ‎01-26-2018

No I am trying to find out what Policy out of 50+ has a certain field on it without going through every single one.

jimnicholson · ‎01-26-2018

Did my answer above not help? It would list the fields in every UI Policy on the change request table.