LightningFlowComponents
LightningFlowComponents copied to clipboard
Add support for multiple semi-select sub queries
Problem: ExecuteSOQL class fails when multiple semi-select sub queries are used.
Example VALID query that fails:
SELECT Fields FROM Object WHERE Conditions AND Id in
(SELECT otherId FROM otherObject WHERE Conditions) and id not in (select otherId from otherObject2 where Conditions)
The above works via API or Dev Console, but returns the following error from ExecuteSOQL class: Unable to get sObject Type for name: Query String Here
Solution Desired: Add support for multiple semi-select sub queries
Alternatives / Work Arounds: Do separate queries or get records and use collection processing invocable apex or built in collection assignment operations to further filter records retrieved by a SOQL query with only 1 semi select.