Cascading Dropdowns Optional Filter format?

Forums Cascading dropdowns Cascading Dropdowns Optional Filter format?

This topic contains 1 reply, has 2 voices, and was last updated by  Alexander Bautz 1 month, 1 week ago.

  • Author
    Posts
  • #26071

    Anne Maki
    Participant

    Hello,

    I am trying to use an optional filter with a cascading dropdown using the following format as stated in the manual:

    {“filterField”:”Status”,”filterValue”:”Active”,”operator”:”eq”}

    The filterField holds Yes/No values. When I used this, I get a bunch of blank entries in my drop-down. I read that you have to change the format for Boolean (I tried using True for the filter value, but I get the same results).

    Appreciate the help!

    Anne

  • #26090

    Alexander Bautz
    Keymaster

    Hi,
    Are you using SP 2013 or later? – if so, you must use a filter like this:

    {"filterField":"YOUR_FIELD_NAME","filterValue":true,"operator":"eq"}

    If you use SP 2010 or earlier you must use a filter like this:

    "<Where><Eq><FieldRef Name='YOUR_FIELD_NAME' /><Value Type='Boolean'>1</Value></Eq></Where>"

    Change YOUR_FIELD_NAME with your field name.

    Alexander

You must be logged in to reply to this topic.