function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
MarkL.ax269MarkL.ax269 

Data Loader bug with semi joins

I wasn't sure where to post this since it's a bug in the Data Loader that involves semi-joins and parent/child subqueries, and I will log a case with it too.  Anyone else seen this?  I'm trying to put together a very simple semi-join query that works just fine against the API in Eclipse, but fails with an "invalid query" error in the Data Loader.

 

select Id, Name, (select Id from Tasks) from Opportunity where Id in (select OpportunityId from OpportunityLineItem where Description = 'test')
 
 
If I remove the child sub-query it works fine in Data Loader, and the full query with the child query works fine in Eclipse.  Looks like a bug in Data Loader on query validation.
 
Mark 


MarkL.ax269MarkL.ax269
On second thought, it looks like the Data Loader can't accept child subqueries at all, looks more like a feature request then.  Sorry.