+ 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?