Help with advanced reference qualifier

Abhijit Das7
Tera Expert

Hi All , 

 

I am new to reference qualifier. I have a task to set reference field look up in such a way that , it should sort look up according to whatever is populated in that reference field .

 

For example: 

1. I have one reference field on cases and it is populated with value New_tenant.

 

ft1.PNG

2. Now once I open look up it should display only those record which start with New, like this.

 

ft2.PNG

 

In order to achieve this I want to use Advanced reference qualifier of that field and set look up in such manner. Please help suggesting something.

 

cc: @Ankur Bawiskar @kamlesh kjmar 

 

Thanks in advance.

1 ACCEPTED SOLUTION

kamlesh kjmar
Mega Sage
Mega Sage

Hi @Abhijit Das7 ,

 

For your use-case, first you need to decide one logic for the filter condition. For an example in the above screen shot you want your filter to search for record that starts with New so for that logic becomes :

 

Split the selected value by under score symbol and then use the first split to search, but this logic won't work if there a name with no '_' symbol in it.

 

You can think of another logic where you can split the selected value by space and use the first split as a search word but this will not work for the names which are separated by '_'

 

One last logic you can come-up with is take a substring of the selected name, say select first 3 characters of the selected name and use it for filtering.  This you can consider. I am showing you how you can achieve your functionality with this logic:

 

1. I am taking an example of a custom field in incident table Device Incident which is referencing to incident table.

 

kamleshkjmar_0-1675319138839.png

Now in this I am putting the logic that if you select any incident in this and then if you click on the search icon of the field it will filter and show only those incidents whose Number starts with first seven character of the incident already choosen. In the above example it will show incidents whose number starts with INC0019

 

kamleshkjmar_1-1675319433869.png

 

Below is the logic I have used in my reference qualifier of Device Incident field

 

kamleshkjmar_2-1675319597877.png

javascript:current.getValue("u_device_incident") != "" ? "numberLIKE"+(current.getDisplayValue("u_device_incident")).substr(0,7):"numberISNOTEMPTY"

 

Change your filter logic as per your requirement, but process of doing this will remain the same.

 

I hope this helps.

 

If this solution helps you then please hit the Helpful button and if this solves your issue then hit Accept button as well.

 

Regards,

Kamlesh

View solution in original post

20 REPLIES 20

Voona Rohila
Kilo Patron
Kilo Patron

Hi @Abhijit Das7 

Can you explain a bit more of your requirement.

You want to achieve something like this :

if we type the letters then all the related references comes up

VoonaRohila_0-1675243057676.png

 


Mark it helpful if this helps you to understand. Accept solution if this give you the answer you're looking for
Kind Regards,
Rohila V
2022-25 ServiceNow Community MVP

Hi @Voona Rohila 

 

Please explain this method also like typing a letter .

Thanks

Its OOTB feature by ServiceNow in reference fields.


Mark it helpful if this helps you to understand. Accept solution if this give you the answer you're looking for
Kind Regards,
Rohila V
2022-25 ServiceNow Community MVP

Sharif Nawaz
Tera Contributor

Hi @Abhijit Das7 ,

 

1. On the form, right click on the "CareAR Instruct Experience" click on "Configure Disctionary".

2. Now a Dictionary Entry will open.

3. In the "Reference Specification" Tab, in Reference qual Condition, add a condition.

4. Name >> Starts With>> New.

5. Click on update.

 

This will allow you to search only the results starts with New.

 

Hope this answers your question, Please mark it as helpful, if it helps.

 

Regards,

Nawaz