How to add condition for custom field on 'Standard Change Proposal' record

[Mounika Tungala]

Hi All,

Can anyone help me with this, please!!

I have a custom field on the Change table (Affected countries) that references the 'cmn_location' table. I need to add a condition to show only a few countries while creating a standard change proposal. Since all the fields come under the 'Change Request values' on a proposal, I am not sure how we can add conditions to the specific field.

[Hemanth M1]

Hi @Mounika Tungala ,

you can try this : https://www.servicenow.com/community/developer-forum/applying-reference-qualifiers-on-standard-chang... 

this is before query BR , please be careful while implementing 

However i would recommend : if you want to restrict to show only few countries why don't you do it in the change record itself may be based on user role/group etc...

[Mounika Tungala]

Hi @Hemanth M1 

Thanks for your reply. I have used the reference qualifier to show only the required countries in this field on the change form with the help of 'gs.getProperty' but this is not helping on the proposal form for the same field.

Is gs.getProperty work on the proposal form for that change request fields? or else I need to go with some other approach other than using the above BR. Because of the above BR, I could see it will create some issues in the backend.

[Mounika Tungala]

@Hemanth M1 Can you please open the below question that I posted and help me if you have any solution for it?

https://www.servicenow.com/community/itsm-forum/how-to-create-a-report-to-get-average-time-from-crea...