The motivation to write this article comes from this post. https://community.servicenow.com/community?id=community_question&sys_id=336b4737db45d850190dfb243996...

There was a requirement to build a catalog form for rehiring candidates . So we had to create a lookup field on catalog which should show inactive user records.

So by default there is a business rule called "User Query" which is a before query business rule which restricts and shows only active records in both portal and classic view. So we had to do a workaround to make things work.

Thanks to community as always.

Long story cut short .. So here's the code.

• Edit the business before query business rule and make these changes.
• We don't need to change business rule condition

var checkVar = gs.action.getGlideURI().toString().indexOf("5e769c02db3998106a8d92b8f49619ec"); //sys_id of the reference field on the catalog form

var checkRefererVar = GlideTransaction.get().getRequest().getHeader("referer").toString().indexOf("c3d19c4adbf598106a8d92b8f49619d9"); //sys_id of the catalog item

if(checkVar != -1 || checkRefererVar != -1){

}

else {

current.addActiveQuery();

}

This code will work like charm and it will show you inactive records on portal. Best part is we can also do the same for a variable set and re use the variable set.

Kindly mark this article as helpful if this solves your requirement. Let me know if you have any queries.

Thank you!.