function readOnly(count){ }
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
+ Start a Discussion

SOQL query for time stamp

Hi ,
  My requirement is need a SOQL query to retrieve the records which are created,updated in last ten minutes ,
   by giving the time stamp iam able to get those but for every ten minutes i need to run this query , i dont want to get duplicate records,

You can use the apex schedule to schedule this job and run a query in every 10 mins to get the records created in the last ten mins - you will have to mention this time stamp in SOQL so as to restrict duplicates.
read more:
Hi Sonam,
      thanks for your reply..
   I just need a SOQL query only, i dont want to use any apex coding,strictly it should be SOQL query only