Only display active locations

[DreDay3000]

Hello, I have added an 'Active' field to the locations table (cmn_location). I would like to only display active locations on any table. If I select a location from any table, I would only like to see active locations

[Ankur Bawiskar · Accepted solution]

@DreDay3000 

yes that's correct.

But since you mentioned this should happen in every table which has location field, better to use Query business rule on cmn_location table as per what I shared above.

With this you need not worry on updating reference qualifiers on those many fields

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

[DreDay3000]

This has caused an issue where there are no records displayed on the cmn_location list view. Can the inactive records still be visible and only show active locations on any table with the location field?

[DreDay3000]

will setting active is true on the location table display only active records?

[Dr Atul G- LNG]

yes, thats correct.

[DreDay3000]

This will show only active location on any table?

[Dr Atul G- LNG]

Which table are you making changes to? If it's the location table itself, then yes, that would work.