function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
BKBK 

sql nested joins

Im having some problems getting nested queries. Is there anyway I can do this via the office toolkit? how can i get this done in 1 statment using the office_toolkit api. For example, how can i get contact.firstname, and contact.lastname and account.name on one sheet by creating a relationship to accounts and contact table. how can i do a joing so that account.contactid = contact.id

is there anyway soql can support this?

thanks guys

bk
bouscalbouscal

Hi BK, you can do this with the Excel connector on the sourceforge site.

It's kind of difficult to explain but on one sheet you can have the contacts listed, leave an empty column and then the account info.  In the example below, cell F3 contains the formula =D3 and so on down the line.

Then you could use sforce Connector - Multiple Queries - Run each query on sheet.

 

 

HTH

 

Tim
Ron HessRon Hess

here is the doc i wrote on joins using the sforce_connecor

http://sforce.sourceforge.net/excel/joins.htm

 
BKBK
i went ahead and implemented the add in sforce conncector in excel. I see the new function buttons drop downs but when i click on one such as sforce table wizard i get an error saying that macro that can not ne found...any thoughts?