Get Pricebookentry.StandardPrice value into soql query

Question

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

[SELECT
    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

user9959user9959 · Accepted Answer · 2015-01-31 16:42:19Z

2

SELECT UnitPrice FROM PricebookEntry WHERE Pricebook2.isStandard = true and Id = 'yourId'

answered Jan 31, 2015 at 16:42

user9959

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

Add a comment |

1 Answer 1