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
Again AgainAgain Again 

Report to show all accounts with no contacts

Hi,
 
I need to report on all accounts of a certain account type, with no contacts of a certain markup. If I were constructing a SQL query, I'd say something like
 
select account.accountname
where
Recordtype  = 'xxx'
AND ID NOT IN (select AccountID FROM Contact WHERE Contact.Status = 'yyy')
 
How can this be done in SalesForce / with a related tool?
 
Thanks!
Tinkylou
qmanqman
Get DBAmp and enter the sql statement just like you have it.

http://www.salesforce.com/appexchange/detail_overview.jsp?id=a0330000000nsOlAAI

Bill
Rick.BanisterRick.Banister
Relational Junction can give you a data warehouse for reporting on any DBMS platform. The database query would then be

  Select * from taccount
  where not exists (select 1 from tcontact where tcontact.accountid = taccount.id)

Relational Junction is a complete solution for all your reporting and integration needs which provides 2-way replication from a mirror-image warehouse. It is also platform neutral. We support Oracle, SQL Server, DB2, MySQL, and Sybase, and run on Windows and Unix platforms.

See http://www.sesamesoftware.com
Again AgainAgain Again
Thanks - I'm downloading the trial and will give it a bash!
Again AgainAgain Again
I had a look and it looks really nice, but I think I'll have to wait until our SF implementation is more settled in before I'll be able to justify the price tag. :smileysad:  I will keep an eye on it though. Looks like it could save lots of time in the long run.
Again AgainAgain Again

I've been using DBAmp and it's really nice. Thumbs up!

I get an error when I try to get the value of a multi-select picklist. Is there a special way to access this data?