Expressions: multiple conditions

[Guido1982]

Follow the previous post I created a validation map that evaluates a condition expression map. I want to trigger the validation only when a certain picklist value is selected, so

Code:

if (pending_tc_recordcount > 0 && lm_status = 'thetriggeringstatus') then 0 else 1 end

But that doesn't yield the desired result (I get some fatal error). Is this even possible and if so, how? And if it's not, is there another solution, other than writing a custom validation?

[joebordes]

Try with

if AND(pending_tc_recordcount > 0, lm_status = 'thetriggeringstatus') then 0 else 1 end

[Guido1982]

Sadly, that also leads to a fatal error

Code:

Uncaught Exception: Was expecting a closing bracket in /PATH/public_html/rolodek/CRM/modules/com_vtiger_workflow/expression_engine/VTParser.inc:136

[joebordes]

try it in the workflow editor, make sure the expression works there and then copy it to the map. note the in XML you may have to use CDATA for the bigger and lesser than operators (I don't remember)

[joebordes]

or try with >

[joebordes]

in short: this works, I have seen it a lot before

[Guido1982]

The solution was

if AND(pending_tc_recordcount > 0, lm_status == 'thetriggeringstatus') then 0 else 1 end

Mind the double equals sign. Damn expression language tripped me up again.

[joebordes]

Sorry, for that, but very happy it worked!

[Guido1982]

No problem, just glad I got it to work