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

ROQL Statement

Received Response
23
Views
4
Comments
edited Jun 8, 2022 12:02PM in General Technical Discussions 4 comments

Content

Hi,

I noticed that the maximum of 3003 record can query each time for statement below. 

select *,  emails.* 

from Contact where Updatedtime >= '2015-06-08T06:00:00Z' and c$person_status is null   (result 3003 records converted)

 

select *,  emails.* 

from Contact where Updatedtime >= '2015-06-28T06:00:00Z' and c$person_status is null (result 3003 records converted)

 

select *,  emails.* 

from Contact where Updatedtime >= '2015-07-14T06:00:00Z' and c$person_status is null (result 3003 records converted)

 

But if I used this statement, I able to get all the records with today as latest records

 

select * 

from Contact where Updatedtime >= '2015-06-08T06:00:00Z' and c$person_status is null

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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