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

Sagar Pagar · ‎06-26-2023

Hi @Mounika Tungala,

The User criteria will not be applicable for Standard change proposal templates.

Here is the supportive KB: KB0783021: User Criteria not working on the Standard Change Templates

Thanks,

Sagar Pagar

The world works with ServiceNow

Sagar Pagar · ‎06-26-2023

Here is another related supportive KB: KB0999197

Thanks,

Sagar Pagar

The world works with ServiceNow

Mounika Tungala · ‎06-26-2023

Hi Sagar Pagar,
Thank you so much for your immediate response. If adding the user criteria in the proposal table is not possible how can I achieve this? Is it possible with a script? if yes can you give me some lead here.
I need to restrict templates based on the group that the user provides.

Sagar Pagar · ‎06-26-2023

Hi @Mounika Tungala,

as mentioned in KB: KB0783021: User Criteria not working on the Standard Change Templates, apply the User criteria for Service catalog or Category mentioned in the below system property.

/std_change_properties.do?sys_id=527b5dafff700200b18affffffffff89

Thanks,

Sagar Pagar

The world works with ServiceNow