Extend user criteria

Service Catalog enables you to extend user criteria to match against additional reference fields in the User [sys_user] table, such as hidden or custom fields, without using a script.

About this task

You can then add a matching field in the User Criteria [user_criteria] table, allowing you to define conditions based on this field in user criteria records.
Note: The column on the User table must be a reference field, and the matching column on the User Criteria table must be a glide_list type field. Also, both columns must have matching names. Columns with a U prefix are catered for. For example, cost_center and u_cost_center are considered as matching.

Procedure

  1. Navigate to System Definition > Tables.
  2. Locate and open the User Criteria record.
  3. In the Columns section, insert a row for the new field.
  4. Set the type to List and select the appropriate reference field. For example, select cmn_cost_center to set criteria based on cost centers.
    You have a step with a list, note, and image.
  5. Navigate to Service Catalog > Catalog Definition > User Criteria.
  6. Select or create a user criteria record, and see that you can now use the new field.

What to do next

You can further extend the User Criteria table to match against any columns in other tables. In the User [sys_user] table, add a new reference field to the other table. Then extend the user criteria table to refer to that reference field, as described.