Remove all value from reference field

[Omkarbh1997]

Hi,

Requirement:- When user select "Purpose" field as 'Automotive build-up' then above "Select OUC" all value should be clear and only shown some specific 6 records from that table after click on magnify glass icon, there is already configure Reference Qualifier query. below ss are available for reference.

existing query on reference qualifier.

Thank You.

[Brad Bowman]

You can do this all in an Advanced Reference qualifier, but it will be easier in a Script Include.  Switch the qualifier to advanced, then copy the encoded query somewhere else for later.  Change the qualifier to call a Script Include function, passing in the name of the OUC field or variable as an argument.  The Script Include will simply return your existing encoded query if OUC is blank, otherwise it will return the 6 specific sys_ids.

[Omkarbh1997]

Can you please provide Script for this

[Juhi Poddar]

Hello @Omkarbh1997 

You can try something like this in advanced reference qualifier section of variable Select OUC

javascipt:current.variables.purpose == "sys_id_of_automotive_build_up" ? "add encoded query": "";

• current.variables.purpose : modify the field name purpose as it is in your instance
• sys_id_of_automotive_build_up : sys_id of automotive build up record
• add encoded query : this should be the encoded query 

Adding screenshot for better understanding:

Below screenshot demonstrate how to copy Encoded query directly after building the query.

Hope this helps!

"If you found my answer helpful, please like and mark it as an "accepted solution". It helps future readers to locate the solution easily and supports the community!"

Thank You
Juhi Poddar

[Omkarbh1997]

Hi @Juhi Poddar 
I have to also mentioned the existing reference qualifier query with the above requirement, which I mentioned in the post. How should I do?