You need to sign in to do that
Don't have an account?
dasari123
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,
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: http://www.salesforce.com/us/developer/docs/apexcode/Content/apex_scheduler.htm
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