I'm having a bit of trouble using "Select by expression" in QGIS.
I'm working on a shapefile of a polyline network, each line has a unique reference which is made up of letters, numbers and symbols such as 'CRCCU50234/50010'.
I often have to select lines(aka sections) based on a list of references so i've created a simple tool in excel to build a query to select by expression based on two inputs; a field and a value. The expression built looks like;
"Section_Re" = 'CRU50229/50010' OR "Section_Re" = 'CRCC0229/50020' OR "Section_Re" = 'CRCCU50229/50030' OR "Section_Re" = 'CRCCU50230/50005' OR "Section_Re" = 'CRCCU502/50011' OR "Section_Re" = 'CRCCU501/50005' OR "Section_Re" = 'CRCCU0232/010'
where "Section_Re" is the field name and the values in single quotes are the unique references.
I've been using this method of selecting sections based on a list for about 8 months now on multiple shapefiles without issue. A couple of days ago, this stopped working when used on any selection greater than about 10 records.
Strangely, the expression returns nothing when ran in full (for about 300 sections) but will return results if all but ~10 lines are removed from the expression. It's an OR expression so i would expect that even if some of the lines didn't return a result, those that did would be selected.
I'm very confused as to what's going on so I thought i'd turn to the stack exchange community for help. I hope that i've given enough information and explained my issue clearly, but if anything else is required, please let me know.