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 184.108.40.206
Is Contains selected as the default operator in the Advanced Filter Properties section for this Dynamic Ad-Hoc Filter?
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.
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)
The probolem is that equals is not the same as contains!
Item 1=====Division : div1;div2Item 2=====Division : div1
Division + equals + div1 --> must show only Item 2 and not both!!!
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.