1
vote
Accepted
Correlated Not In Subquery
No, correlated subqueries are not supported. But in Apex you can use the same variable with the case identifier in both queries:
SELECT Id
FROM Task
WHERE Type = 'Case'
AND WhatId = :caseId
AND ...
Only top scored, non community-wiki answers of a minimum length are eligible
Related Tags
soql × 5885apex × 2794
query × 649
visualforce × 405
trigger × 374
dynamic-soql × 303
governorlimits × 229
relationships × 159
batch × 143
rest-api × 140
unit-test × 118
community × 112
list × 106
sosl × 103
aggregate × 95
custom-object × 86
map × 79
api × 72
account × 72
date × 66
lookup × 61
sobject × 59
loop × 59
opportunity × 58
aggregateresult × 57