Good day everyone. I am trying to view all my events including the deleted records. My query looks like this.
List<Event> allEvent = [SELECT CreatedDate,Description,DurationInMinutes,EndDateTime,EventSubtype,Id,IsArchived,IsDeleted,RecordTypeId,Subject,WhatId,WhoId FROM Event ORDER BY CreatedDate DESC NULLS FIRST ALL ROWS];
System.debug('allEvent here: ' + allEvent);
The thing I am wondering is, what is the limitation of 'ALL ROWS'? What I thought is that it will get the data in the recycle bin. But what if I deleted the record many years ago and already not in recycle bin ? Can I still view it using 'ALL ROWS' ? I also tried deleting my file and after that I empty my recycle bin, but when I tried to query using 'ALL ROWS' it still show. Is it because deletion takes time before it will be completely deleted ? Please help. Thanks.