+ Start a Discussion

Querying Profile object

Why would this query return 0 records:

Select ID From Profile where name = 'PT1'

I think this should return one record. PT1 is the administrator profile on all org's I've dealt with.



I found this little buglet shortly after I got my sForce account and forgot all about it... Someone should probibly log a case (let me know if you haven't and I will) to get this documented.

Instead of Select Id, ... From Profile Where Name = 'PT1'  I had to use Select Id, ... From Profile Where Name Like '%PT1%' and it works like a charm.