• TommyJohnw
  • NEWBIE
  • 0 Points
  • Member since 2009

  • Chatter
    Feed
  • 0
    Best Answers
  • 0
    Likes Received
  • 0
    Likes Given
  • 0
    Questions
  • 1
    Replies

I'm having the hardest time trying to get what I believe should be an easy answer regarding a SOQL query that doesn't work in the Apex DataLoader (14.0)

 

A query created with Ajax Tools (2.0) returns expected results but when I run the query in the DataLoader I get a "Malformed Query" error.  This is the case whether I run it with the DataLoader GUI or from the CLI.

 

SELECT Account.Name, Name, Amount, Probability, ExpectedRevenue, (SELECT  Quantity, TotalPrice, UnitPrice, pricebookentry.productcode FROM OpportunityLineItems) FROM Opportunity Where amount > 4000000

 

 

Any help is greatly appreciated

Mike