none
IIF Statements use of EVAL and OR expressions RRS feed

  • Question

  • Hi,

    I am trying to minimise the complexity of an IIF statement I am developing in a synchronisation rule to use the "EVAL" expression i.e.

    IF (Eval([jobTitle] In ("manager", "senior manager", "executive")), "value1", "value2")

    When I attempt to save this I receive the error: "Parameter of function IIF does not match"

    Can you use the EVAL if not how else am I able to configure a simple OR expressions?

    ~FIMDB

    Wednesday, May 23, 2012 11:55 PM

Answers

  • No - the Eval function doesn't exist in the current version of FIM.  For a complete list of available functions, go to the FIM home page, click on the All Resources menu, and then on the Functions resource type.

    The only option available to you AFAIK is to use nested IIF statements, e.g.

    IIF (condition1,'value1',IIF(condition2,'value2','value3'))


    Bob Bradley (FIMBob @ http://thefimteam.com/) ... now using Event Broker 3.0 @ http://www.fimeventbroker.com/ for just-in-time delivery of FIM 2010 policy via the sync engine

    • Marked as answer by FIMDB Friday, May 25, 2012 11:10 PM
    Thursday, May 24, 2012 8:03 AM

All replies

  • No - the Eval function doesn't exist in the current version of FIM.  For a complete list of available functions, go to the FIM home page, click on the All Resources menu, and then on the Functions resource type.

    The only option available to you AFAIK is to use nested IIF statements, e.g.

    IIF (condition1,'value1',IIF(condition2,'value2','value3'))


    Bob Bradley (FIMBob @ http://thefimteam.com/) ... now using Event Broker 3.0 @ http://www.fimeventbroker.com/ for just-in-time delivery of FIM 2010 policy via the sync engine

    • Marked as answer by FIMDB Friday, May 25, 2012 11:10 PM
    Thursday, May 24, 2012 8:03 AM
  • Thank you - will change the logic to use nested IIFs
    Friday, May 25, 2012 11:10 PM