Ask Search:
Varun Prasad Yadav GunasekaranVarun Prasad Yadav Gunasekaran 

select query on salesforce records

hi,

how to run a db select query on salesforce records ?.

thanks in advance !,

Varun
Tim FieldsTim Fields
 Take a look at http://wiki.developerforce.com/index.php/Apex_Explorer

Note that you can't perform a Select * from Table
Joseph UcuzogluJoseph Ucuzoglu
 Hi Varun

There are different ways to accomplish this. As a first step I would reccomend installing the Force.com IDE http://wiki.developerforce.com/index.php/Force.com_IDE

The IDE is very powerful and you have options to do many things including utilizing the Schema explorer which I think is one of the best ways to search your SFDC data.

Once you are in the Schema Explorer within the Force.com IDE you can run SOQL (note its not SQL) to gather information.

Its a bit different and like TFiel states there is no wildcard you can use in select statements. Aside from that the queries look fairly similar.

Select Id, FirstName, LastName from Contact Where LastName = 'Smith' Limit 2

Developer questions are best asked over at the developer boards which you can find here: http://boards.developerforce.com/t5/Apex-Code-Development/bd-p/apex