You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Error response while performing a query

Received Response
30
Views
3
Comments
edited May 15, 2020 3:42PM in Integrations and APIs 3 comments

Summary

Error: Too many rows examined

Content

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

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!