none
FIM 2010 R2 - IFF and Custom Expression - Error RRS feed

  • Question

  • Hi

    I am using this kind of IIF in outbound syncronization rule:

    IIF(Eq(PaymentGroup,10),3,IIF(Eq(PaymentGroup,322),3,IIF(Eq(PaymentGroup,11),0,IIF(Eq(PaymentGroup,323),0,Null()))))

    Destination attribute is EmploymentType which is number-attribute in sql view. Everything goes well, but when running a sync from FIMMA, connector update shows an error. See the picture.

    So the only place to see this error is to run sync preview. Running normal sync doesn't give any errors and export to connected destination doesn't give any errors either. So I am wondering is the IIF syntax correct? PaymetGroup (metaverse attribute) attribute and destination attributes are both number/integer attributes.

    The destination attribute value doesn't flow to the destination system. Other attributes are flowing ok.
    • Edited by 2xTsei Wednesday, December 7, 2016 11:24 AM
    Wednesday, December 7, 2016 11:23 AM

All replies

  • Is the attribute present on the metaverse object?

    Try adding a presence-check on the IIF (formatted for readability);

    IIF(IsPresent(PaymentGroup),
    
    	IIF(Eq(PaymentGroup,10),
    		3,
    		IIF(Eq(PaymentGroup,322),
    			3,
    			IIF(Eq(PaymentGroup,11),
    				0,
    				IIF(Eq(PaymentGroup,323),
    					0,
    					Null()
    				)
    			)
    		)
    	),
    Null()
    )
    


    Wednesday, December 7, 2016 11:45 AM
  • Yep, the attribute has value in all the cases.
    Thursday, December 8, 2016 6:07 AM
  • And PaymentGroup is an Integer and not a String?
    Thursday, December 8, 2016 10:32 AM
  • And PaymentGroup is an Integer and not a String?

    Yes, it is an integer. How the IIF syntax for integer should work?
    Monday, December 12, 2016 7:11 AM