How to add the filter condition by default for the reference look up in list view

[avinashpotp]

I have created New field called "Work Type" in demand table with the type as LIST and with the reference as Choice table and added the simple filter condition.
So in the form View for the Work Type field when i click on magnifying glass it shows limited records(19 records) and i have filtered and it is working fine.

PFB

But in the Demand list view, when i click on filter icon and add the condition as Work Type contains and then click on magnifying glass, pop up window opens with the [sys_choice] table and it is showing all the records (Around 37k).

It should show only 19 records which shows in the form view.
Can anyone help me in filtering the values in referenced lookup.

[Arun_Manoj]

Hi @avinashpotp ,

In the dictionary configuration for the work type field 

Reference qual condition will be there in form view.

But , in list view there is no

Reference qual condition.

[Ankur Bawiskar]

@avinashpotp 

how is the reference qualifier configured on the list field? share screenshot

If it depends on some other field then are you sure in list view you selected that field first

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

[Robert H]

Hello @avinashpotp ,

Reference qualifiers on List fields do not apply to the Condition Builder.

You should create a dedicated table for the Work type options.

How were you even able to create a List field that references the sys_choice table? ServiceNow has built in an explicit restriction here, meaning this is not an intended configuration and might cause unexpected results.

Regards,

Robert