Maximo Open Forum

 Manage domain value based on security group

  • Everything Maximo
  • Functional
  • Security
Mike Starkey's profile image
Mike Starkey posted 03-18-2025 15:49

We have a request to have a domain value hidden for everyone except for a specific security group.  I have found how to hide a domain value, but have not found a way to make it visible for a specific user or security group.   Is there a way to do this?

Jessica Williams's profile image
Jessica Williams

Hi Mike,

From the Conditional Expression Manager, you can create a condition: exists(select 1 from groupuser where userid=:USER and groupname='XXX')

Then from Domains, open the domain, and for the value you want conditionally shown, View/Modify Conditions, and add the condition.

Does this work for your use case?

Jess Williams

Mike Starkey's profile image
Mike Starkey

Hi Jessica,  Unfortunately this did not work for me.  Could it be that I am trying to do this with the CREWID domain on work orders?

Hariprasad R's profile image
Hariprasad R

Hi Mike, 

Could you please share the condition you used? That would be helpful in understanding the issue. Have you tested it with different security groups to check if the restriction is working as expected?

Thanks

Mike Starkey's profile image
Mike Starkey

I used this condition: exists(select 1 from groupuser where userid=:USER and groupname='LOCK') and called it "WU_HIDEPASS".  I then associated this condition with a crewid value called PASS in the domain.

Tinnokesh AP's profile image
Tinnokesh AP

Hi Mike, 

Could you try below

exists (select 1 from groupuser where userid=:&PERSONID& and groupname='LOCK')

OR

exists (select 1 from groupuser where userid=:&USERNAME& and groupname='LOCK')