Want to apply a removable filter on the sys_popup view

[Akanksha35]

We have created a custom field  Active on the Location(cmn_location) table. It holds the value true or false.

The requirement is when we access the  reference field location from IM/CM/PM module, user can see the  active True records, but they can remove the filter and can see all the records , active and inactive both.

How to create this removale filter on sys_popup view.

[Anurag Tripathi]

Hi Akanksha,

Popup Views should be read only. Are you saying you can open a popup view and edit the field value?
Is it working as expected on the normal view? Default or whatever view you are using?

Also the requirement looks like you need to add a reference qualifier on the reference field, and it should work regardless of view.
Can you add some screenshot?

[Akanksha35]

Hello @Anurag Tripathi ,

I am adding a screenshot to help understand the requirement. When clicking on magnifying glass icon of location field, i should get a list of active =true records, also i can remove the "active=true" filter to get the active  false records also.

[Anurag Tripathi]

Understood.

So what you need is , create a dictionary override for location field on the table in Question(Incident for EG)

Create a new dictionary override for incident and change the reference qualifier

[Akanksha35]

Hi @Anurag Tripathi ,

I tried that already , this does not give us the filter "active = true" to remove and get the list of all the locations again. 

similarly query BR does the same. 

I need a filter in the breadcrumb so that user can remove it if they want to have a look on active false records.