Filter Grouping

[Jason Campbell]

In my filter I have the first grouping to begin with 'any' of the value. The second or sub grouping has to match 'all' of the conditions. 

The filtered results return one record that does not begin with any of the first grouping values but does match all of the second conditions. 

Does this mean that I need to reorganize the grouping hierarchy? Which would mean retyping a lot of 'begins with' values. 

The real question is, can I use a 'begins with' and specify a range of values 01-25 which need to start with 0?

[ParaSQL Support]

To specify Any of a list of things that begins with something, create an Any filter, then each begins with individually.

[Jason Campbell]

Ok, but does the hierarchy of the groupings matter? My Filter starts with the "Any", then has an "All" grouping below.

[ParaSQL Support]

Yes, the order of the groupings matters a lot. If you look at the left side of the filter panel, There is a vertical bar that shows just what the Any or All filter applies to. So if you have an All filter with a Any inside it, say it reads All of the following must be true:

each individual portion of the individual query pieces - and the the Any filter is just a single piece.

Example:

All Filter:

    state equals CA

    Any Filter under the All filter:

    status equals Ordered

    status equals Shipped

So to match the above, it must be in CA but it can be either Ordered or Shipped for the status.