How to add User criteria on 'std_change_proposal' table

Mounika Tungala · ‎06-26-2023

Hi All,

This is an urgent requirement to implement. Can anyone help me to fix this issue, please!!

OOB User criteria is not available on 'std_change_proposal' table and we are not even able to add it from the related list. Is there any way to add User criteria i,e Available for, Not available For on the 'std_change_proposal table'?

Patrick Laroch1 · ‎06-27-2023

Ok, I think I understand better. To confirm, you wish for the individual proposing a new Standard Change to be able to identify for who the Catalog Item will be available for.

If that is correct, you will need to account for the versioning. So I would probably:

1. add 2 custom List fields to the Proposal referenciong the User Criteria table "Available for" and "Not Available for".

2. Create a Flow (or BR) on the std_change_record_producer table to run on Change to the current_version field to update the related lists.

View solution in original post

Mounika Tungala · ‎06-26-2023

Hi @Sagar Pagar ,

Can you elaborate, please? If I modify the property it will affect the other areas right? and the article KB0783021 is talking about the template issue not the proposal restriction.

Sagar Pagar · ‎06-26-2023

Hi @Mounika Tungala,

Yes. if you modify the property it will impact other areas. The KB is related to "Standard change templates".

For Standard change proposal you have to control it using the ACLs.

Thanks,

Sagar Pagar

The world works with ServiceNow

Mounika Tungala · ‎06-26-2023

Hi @Sagar Pagar,

Thank you for your continued support on this question. My Primary goal is to bring user criteria to the proposal form. if this is not possible then I need to manage the user criteria with scripting.
Ex: Assume I created one field on the proposal table that references to sys_user_group table. So when the user selects a particular group in that custom field, user criteria should be created with the group field mapping. Will something like this work?
So that whoever creates these proposals can put the restrictions even before the proposal goes for change control team approval.

Patrick Laroch1 · ‎06-26-2023

I can add the 2 related lists in my dev instance and it is providing expected results.

Mounika Tungala · ‎06-26-2023

Hi Patrick,

Not on Standard Change Template form. I need to have this user criteria on 'Standard Change Proposal' form