0

I have a requirement to find out the first 1 million record's last created date. As we have about more than two million in the system. As both SOQL queries and offset have less than 10000 limit, how can I achieve this?

Improve this question
4
  • Depends on how you're querying. Rest/Soap API each have a limit of up to 50 million, and read only visualforce pages can access up to 1 million rows. There are ways to get this data.
    – sfdcfox ♦
    Commented Apr 22, 2016 at 1:08
  • @sfdcfox Thank you for that. I just did a bit selective queries based on CreatedDate and got the approximate date. And the business team is happy with that.
    – Lance Shi
    Commented Apr 22, 2016 at 1:16
  • 1
    If you solved your problem, please answer your question as others could benefit from it.
    – Richard N
    Commented Apr 22, 2016 at 2:23
  • @RichardN I don't see it as a good resolution though. I just did the approach which is not the accurate number
    – Lance Shi
    Commented Apr 22, 2016 at 2:36

1 Answer 1

Reset to default
2

A very simple way to achieve you goal would just be to export the data using data loader bulk api.

Improve this answer

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .