Is there a way we can build query in developer console just how we do in force.com IDE or force.com explorer.I see a query editor but not query builder in developer console.
- Anybody can ask a question
- Anybody can answer
- The best answers are voted up and rise to the top
No, the query / SOQL capabilities of the dev console are fairly rudimentary. Your best bet is to stick with the Eclipse plugin or look at either Workbench (http://workbench.developerforce.com) or google for Simon Fells Pocket SOQL explorer.
The Explorer Utility that's found in Ajax tools (a freebie App from SF) comes in pretty handy too if you're looking for something you can run from the UI. It will provide all the relationships you're looking for. You'll just need to add your Where, GroupBy and other clauses you need.