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?

[Blair5]

Any users can use it.

[solutioningnow]

Hi Blair,

I think it will be tough to achieve by altering anything in the query business rule, because system will never know in the query business rule where this is calling from any specific table or any specific catalog item.

I think you will need to disable the business rule and achieve this using read ACLs on user table. But using ACLs one drawback is other than admin user, users will see a security constraints message always.

Best way to achieve such type of requirement is to have one more text variable under catalog item variable, where user can enter text / name of the user.

Please mark answer as Helpful/Correct, if it was really helpful

Regards,

Solutioner

Enhance Knowledge NOW@ www.solutioningnow.com

http://www.solutioningnow.com/

[Bhavesh Jain1]

Small change in my query.

Instead of >=0 in condition...do ==-1.

[Blair5]

Still no luck

[randrews]

I have this working on two different catalog items in our instance... on the item make it a reference field to sys users...

add this as a reference qualifer... sys_id>''

now go find the BR for "user query that runs on sys_user table... and on the if statement make it read...

if (!gs.hasRole('user_admin') && !gs.hasRole('view_inactive_user') && (current.getEncodedQuery().indexOf('sys_id>')== -1))

from there it should simply work..if this resolves your issue please mark this as answered.