In an org, some of the Activity records do not have related Opportunity records. Additionally, there are Opportunity records that do not have related Activity records.
Which SAQL statement will fetch all Opportunities, even if they don't have associated Activities, and fetch related Activity data, if it exists?
- q = cogroup Opportunity by 'Id', Activities by 'Opportunityld';
- q = cogroup Opportunity by 'Id', Activities by 'Opportunityld' left;
- q = cogroup Opportunity by 'Id' right, Activities by 'Opportunityld';
- q = cogroup Opportunity by 'Id' left, Activities by 'Opportunityld';
Answer(s): D
Explanation:
https://developer.salesforce.com/docs/atlas.en-us.bi_dev_guide_saql.meta/bi_dev_guide_saql/bi_saql_statement_cogroup.htm
Reveal Solution
Next Question