Triggering a business rule off a related list record

[James174]

I have a requirement where I need to restrict change_manager role being able to edit User Criteria unless it is related to a standard change template. I have been trying to achieve this via an on insert/update business rule on the user_criteria table. I need a condition that checks the 'Available for' section and checks if the catalog item class on that record is standard change template?

I've got the when to run role condition and abort action sorted. It's just the condition to check the available for as this cant be reached from the when to run condition builder

Or open to any other solutions

Thank you

[LJ86]

Hi James,

You will need a Business Rule on a different table - User Criteria records can be reused for different purposes in ServiceNow, not just for Catalog Item visibility, so you wouldn't want Change Managers updating them directly.

The table you need to look at is called 'sc_cat_item_user_criteria_mtom' (Catalog Item Available for) - you should be able to access Catalog Item's class by dot-walking from there.

Let me know if you need further help with this.