function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
sujithkrishsujithkrish 

What is wrong with this SOQL query? anybody?

 

My query goes like this:

Select a.Name, a.Id From Account a WHERE OwnerId = 'xyz' AND (Name LIKE '0%' OR Name LIKE '1%' OR Name LIKE '2%' OR Name like '3%' ) order by Name asc

 

This query works well in my developer edition environment, but in enterprise environment it doesnt work (I cannot get any results). Can someone please point me in the right direction?

 

 

Rahul SharmaRahul Sharma

Hi sujithkrish,

Ensure that you have records matching with query criteria in your enterprise edition.
sujithkrishsujithkrish

Thanks for your reply Rahul.

 

Yes. We do have enough results which match the criteria. In fact we have tried setting limit in our query, but didnt work through.

 

Is there anything else I need to look at?

 
Andy BoettcherAndy Boettcher

Possible - are sharing rules possibly blocking your results in the EE?
Ankit AroraAnkit Arora

Have you tested running your query in System Logs on EE?

 

Thanks

Ankit Arora

Blog | Facebook | Blog Page
abivenkatabivenkat

 

hi sujithkrish,

 

what about the owner id, here you are trying to hard code it in your dev org. check the owner id...