Questions tagged [semi-join]

Use this tag when discussing a subquery that appears in the WHERE clause of a SOQL query

Filter by
Sorted by
Tagged with
1
vote
1answer
51 views

SELECT opportunities AND contacts AND tasks

o See all opportunities (where field isclosed = false), contacts and tasks (where field isclosed = false) related to the account. I Have This Select Select Id, (Select Id, WhoId FROM Tasks ...
3
votes
2answers
521 views

Entity 'Task' is not supported for semi join inner selects

I want add a default task to an opportunity when this one is close won and the opportunity hasn't any task. I get the error compiling the below code: Entity 'Task' is not supported for semi join ...
2
votes
2answers
1k views

Maximum 2 semi join sub-selects are allowed

While I'm querying on account object based on several conditions from different object I'm getting the below error: Maximum 2 semi join sub-selects are allowed . The following the query which I'm ...