You need to sign in to do that
Don't have an account?
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?
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?