Currently, the problem exists that you can not really accomplish anything like a NOT filter selction.

You might expect to be able to achieve the same thing as a NOT filter by roundabout selecting everything EXCEPT the value you want to exclude. Unfortunately this doesnt work out.

For example:

• Custom 'enumerated list' field: "Color" with values: "|red|green|blue"
  (on a side note: the preceding pipe is there to get around another bug where it auto-populates in teh absense of a value on updating the report. i dont know if thats logged or not, as ive found this easy way to avoid the problem).

• Some reports have a value recorded for Color, but many do not, as most real-world scenarios would have.

So, you merely want to find all the values that do NOT have the value "red".

You would expect to use advanced filter and multiselect both 'blue' and 'green' however that will leave out all the reports that don't have the "red" field populated, which are many. I want to include all reports with values other than "red" whether the field be populated or not. The code currently assumes this non-value condidtion is not included in the filter and omits all those bugs as well.

There currently seems to be no way around this limitation. And I cant figure any way to kludge around it.

Ideally, it would be great to have something like a boolean dropdown menu selector on each filter field for the advanced filter section.