SharePoint 2013 Foundation (SPF) and Server (SPS) SharePoint 2010 Foundation (SPF) and Server (SPS) Windows SharePoint Services (WSS) 3.0 / Microsoft Office SharePoint Server (MOSS) 2007
SPF & SPS 2013 • 2010 • 2007
User Voices

FilterZen: Feedback Forum > Dynamic Ad-Hoc Issue

Dynamic Ad-Hoc Filter is a great solution! I only have a problem with a field.

I set the filter to only offer specific fields for the user. One of these field is a multiple choice field.

The user need to be able to choose something like "Show me only the rows where the field ONLY contains value1". I tried and create a query like this : "field + equals + value". The results are not good. It shows me rows for "field + contains + value". So I note that there is no difference between using "equals" or "contains". But I need to find rows only where "equals" is true.

Any help or suggestion?

I use version

May 19, 2011 at 15:45 | Unregistered CommenterJaimé

Is Contains selected as the default operator in the Advanced Filter Properties section for this Dynamic Ad-Hoc Filter?

May 19, 2011 at 16:20 | Registered CommenterROXORITY

I'm not 100% sure right now but might be possible that we chose to default to Contains for multi-choice fields because otherwise you'd have to enter all choices separated by ;# for Equals to work... will investigate and get back to you here.

May 19, 2011 at 16:21 | Registered CommenterROXORITY

Just did a simple test... choice+equals+TestChoice gave me all items where the multi-choice column contained the TestChoice choice. These items may also have other choices selected of course... it IS a MULTI-choice column after all! ... but where only shown if the TestChoice was also included in the column.

You might need to email us more details about your scenario along with a screenshot of the problem and an export of your FilterZen Web Part (via its web part menu / Export option)

May 19, 2011 at 16:38 | Registered CommenterROXORITY

The probolem is that equals is not the same as contains!

Item 1
Division : div1;div2
Item 2
Division : div1

Division + equals + div1 --> must show only Item 2 and not both!!!

Thank you

May 24, 2011 at 18:37 | Unregistered CommenterJaimé

Not our fault -- CAML works this way with Multi-Choice columns! If the multi-choice HAS div1 then for MS SP it "equals" div1, even if you have a different opinion than MS SP. It's not ideal but you could add an "AND not-equals div2"... we didn't create CAML, we only built a UI on top of it. Sorry for that.

May 24, 2011 at 20:06 | Registered CommenterROXORITY