LightningFlowComponents icon indicating copy to clipboard operation
LightningFlowComponents copied to clipboard

Add support for multiple semi-select sub queries

Open systemsfixer opened this issue 3 years ago • 0 comments

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.

systemsfixer avatar Dec 28 '21 22:12 systemsfixer