function readOnly(count){ }
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
+ Start a Discussion
Funky_DBAFunky_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

 

SuperfellSuperfell

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 

 

Funky_DBAFunky_DBA

Simon

 

Thanks a lot for your fast response and the advice which looks very promising.

 

Barry

 

Funky_DBAFunky_DBA

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

 

 

 

 

SuperfellSuperfell
Which part in particular are you struggling with? start SoqlXplorer, enter your username & password (and possibly api security token), type in the query to the top window and click query. If you want the schema view, click the little schema button at the top righthand side of the window (on the just released 0.96 version).
Funky_DBAFunky_DBA

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

 

SuperfellSuperfell
there is no .exe file or install, just uncompress the zip file and run it, you have a Mac, right?
Funky_DBAFunky_DBA

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

 

SuperfellSuperfell

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