Hi Experts,
How to check ordered product on the behalf of orderId ?
Please give me suggestion.
Thanks in advance!
*This post is locked for comments
Hi,
You can write a retrieve multiple request to fetch orderline item based on the order id. Can use simple fetch like below as well
string orderlinefetch = string.Format(@"<?xml version="1.0"?>
<fetch distinct="false" mapping="logical" output-format="xml-platform" version="1.0">
<entity name="salesorderdetail">
<attribute name="productid"/>
<attribute name="productdescription"/>
<attribute name="priceperunit"/>
<attribute name="quantity"/>
<attribute name="extendedamount"/>
<attribute name="salesorderdetailid"/>
<order descending="false" attribute="productid"/>
<filter type="and">
<condition attribute="salesorderid" operator="eq" value="orderid"/>
</filter>
</entity>
</fetch>");
EntityCollection orderlineEntities = orgService.RetrieveMultiple(new FetchExpression(orderlinefetch));
Hi,
If you want to do it using client side, use webapi to retrieve the order product. Refer below article for more information.
[View:https://msdn.microsoft.com/en-us/library/gg334767.aspx:750:50]
if you want to do it using workflow or plugin.
FetchXML
[View:https://msdn.microsoft.com/en-us/library/gg328332.aspx:750:50]
Query Expression
[View:https://msdn.microsoft.com/en-us/library/gg328300.aspx:750:50]
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 291,253 Super User 2024 Season 2
Martin Dráb 230,188 Most Valuable Professional
nmaenpaa 101,156