Top 10 Parent records and all child records in one retrieve call using FetchXML

(0) Share

Report

Posted on by Mihir Maruti Kadam

702

I want to retrieve ten campaign records (Linked with campaign activity) in one retrieve call. How to achieve this using fetchXML?

Note: If we specified count attribute in fetchXml then it will work on entire Data set (Combination of campaigns and campaign activities). I want only ten campaign records and all child records(Campaign activity.)

*This post is locked for comments

I have the same question (0)

All responses (1)

Answers (0)

Suggested answer

ashlega 34,477 on at

Like (0)

Report

RE: Top 10 Parent records and all child records in one retrieve call using FetchXML

Pretty sure you'll have to use two fetch queries: get top 10 campaign records first, then use the id-s of those campaigns to define conditions for the campaign activities.

If you want this to work on a dashboard etc.. Maybe create a pre-retrieve multiple plugin to update those conditions on the campaign activity queries (in the pre-retrievemultiple for campaign activities, get those top 10 campaings.. then update the conditions)

Was this reply helpful? Yes No