Apex Returns Different Result From Developer Console

Question

I have a custom profile called MyCustomProfile. When I want to get profiles in my Apex class I don't get System Administrator. But in Developer Console, with same code, I can get both of them.

Profile[] adminProfiles = [SELECT id FROM Profile WHERE name IN ('MyCustomProfile', 'System Administrator')];

returns one element from my Apex class and returns two records from Developer Console. Why can't I see the System Administrator in my class, also? Do you have any ideas?

EDIT: Code part I'm getting the issue.

User userObj = [SELECT ProfileId FROM User WHERE id=:UserInfo.getUserId()];
Profile[] adminProfiles = [SELECT id FROM Profile WHERE name IN ('Merkez Kullanıcıları', 'System Administrator')];
Map<id, Profile> lIDToProfileMap = new Map<id, Profile>(adminProfiles);
system.debug('returned map: ' + lIDToProfileMap);

Answer 1

Ok, so if it doesn't work for a user (when you test as him) and works for you in a console I would say this is a problem of standard profile - System Administrator. One drawback of standard profiles is that they are translated to match the Language settings of current user. So if you're querying for Profile with name System Administrator as you do:

Profile[] adminProfiles = [SELECT id FROM Profile WHERE name IN ('Merkez Kullanıcıları', 'System Administrator')];

it will work for users with English set but will not work for German for instance. Custom system administrator profiles work because they are not translated. Based on 2nd profile name that you provided I guess that's an issue in this case (non english profile name). I guess the user has non English language and you have English set. Correct?

So if that's the issue what would be a solution? I'd suggest to:

• hardcode this particular profile Id in a Constants class (if this is a Live system and profile Id will not change)

Profile[] adminProfiles = [SELECT Id FROM Profile WHERE Name = 'Merkez Kullanıcıları' OR Id = :MyConstantsClass.SYSTEM_ADMINISTRATOR_PROFILE_ID];

• or create custom label storing profile name and add translations to it for each language that you're using

Profile[] adminProfiles = [SELECT Id FROM Profile WHERE Name IN ('Merkez Kullanıcıları', :System.Label.System_Administrator)];

You can see some other ideas on how to solve this over here:

• Supported solution for querying standard profile names for multilingual user base?
• and here: Salesforce query on profile not working on user language change

Answer 2

If your class is written With Sharing and if executed with normal user profile then you may see difference in result.

Note that : If not declared explicitly, classes are always WithOUT Sharing unless called from a method in another class defined as with sharing (http://www.salesforce.com/us/developer/docs/apexcode/Content/apex_classes_keywords_sharing.htm).