Anyone have any suggestions, I’m trying to search for an integer value in the backoffice Examine manager using isActive:1 however it fails to return any reults even though there are items in the index where this is true, if I change the query to isActive:[1 TO 1] then it successfully finds the records.
Is there some odd reason that you have to use a range query for this?
Similar issues with examine and integers…
parentID:1246 doesn’t return results because parentId is defined as an integer (FieldDefinitionTypes.Integer). Lucene doesn’t support direct equality queries on numeric fields using plain field:value syntax. However, parentId:[1246 TO 1246] works because it uses a numeric range query, which is how Examine handles searches on integer fields. Even if the range is just a single value, this is the correct approach.