Need to create a Report on Assignment Rules Table?

[Aruna Nadagoun1]

Hello Everyone,

So I have a requirement to create a report on Assignment Rules.

Based on different conditions like Request Type and Country we are assigning to a specific Group.

So Now we want to have visibility of all the conditions .. based on which conditions it is assigned to which Group?

[1__AnithaHV]

Hi @Aruna Nadagoun1 ,

You create a report on the table sysrule_assignment abd you can have the column 'condition' in the report.

Thanks & Reagrds,

Anitha H V

[Aruna Nadagoun1]

You see the values in the conditions are not readable/easily understandable. Can we make something to show Display Values?

[Robbie · Accepted solution]

Hi @Aruna Nadagoun1,

By default, 'system tables' are not reportable, however, you can easily add the 'Assignment Rules' table to the system property to allow this.

Naviagte to the System Properties by typing 'sysrule_assignment.list' into the Nav menu.

Then search for the property name: glide.ui.permitted_tables and add the assignment rule table to the permitted list (as show below).

Once added, you can select the Assignment Rules table within reports and can filter as desired and required (See second screen shot below)

To help others (or for me to help you more directly), please mark this response correct by clicking on Accept as Solution and/or Helpful.

Thanks, Robbie