Hi,

How would I write this IIF query into an Outbound Sync Rule:

If Boolean_attribute_X is False, export the following 'static' value into the target_AD_attribute,

else do nothing (if true)

My thinking is something along these lines for the custom expression:

IIF(Boolean_Attribute, Customexpression(NULL())), "Static Value"

Thank you

• Edited by Shim Kwan Tuesday, February 24, 2015 2:54 AM

Hello ,

I thnink you can try it :

IIF(Boolean_Attribute,,"static",Null())

Regards ,

Hi Shim,

Please try something like this : IIF(not(Boolean_Attribute = True)), "Static Value" and let me know the outcome.

Hello,

Your custom expression is quite right, but be aware that you cannot do "nothing" with Sync rule.

The flow will look like this: IIF(BoolAtt,Null(),"String")

If you don't want to change the value of your target attribute, you can try to set a new MV attribute with an import flow, and use this attribute instead of the Null() function.

This flow will look like : IIF(BoolAtt,IIF(IsPresent(MyAtt),MyAtt,Null()),"String")

Regards,