Oct 05, 2015 at 03:14 PM

Query Procurement Price Specification by Product ID

292 Views

Dear community,

I would like to query procurement price specificaiton by a productID. I tried to do this with this code:

var priceSpecQuery = ProcurementPriceSpecification.QueryByTypeCodeAndPropertyIDAndPropertyValue;

var params = priceSpecQuery.CreateSelectionParams();

params.Add(priceSpecQuery.PropertyValuationPriceSpecificationElementPropertyValuation1.PriceSpecificationElementPropertyValue.ID.content, "I", "EQ", "TEST123");

params.Add(priceSpecQuery.PropertyValuationPriceSpecificationElementPropertyValuation1.PriceSpecificationElementPropertyReference.PriceSpecificationElementPropertyID.content, "I", "EQ", "CND_PRODUCT_ID");

var result = priceSpecQuery.Execute(params);

if(result.Count() >0)

{

var resultLine = result.GetFirst();

this.PurchasingPrice = resultLine.Amount;

}

There is no result, even thought there is a price specified for the Service Product "Test123".

Can you help me with that?

Kind regards,

Christine Toblier