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.

[Dr Atul G- LNG]

Is there anything wrong with my answer as it was low code/ no code?

[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]

using the business rule does only show active locations, however inactive locations are nolonger visible on the cmn_locations table. Can all records show on the cmn_location table?

[DreDay3000 · Accepted solution]

 navigate to task.do and set the ref qual for the location field to active=true

 navigate to sys_user and set the ref qual for the location field to active=true

[Dr Atul G- LNG]

I think I suggested you same already this.