Querying Tasks Dev Console results different from APEX results

Question

I have a very simple query on Tasks that get Tasks created by a user. If I run the query in the Dev Console I get 4 rows (as admin). The same query in an apex method (as the user/owner), I get 1 row only.

So far I've tried: - Checking the permission set for the user, to ensure it has all access to the Task object - Added the ALL ROWS to the Apex query - This is on a dev org with default settings

Select Id,
                             ActivityDate, 
                             Priority, 
                             OwnerId, 
                             Status, 
                             Subject, 
                             Description, 
                             whatid 
from Task 
where CreatedById in (select id from user where name='Linda Charles')
and IsClosed=false

Why might the queries have different results?

Answer 1

Tasks & Events' visibility is "controlled by parent" record. Check sharing. Is there any chance that the user you're running it with can't see the Account X -> he can't see Account X's tasks? If the task you see as admin is for record X (be it std or custom object) - see if navigating to that object's URL throws "Insufficient privileges" for your end user... Alternatively you could edit the apex method's class to make it run without sharing and see if it makes any difference.

Normally another obscure thing I'd suggest is to simplify the query, make it run based on user's ID. Comments say you've already tried it. In extreme cases end users with locale set to say Chinese or Hungarian will prefer "Lastname Firstname" order and then query for "Linda Charles" might return 0 results or a completely different user ;)