convert simple reference qualifier with Advanced reference qualifier

[Sandhya23]

How can I convert a simple reference qualifier to an advanced one when the filter requirements for the reference lookup list change? The old simple reference qualifier needs to be retained as part of the new advanced qualifier. I am not familiar with writing code for an advanced reference qualifier. Any guidance or pointers would be greatly appreciated.

[Amit Verma]

Hi @Sandhya23 

Could you please provide more details about your question? Do you just want to convert a simple reference qualifier to advanced? If yes, you can refer below documentation:

https://www.servicenow.com/docs/bundle/xanadu-platform-administration/page/script/server-scripting/c...

Thanks and Regards
Amit Verma

[Ankur Bawiskar]

@Sandhya23 

you will have to analyze the existing one and enhance based on your requirement.

please share your existing ref qualifier and what extra needs to be included

If my response helped please mark it correct and close the thread so that it benefits future readers.

[Sandhya23]

Parent Table Configuration:

Company Field: A reference to the core_company table.
Code Field: A reference to the code table, where a reference qualifier is applied. The code table also contains a Company field which reference to the core_company table.
Current Configuration:

The existing Simple reference qualifier filters codes with a condition where the code starts with "ABC", "XYZ", etc.
Additional Requirement:

When performing a lookup on the Code field in the parent table, in addition to the above conditions,  now the search results should include the records that:

Match the Company of the parent table with the Company in the code table.
Have the Chargeable field marked as true in the code table.