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
API User 189API User 189 

Cannot query certain tasks

I am trying to programmatically reduce the number of tasks. I ran a simple query using in Apex Execute Anonymous:
 
List<Task> tasks = [Select Id from Task WHERE Subject Like '%Was Email Sent%'];
System.debug(tasks.size());
delete tasks;

To my confusion, the query came back with 0 results, even though I know for a fact that a task with that string in the subject exists. I then went  to an actual Task with that in the subject and ran this query:
 
List<Task> tasks = [Select Id from Task WHERE Id = '00TA000002lcsWy'];
System.debug(tasks);
delete tasks;

But that returned 0 results. I can manually edit and delete these tasks, but for some reason, I can't query them.
I did notice that the Tasks that were queriable have IDs that begin with 00T1 whilst these start off with 00TA. Is there anything to that? Are they recognized as a completely different object? 

 
Adilson Arcoverde JrAdilson Arcoverde Jr
Hi Api User 189.

You should query on Event object too. 

If the problem still persists, Salesforce has an automatic arquiving rule to Task and Events. It is shown to you a number of objects in system's overview, but you can't find these records. 

To solve it, you have to open a new case with Salesforce support.

Hope you find this solution useful. If it does, please mark as Best Answer to help others too.

Regards.