Workflow

[abhisek]

I have a catalog item where I have a multiple-choice variable 'at what level it is required' which has 2 values 'sub' and 'resource'. If we select sub then another reference variable 'select sub' would be visible which refers to 'xyz' table and if we select resource then another reference variable 'select resource' would be visible which refers to 'abc' table. 

Each and every record of both the table abc and xyz has 'key value' on the related list which has many records. These records have fields like 'key' and 'value'. 

The requirement is if 'key' is environment and 'value' is 'pr' or 'np' then in the workflow I have to create a task and if it is not 'pr' or 'np' then I have to create another task.

I am not sure how to check the 'key' is environment and 'value' = 'pr' or 'npe' or anything else in workflow activity.

Could you please help me out.

Thanks&Regards,

Abhisek Chattaraj.

[kaustubh Desai]

Hello @abhisek  , 
Could you please provide some screenshots of the table and related list so I can better understand the issue?

[Ankur Bawiskar]

@abhisek  

very difficult to visualize without screenshots.

If my response helped please mark it correct and close the thread so that it benefits future readers.

[Medi C]

Hi @abhisek ,

Could you please try using "if" condition (Checking advanced checkbox) from the Core activities in Workflow? There you can check the variables value using:

current.variables.variable_name

 For this to work properly, please ensure that the value is cleared using UI Policies or Client Script when the fields you want to check on should not be visible on your catalog item.

If the requirements is to get other fields from the table, you can simply use the regular Glide Operations to query based on what you have from current.variables.variable_name. 

Should my response be helpful, kindly mark it as correct and close the thread to facilitate future reference for others.

Best regards,
Medi