You need to sign in to do that
Don't have an account?
nawazheeba
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.
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.
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.
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.
Ahh, good call Thomas. Didn't think about that.