You need to sign in to do that
Don't have an account?
Logmi
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"
werewolf
Do you perhaps have a private sharing model on case so that the user running this query can't see that case?