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]

Hi @DreDay3000 

Then, you need to create a dictionary override on all relevant tables. For example, in the user table, we have the location field. You should add the reference qualifier where the location is active = true.

Alternatively, you can add the field to the task table and set the reference qualifier filter there. This will ensure that any table extending from the task table will use the location field and only show active locations.

[J Siva]

Hi @DreDay3000 
You can create one Read ACL on the cmn_location table wih condition, active = false and the required role should be admin.
So that, the inactive loactions will be visible only to admins not for other users. OR you can use query business rule.
For more info, you can review the below community post.
https://www.servicenow.com/community/developer-forum/global-reference-qualifier/m-p/2616150

Regards,
Siva

[Community Alums]

HI @DreDay3000 ,

Wherever you are using this location table as reference, you can set the conditions in the reference qualifier as below:

https://www.servicenow.com/community/itsm-forum/reference-qualifier-for-active-records/td-p/530553

[Ankur Bawiskar]

@DreDay3000 

So you added field on Location table

Since you want to show only active locations from any table's field then you can create query business rule on cmn_location table

Something like this

BR Condition:

gs.getSession().isInteractive()

Script:

(function executeRule(current, previous /*null when async*/) {

	// Add your code here
	current.addQuery('u_active', true);

})(current, previous);

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