In Condition Expression, ILLEGAL_OPERAND in evaluating...

[rworkman]

I created a condtion on one of my folders in attempt to not create a record in that folder if the data is not available. When I do this I get a warning which I do not understand. I would like to know if I used the condition incorrectly. Also, is there documentation for the condition exression?

<trans>IsNull(facsimileTelephoneNumber)==0</trans>

Warning : CTransform::Evaluate failed - Transform Error: ILLEGAL_OPERAND in evaluating "<trans>IsNull(facsimileTelephoneNumber)==0</trans>"

[modelpoint]

I think you can use If() function to work around this

Code: Select all

<trans>If(IsNull(facsimileTelephoneNumber)==0,true, false)</trans>

[Ilan]

modelpoint is correct. His expression would evaluate to true or false. True allows the condition to pass and false the condition and the record would not go through.

Another way to do this is simply:

<trans>IsNull(facsimileTelephoneNumber)</trans>

If facsimileTelephoneNumber is Null then the record will go through otherwise the condition would fail

If you do not want Null values then you could also use

<trans>IsNull(facsimileTelephoneNumber)==false</trans>

Please tell us if you still have errors.

For documentation, if you are using Beta 1.2 please look at the help system. Within Transformations, within advanced options there is a section on working with conditional mappings. IF that does not help please tell us.

Thanks.
Ilan.

[rworkman]

I used {IsNull(facsimileTelephoneNumber)==false} and that worked just fine. Thanks for the help.

Rodney