[SalesForce] SOQL join two tables – all contacts from lead

I have a Lead object and would like to get all contacts for this Lead. I was not able to find an appropriate method in apex and decided to make a query. Unfortunately I don't have much experience with SOQL therefore could you please advise how to adapt the following query in SOQL. Here is the query:

select contact.* from lead, contact where lead.id = contact.Company_Name__c and lead.id = '00Q560000019qCB'

Please advise how to transform the above query in SOQL?

Regards,

Dilyan

Best Answer

There is no * in the SOQL query so you will have to specify the fields you want to pull.

I am going to ignore your need for the Company to be the same for now until you clarify your question.

to get the data from converted leads you can do the following:

Note You should ALWAYS limit your query by using selective filters as you cannot return more than 50K rows in a transaction now should you need to.

Set<ID> SetOdIds = New Set<ID>();

//Populate the set using results from another query, trigger, or something that identifies the contact IDs you are looking for. Maybe `[Select Id From Contact Where Company = 'test Company'`

[Select ConvertedContact.LastName, ConvertedContact.firstName From Lead Where isConverted = true and convertedcontactid IN :setOfIds]

You should read up and be familiar with the Force.com SOQL and SOSL Reference

Related Solutions

[SalesForce] Get all contacts and leads from campaign members

You should be able to do something like:

List<Contact> contacts = [
    SELECT 
        Id, Name, Phone 
    FROM 
        Contact 
    WHERE 
        Id IN (
            SELECT 
                ContactId 
            FROM 
                CampaignMember 
            WHERE 
                CampaignId = :campaignId AND ContactId != null
        )
];

List<Lead> leads = [
     SELECT 
         Id, Name, Phone 
     FROM 
         Lead 
     WHERE 
         Id IN (
             SELECT 
                 LeadId 
             FROM 
                 CampaignMember 
             WHERE 
                 CampaignId = :campaignId 
                 AND LeadId != null
         )
 ];

[SalesForce] How to make a standard field to not be required

Standard required fields are required. You can't make them optional. I have heard of people making Visualforce pages to set those fields to some value "behind the scenes", but they're still populated with some value. That's a lot of code to write just to add the convenience of a single field not being required.

Best Answer

Related Solutions

[SalesForce] Get all contacts and leads from campaign members

[SalesForce] How to make a standard field to not be required

Related Topic