You need to sign in to do that
Don't have an account?
TehNrd
Opps w/ Products using SOQL?
I am essentially trying to replicate an Opportunity with Products report using one SOQL query. I pulled this query from the API documentation, page 339
http://www.salesforce.com/us/developer/docs/api/index.htm (PDF).
SELECT Amount, Id, Name, (SELECT Quantity, ListPrice,
PriceBookEntry.UnitPrice, PricebookEntry.Name,
PricebookEntry.product2.Family FROM OpportunityLineItems)
FROM Opportunity
To test it out I pasted it in the Data Loader but recieve an "Error in query: Malformed query string".
Any ideas? Much thanks.
http://www.salesforce.com/us/developer/docs/api/index.htm (PDF).
SELECT Amount, Id, Name, (SELECT Quantity, ListPrice,
PriceBookEntry.UnitPrice, PricebookEntry.Name,
PricebookEntry.product2.Family FROM OpportunityLineItems)
FROM Opportunity
To test it out I pasted it in the Data Loader but recieve an "Error in query: Malformed query string".
Any ideas? Much thanks.
We've got a need to use that type of query to pull data in to a local SQL database and I was curious as to how the headers would be formated. I guess I'll let IT worry about it.
Thanks again.
SELECT id, parent.id from account
Not sure that helps you in this instance, but that's all the info I have right now.