+ Start a Discussion
nawazheebanawazheeba 

Salesforce Query editor

select id,name from account where id ='xyz'

 

The above query gives one result in eclipse, but when i run the same query in developer console query editor it results with 0 rows even thought the record exists.

 

 

Chris42Chris42

When you run in Eclipse, it runs the query with the credentials specified in the project settings. Are you certain it's the exact same user? Sounds silly but lets rule that our first.

nawazheebanawazheeba

yes chris, one more weird thing i can get the record if i put name in the where condition, the problem in only if i put ID in the where condition.

Thomas DvornikThomas Dvornik

If you get the record by name, then use the ID on the returned record in your query by ID, will the record return? I'm thinking this might be an issue with 15 vs. 18 char IDs.

Chris42Chris42

Ahh, good call Thomas. Didn't think about that.