I'm not a QGIS power user but I've been using it for simple things for quite a while. I just updated from QGIS 2.14 to 2.18 yesterday in order to be able to edit field names. I'm now having some problems with filtering using multiple bracketed expressions that I don't think I had before, but it had been a little while.
For example, I'm trying to filter this parcel data shapefile by land use codes (which are an integer64 field, so they are numerical). The shapefile has 399212 records. When I apply the filter
("15USE">=1000 and "15USE"<=2900) or ("15USE" >= 7000 and "15USE"<=7900) or ("15USE"=8901)
shown below, it does not filter out any records:
Strangely, the exact same expression, copied and pasted into the Select by Expression Builder, selects a subset of the records (about 200,000 or so):
For what it's worth, the "isselected" function does not appear to serve as a workaround - I've never gotten it to work, despite reading about it on here:
What am I missing here? Did the filtering syntax change? I know that queries/filters have always been less sophisticated than selection expressions, but this is weird. Or am I (more likely) doing something wrong?
Mac OS X Yosemite; 2011 MacBook Pro, 8GB upgraded memory, 500 GB upgraded SSD; QGIS: 2.18