The CreatorCon Call for Content is officially open! Get started here.

Apply reference qualifier on the filter of list view

Swarupa1
Giga Contributor

Hello All,

I have applied the reference qualifier for the field on the form, it is working fine there However, when I am try to filter out the filed on the list view it is not working, it is showing all the values of the reference table.

Can anyone help me into to  How to apply reference qualifier on the filter of list view

Thank you for your help.

 

1 ACCEPTED SOLUTION

Hi,

dot walk to Active field and apply it

find_real_file.png

find_real_file.png

I hope I have answered your original question on why the ref qualifier doesn't work.

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

Regards
Ankur

Regards,
Ankur
✨ Certified Technical Architect  ||  ✨ 9x ServiceNow MVP  ||  ✨ ServiceNow Community Leader

View solution in original post

14 REPLIES 14

Hi,

dot walk to Active field and apply it

find_real_file.png

find_real_file.png

I hope I have answered your original question on why the ref qualifier doesn't work.

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

Regards
Ankur

Regards,
Ankur
✨ Certified Technical Architect  ||  ✨ 9x ServiceNow MVP  ||  ✨ ServiceNow Community Leader

Thank you for your help Ankur.

This is a brilliant answer, really helped me a lot. I was trying to pull a list of questions from a form so I could export it to an Excel list and really struggling. I was able to search by sys_id by dot-walking in the filter just like you said. Thank you!

Aman Kumar S
Kilo Patron

Are you talking about the list lookup popup that opens on clicking the lens icon on reference field?

By default it has the ref qualifier applied, and you don't explicitly see those in the filters above.

Best Regards
Aman Kumar

On Requested item table, on 'Item' field I have applied reference qualifier as a active true. 

so while searching on RITM form, it is showing only active catalog item. However If I am applying filter at requested item list for item field then there they are showing all catalog item(including active inactive)

 

Thank you for your response.