Maximo Open Forum

I think you are missing the colon sign (:) in front of field names.

Something like:

:WORKTYPE!='IL' or :THD_WORKCODE not in ('MECH CONTRACT LABOR','MECH PARTS MGT')

Thanks Dragos. I have tested your expression, but I am still able to Complete the WO unless both requirements are met. I don't know why the "OR" is not being triggered. The system is processing the OR as an AND, and it shouldn't. Has anyone else experienced this with conditional expressions?

I think you are missing the colon sign (:) in front of field names.

Something like:

:WORKTYPE!='IL' or :THD_WORKCODE not in ('MECH CONTRACT LABOR','MECH PARTS MGT')

Try this:

(:WORKTYPE!='IL') or (:THD_WORKCODE not in ('MECH CONTRACT LABOR','MECH PARTS MGT'))

Thanks Dragos. I have tested your expression, but I am still able to Complete the WO unless both requirements are met. I don't know why the "OR" is not being triggered. The system is processing the OR as an AND, and it shouldn't. Has anyone else experienced this with conditional expressions?

I think you are missing the colon sign (:) in front of field names.

Something like:

:WORKTYPE!='IL' or :THD_WORKCODE not in ('MECH CONTRACT LABOR','MECH PARTS MGT')

Same thing happens. I am able to Complete the WO unless both requirements are met. Your expression makes total sense, so I don't understand why it isn't being applied correctly.

------------------------------
Carlos Mestre
Home Depot
------------------------------


Original Message:
Sent: 06-21-2023 11:21
From: Dragos Chitu
Subject: Conditional Expression on Security Group

Try this:

(:WORKTYPE!='IL') or (:THD_WORKCODE not in ('MECH CONTRACT LABOR','MECH PARTS MGT'))

------------------------------
Dragos Chitu
EL


Original Message:
Sent: 06-21-2023 11:08
From: Carlos Mestre
Subject: Conditional Expression on Security Group

Thanks Dragos. I have tested your expression, but I am still able to Complete the WO unless both requirements are met. I don't know why the "OR" is not being triggered. The system is processing the OR as an AND, and it shouldn't. Has anyone else experienced this with conditional expressions?

------------------------------
Carlos Mestre
Home Depot


Original Message:
Sent: 06-21-2023 11:00
From: Dragos Chitu
Subject: Conditional Expression on Security Group

I think you are missing the colon sign (:) in front of field names.

Something like:

:WORKTYPE!='IL' or :THD_WORKCODE not in ('MECH CONTRACT LABOR','MECH PARTS MGT')

------------------------------
Dragos Chitu
EL

Hi Carlos,

You could try this to meet all conditions.  From logic or means one or the other but not both.

:WORKTYPE!='IL' or :THD_WORKCODE not in ('MECH CONTRACT LABOR','MECH PARTS MGT') or (:WORKTYPE!='IL' and :THD_WORKCODE not in ('MECH CONTRACT LABOR','MECH PARTS MGT'))

Hi James and Dragos, 

Thank you both for your help, but I am still having the same issue. I have tried all the conditions you both have recommended, but I am still able to complete the WO unless both the Work Type = IL AND the Work Code = 'MECH CONTRACT LABOR' or 'MECH PARTS MGT'. I am not sure why it's not working.

Hi Carlos,

You could try this to meet all conditions.  From logic or means one or the other but not both.

:WORKTYPE!='IL' or :THD_WORKCODE not in ('MECH CONTRACT LABOR','MECH PARTS MGT') or (:WORKTYPE!='IL' and :THD_WORKCODE not in ('MECH CONTRACT LABOR','MECH PARTS MGT'))

Could you try :WORKTYPE!='IL' or :THD_WORKCODE not in ('MECH CONTRACT LABOR','MECH PARTS MGT') and :user in (select userid from groupuser where groupname = 'SECURITYGROUPNAME')

Replace SECURITYGROUPNAME with the name of the security group you are applying the restriction to.  Then apply the restriction to the COMP value of the WOSTATUS domain and Condition Number is your condition.  If you leave Object Name blank it applies to all applications that use the WOSTATUS domain like Workorder, PM, etc.  May require entering WORKORDER for the Object Name field.

Hi James and Dragos, 

Thank you both for your help, but I am still having the same issue. I have tried all the conditions you both have recommended, but I am still able to complete the WO unless both the Work Type = IL AND the Work Code = 'MECH CONTRACT LABOR' or 'MECH PARTS MGT'. I am not sure why it's not working.

Hi Carlos,

You could try this to meet all conditions.  From logic or means one or the other but not both.

:WORKTYPE!='IL' or :THD_WORKCODE not in ('MECH CONTRACT LABOR','MECH PARTS MGT') or (:WORKTYPE!='IL' and :THD_WORKCODE not in ('MECH CONTRACT LABOR','MECH PARTS MGT'))

Thank you, James. I have replaced 'SECURITYGROUPNAME' with the actual security group, and I have applied this condition to the COMP value of the WOSTATUS domain and set the object to WORKORDER. Now, I am able to complete a WO even if work type = IL and Work Code = 'MECH CONTRACT LABOR' or 'MECH PARTS MGT'

Could you try :WORKTYPE!='IL' or :THD_WORKCODE not in ('MECH CONTRACT LABOR','MECH PARTS MGT') and :user in (select userid from groupuser where groupname = 'SECURITYGROUPNAME')

Replace SECURITYGROUPNAME with the name of the security group you are applying the restriction to.  Then apply the restriction to the COMP value of the WOSTATUS domain and Condition Number is your condition.  If you leave Object Name blank it applies to all applications that use the WOSTATUS domain like Workorder, PM, etc.  May require entering WORKORDER for the Object Name field.

Hi James and Dragos, 

Thank you both for your help, but I am still having the same issue. I have tried all the conditions you both have recommended, but I am still able to complete the WO unless both the Work Type = IL AND the Work Code = 'MECH CONTRACT LABOR' or 'MECH PARTS MGT'. I am not sure why it's not working.

Hi Carlos,

You could try this to meet all conditions.  From logic or means one or the other but not both.

:WORKTYPE!='IL' or :THD_WORKCODE not in ('MECH CONTRACT LABOR','MECH PARTS MGT') or (:WORKTYPE!='IL' and :THD_WORKCODE not in ('MECH CONTRACT LABOR','MECH PARTS MGT'))