是否可以使用 SOSL 进行子查询？

发布于 2024-12-15 10:30:35 字数 381 浏览 5 评论 0原文

我有一个 SOSL 查询来查找 Salesforce 营销活动，并且工作得很好。但是，我需要检索每个返回的营销活动的所有客户团队成员。是否可以向 SOSL 添加子查询？

到目前为止，我的情况如下：

List<List<sObject>> searchList = 
    [FIND :CampaignSearchTerm RETURNING Campaign (Id Where IsActive = true Order By Name)];

如果不可能，我有一个不同的问题。 SOSL 结果是否可以分配给 Map 或 Set，以避免在 SOQL 查询的 for 循环中将所有 ID 放在一起（为了提高效率）？

谢谢！

原文

I have a SOSL query that finds Salesforce Campaigns, and that's working just fine. However, I need to retrieve all Account Team Members for each returned Campaign. Is it possible to add a subquery to SOSL?

Here's what I have so far:

List<List<sObject>> searchList = 
    [FIND :CampaignSearchTerm RETURNING Campaign (Id Where IsActive = true Order By Name)];

If it is not possible, I have a different question. Can SOSL results be assigned to a Map or Set to avoid from having to put together all of the IDs in a for-loop for an SOQL query (for the sake of efficiency)?

Thanks!

分享到QQ

分享到微博