cmn_deparment table issue on Workflow

[An6]

Hi,
Does anyone know why I can't find the Departments table (cmn_department) in the workflow conditions?

I can add each separately via a variable but I would like to create a condition: Departments contains 'Transformation&Technology' and it is not possible to refer to the table in this way.

[Ankur Bawiskar]

@An6 

you will have to use only that syntax which you shared

You cannot directly see that variable in conditions

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

[An6]

but if it is the cmn_departments table then why can't I access it?
the cmn_locations table can be accessed normally, even without entering variables.

[Dr Atul G- LNG]

Hi @An6 

Check is it restricted some time in system properties. 

[Ankur Bawiskar]

@An6 

I assume workflow is for your catalog item and is running on RITM table

that's because Location is a field on RITM table but variables are not directly stored at RITM level

So the only way to access the variables is the syntax which you are already using.

you can use script if required for more complex check

answer = ifScript();

function ifScript(){
	var departmentValue = current.variables.departmentVariable.getDisplayValue();
	// now use this to compare and return 'yes' or 'no'
}

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