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
LogmiLogmi 

SQL Query for casenumber

Can anybody please tell me what I'm doing wrong?  I'm using this sql in a query.  It returns zero records, but I know there is a Case with CaseNumber equal to 00001031.
 
"SELECT Id, CaseNumber, Account.Id, Account.Name,Owner.FirstName, Owner.LastName, Account.Phone FROM Case WHERE CaseNumber = '00001031' ORDER BY Account.Name"
werewolfwerewolf
Do you perhaps have a private sharing model on case so that the user running this query can't see that case?