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]

NO it will give you the filtered list(only active locations) and the filter you see there you can use that to add more conditions but not inactive locations.

[Akanksha35]

@Anurag Tripathi  Right!!

[Anurag Tripathi]

So that should be acceptable. Right?

[Akanksha35]

I already tried reference qualifier, this will not solve my little bit  tricky requirement.

Thankyou for your reply.

[Anurag Tripathi]

What is not solved yet?