You need to sign in to do that
Don't have an account?
Pierre MICELI
Help on a SOQL formula
Hi all,
I'm not a regular SFDC user, and I've never used SOQL. However I need to create a simple query but I can't find the right formula. I read a lot on the topics but the more I read the more I'm confused.
If you can help, it will be great.
I just want to retreive 4 fields : 2 from Opportunity table and 2 from Campaign table. In Opportunity table there is primary key 'CampaignId' which links the 2 tables. I need to retreive opportunitites 'Stage' and 'Amount' with the camapign 'name' and campaign 'type'. As you guess, campaign name & campaign type are available on campaign table only.
That's where I'm stuck on the SOQL.
I can't put the righ ones on the right order.. between select, child parent etc.
Is there a generous soul to help me here ?
thanks !!
I'm not a regular SFDC user, and I've never used SOQL. However I need to create a simple query but I can't find the right formula. I read a lot on the topics but the more I read the more I'm confused.
If you can help, it will be great.
I just want to retreive 4 fields : 2 from Opportunity table and 2 from Campaign table. In Opportunity table there is primary key 'CampaignId' which links the 2 tables. I need to retreive opportunitites 'Stage' and 'Amount' with the camapign 'name' and campaign 'type'. As you guess, campaign name & campaign type are available on campaign table only.
That's where I'm stuck on the SOQL.
I can't put the righ ones on the right order.. between select, child parent etc.
Is there a generous soul to help me here ?
thanks !!
Hi Pierre MICELI,
As i understand you want to retrieve four fields 2 from opportunity and 2 from campaign sobject.
If you want to retrieve any respective fields from parent object then directly you can give the field name and the respective sobject name as below.
[select name,amount,stagename from opportunity];
As campaign is a child of opportunity if you want to retrieve any of the child fields you can just simply use the dot(.)notation as below.
[select Campaign.name,Campaign.status from opportunity];
The SOQL query to retrieve two fields from opportunity(parent) and two fields from campaign(child) can be as below
[select name,amount,stagename,campaign.name,campaign.type from opportunity];
Please let me know if it helps you.......
Thanks & Regards,
Nagendra.p
9848950830
All Answers
You can try like below .
Here Name and stageName are opportunity fields .if you need to pull any campaign fields then you need to add campaign,fieldapi name .
Let me know if it helps !!
Thanks
Manoj
Hi Pierre MICELI,
As i understand you want to retrieve four fields 2 from opportunity and 2 from campaign sobject.
If you want to retrieve any respective fields from parent object then directly you can give the field name and the respective sobject name as below.
[select name,amount,stagename from opportunity];
As campaign is a child of opportunity if you want to retrieve any of the child fields you can just simply use the dot(.)notation as below.
[select Campaign.name,Campaign.status from opportunity];
The SOQL query to retrieve two fields from opportunity(parent) and two fields from campaign(child) can be as below
[select name,amount,stagename,campaign.name,campaign.type from opportunity];
Please let me know if it helps you.......
Thanks & Regards,
Nagendra.p
9848950830
You made my day !
Yes it works, and by reading your answers, it was quite simple... I was looking for a more complex solution trying to recreate links between tables. So everything is fine now.
thanks again