I am writing soql query to get unitprice,standard price fields which are in pricebook entry object.

    Id, Unitprice, UseStandardPrice, StandardPrice
    FROM PriceBookEntry

But if i use without "Pricebookentry.StandardPrice" in soql query it is working fine. How to get Pricebookentry.StandardPrice values into query

1 Answer 1

SELECT UnitPrice FROM PricebookEntry WHERE Pricebook2.isStandard = true and Id = 'yourId'
  • Thanks for your efforts it is working fine. I am able to get details. I marked it as best answer just now.
    – swa
    Commented Jan 31, 2015 at 16:44
  • please also upvote my answer (+1). Happy for you!
    – user9959
    Commented Jan 31, 2015 at 16:45
  • 1
    Sure can u pls help me in another question i posted most recent 1, salesforce.stackexchange.com/questions/64891/… here is link
    – swa
    Commented Jan 31, 2015 at 16:48
  • I already posted click on above link and comment there is possibility or not
    – swa
    Commented Jan 31, 2015 at 16:49
  • ok let me read!
    – user9959
    Commented Jan 31, 2015 at 16:49

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .