Cascading Dropdowns Optional Filter format?

[Anne Maki]

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

[Alexander Bautz]

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

[Author]

Posts