+ Start a Discussion
Daniel RobertsDaniel Roberts 

SOQL query on PricebookEntry Ids.

Greetings! 

I'm trying to run a query on PricebookEntry Ids that are in the Standard Pricebook. I'm close, but the PricebookEntry is returning an Object Notation along with Unit Price. 

SELECT Id, Description, IsActive, Name,  (SELECT Id FROM PricebookEntries WHERE Pricebook2Id = '001sx15498795xfw) FROM Product2

Result = [{"Id":"01x79845261xgwAAQ"}]


I'm trying to get the value by itself; i.e. not as an array or object. Any ideas?