Error response while performing a query
Summary
Error: Too many rows examinedContent
We are getting this result when trying to do a simple query that should return a handful of records. We think that by adding ID> 0 to the query parameter will narrow it down. I am not sure how that would work. This is the error we are getting:
"detail": "This query is not supported: Poor performing query - too many rows examined",
"instance": "https://ftworthwater--tst.custhelp.com/services/rest/connect/v1.4/queryResults/?query=select id,subject from incidents where CustomFields.c.event_type.lookupName='FIELD OPS' and CustomFields.c.case_status.lookupName='Open-Work Order' and CustomFields.c.batch_status=0
0