Reference field to show inactive users for catalog item and assoc. tasks

[Blair5]

I found a discussion regarding inactive users being shown on a catalog item. --> Reference field not showing inactive users for our asset team

I'd like to show the inactive users on the catalog item (Offboard a user) and all subsequent tasks. The discussion I found addresses catalog item part, but not the TASK part. Does anyone have any ideas?

[Shirali]

Hi,

I tried putting the same code in User Query business rule as below just replaced the sys_id with my catalog item's sys_id.

1. if(!gs.hasRole("admin"){    
2. if(current.getEncodedQuery().indexOf('sys_id=ae20225e0a0a3cac00b8ac8dbc5c018a') >=0)  
3. {    
4. current.addQuery("active", "true");    
5. }    
6. }

But when we open that catalog item it always returns -1, that means it is not finding that sys id. what should be the issue. Also it is not auto populating the related values like Requested for manager, Requested for email etc. Could you please explain me what else i need to do to auto populate related values for inactive users on catalog item

[sgrison]

I see 2 approaches to this:

1) Do something similar to what solutioner now suggested.   Create a new variable to capture the user name of the user offboarding

2) Inactivate the global business rule and add reference qualifiers to fields which reference the sys_user table

- Caller

- Assigned To

- Requested For

etc

Personally I would go with option 2, could be setup fairly quick.