User exclusion

AhuelieW
Tera Contributor

Hello guys,

Hope you can help me.

 

I've created a catalog item where we have two fields (Primary owner and alternative owner). Both of them reference the sys_user table

I want to do is exclude the primary owner from the alternative owner list. For example, if you select "wilson" for the primary owner, this "wilson" shouldn't be available in the alternative owner list

1 ACCEPTED SOLUTION

Hi @AhuelieW ,

in context of catalog item you can use this

on alternative owner variable

javascript:'sys_id!='+current.variables.primary_owner;

 

Please mark my answer as helpful/correct if it resolves your query.

Regards,
Chaitanya

View solution in original post

4 REPLIES 4

Chaitanya ILCR
Kilo Patron

Hi @AhuelieW ,

 

open the dictionary record of Alternative Owner field and add a reference qualifier

javascript:'sys_id!='+current.u_primary_owner; 
replace u_primary_owner with your Primary owner field backend name

 

if you want to the other around too to exclude alternative owner on primary owner field

do the samething

open the dictionary record of Primary Owner field and add a reference qualifier

 

javascript:'sys_id!='+current.u_alternative_owner;

replace u_alternative_owner with your alternative onwer field backend name

 

ChaitanyaILCR_0-1749833387326.png

 

 

Please mark my answer as helpful/correct if it resolves your query.

Regards,
Chaitanya

Hi ,

Thanks for your response. Unfortunately it didn't work.

Here is the context: These variables only exist within my catalog item (Shared drives request), that means they don't really have a dictionary. However we can add the reference qualifier under Type specifications in the advanced view. This where i've entered the piece of code you provided But no luck... Still not working. 

javascript:'sys_id!='+current.primary_owner

 

 

AhuelieW_1-1749835097119.png

 

AhuelieW_2-1749835179260.png

 

 

Hi @AhuelieW ,

in context of catalog item you can use this

on alternative owner variable

javascript:'sys_id!='+current.variables.primary_owner;

 

Please mark my answer as helpful/correct if it resolves your query.

Regards,
Chaitanya

That works, Thank you so much