Filtering on Lookup using list

[Jan Zemcak]

Hello devs,

I would like to know if it even possible to filter the record based on column value.

As you can see, on the picture, I have to select Workcenter (1) click on serach icon (2) and I have to type 'config' there. (3)

Is there the way to filter the Reference list based on type of column ?

(I know there is filter to be used as filter but I am curios if this is even possible)

Thank you for any suggestions.

[Manmohan K]

Hi @Jan Zemcak ,

Yes It is possible to filter the Reference list based on type of column. You can use reference qualifier in the reference field and use dot walking to achieve it

If you do not know how to dot walk, then refer below article

https://docs.servicenow.com/bundle/tokyo-platform-user-interface/page/use/navigation/reference/dot-w...

[Jan Zemcak]

Yes I can archieve this on the reference field on form but this is LIST of the records.
This must be done somehow over the INVENTORIES table.

[Manmohan K]

@Jan Zemcak ,

In the filter, select  show related fields and then again click on filter and search with workcenter and select it.

Now search with type and select it 

Now provide condition Type is config

[Ankur Bawiskar]

@Jan Zemcak 

if you apply reference qualifier it will work both on form and list

what's your challenge?