November Happy Hour will be moved to Thursday December 5th.
AI OnAI Off
Extract orders related to specific supplier in a many to many B2B scenario
Hi - yes, for now OrderContext.Search is your best bet. We are working on search using abstraction APIs (IOrderSearch), however it is still a long way ahead.
Sounds like you can search for orders that contains items from a specific supplier by this
var searchParameters = new OrderSearchParameters();
//other things
searchParameters.SqlWhereClause= $" OrderGroupId in (SELECT OrderGroupId From LineItem li INNER JOIN LineItemEx lie ON li.LineItemId = lie.ObjectId WHERE lie.Supplier = {supplier}) ";
//Search
Two notes:
- The code above is untested by me. You would have to check that.
- If you are querying by the Supplier (or whatever its name is) column of LineItemEx, consider adding an index for it for performance: https://vimvq1987.com/index-or-no-index-thats-the-question/
Edited,
Mar 27, 2019 14:20
This topic was created over six months ago and has been resolved. If you have a similar question, please create a new topic and refer to this one.
Hi,
Usually, you have the screnario where "Company X" sells to n numbers of customers. When loading a customers orders, you do:
_orderRepository.Load<IPurchaseOrder>(customerId);However, in our solution, we need to support n numbers of suppliers selling to n numbers of customers. One order can contain articles from different suppliers. Loading the customers orders we can do as above, however, I'm not sure what strategy to take to load the all orders related to a supplier.
Currently, a reference to the supplier is stored on the line item in commerce.
Does anyone have any input, tips or trix in regards to a good solution to extract orders related to one specific supplier? I came across the "OrderSearchOptions", would that be a good option?
Thanks!
/Jessica