AnsweredAssumed Answered

resultOffset & resultRecordCount Parameters are causing the query to return No records found

Question asked by Glitchy on Apr 5, 2018
Latest reply on Jan 15, 2019 by eric.oneal_LWC

setDefinitionExpression is including the resultOffset and resultRecordCount parameters that are causing the service query to return No records found.  If I make the same query without these parameters it returns records.


How can I eliminate these parameters from being added to the query when I set the definition expression? 


How can I get the service to return records with these parameters set?





No records found query… 


If I remove theses parameters &resultOffset=0&resultRecordCount=1000 then it returns the expected 72 records.… 


Also of note if I change the where statement to 1=1 it will return all the records even with the resultOffset and resultRecordCount parameters…