You need to sign in to do that
Don't have an account?
Funky_DBA
Newbie Question - How do I run SOQL Scripts ?
Hi
I am new to Salesforce as a Developer.
I want to run SOQL the same way I can run SQL in Oracle using SQL*Plus or in SQL Server using the Management Studio.
For example, to count the number of Tasks I would like to tun the SOQL equivalent of "SELECT COUNT(*) FROM Tasks".
I would appreciate suggestions for how I can do this.
I have searched the Getting Started documentation and the Discussion Boards without success.
Is there another way I can find the answer for myself ?
Thanks a lot.
Barry
You have various options, there are some desktop tools that are geared towards interactively running SOQL, examining your schema etc, SoqlX if you're on a Mac, Force.com Explorer or the Force.com eclipse plugin. The other option would be to install a package into your salesforce.com account that lets you do similar things via the web UI, try the ajax debug shell, or the Appirio SOQL query tool.
See
http://wiki.developerforce.com/index.php/Tools
http://www.pocktetsoap.com/osx/soqlX
http://developer.force.com/codeshare/apex/projectpage?id=a0630000003Z4PLAA0
Simon
Thanks a lot for your fast response and the advice which looks very promising.
Barry
I haven't been able to work out how to run any of the SOQL Query Tools.
For example, PocketSoap shows a great Screenshot of SoqlXplorer that is just like what I am used to from Oracle's SQL*Plus or SQL Server's Management Studio.
Unfortunately, I can't work out how to startup a window that looks like the screenshot.
I'd appreciate any suggestions.
Thanks a lot.
Barry
I am struggling with the fact that I can't 'start SoqlXplorer'. I have run the install but the only .exe I can find is uninstall.exe.
Thanks for your continued help.
Barry
No, I am running Windows XP on a PC.
However, I don't have a zip file - I have downloaded a .exe file called PocketSOAP.1.4.5.exe.
When I run it, it instals something but nothing executable.
Thanks
Barry
SoqlX is OSX only. Not sure why you're downloading pocketSOAP. Try Apex Explorer for windows, or the Force.IDE plugin for Eclipse
http://wiki.developerforce.com/index.php/Force.com_IDE
http://wiki.developerforce.com/index.php/Apex_Explorer