Developer forum

I cannot see your context where this code executes or what data you have in your database.

Here is an example of how we do it:

if (userId > 0)
{
    var filter = new OrderSearchFilter();
    filter.CustomerId = userId;
    filter.IsCart = true;
    filter.Completed = OrderSearchFilter.CompletedStates.NotCompleted;
    filter.PageNumber = CurrentPage;
    filter.PageSize = PageSize;
    filter.OrderBy = $"OrderDate DESC";
    foreach (var order in Services.Orders.GetOrdersBySearch(filter).ResultOrders)
    {
        //...
    }
}

It requires that the orders have OrderCustomerAccessUserID or OrderSecondaryUserId set to the id you pass as CustomerID.

BR Nicolai

Thanks Nicolai,

Sorry for not providing more details, but an example of it being used is exactly what I needed.  If it requires the use of the customerId, what is the purpose of providing the customerNumber?

Thanks,

Kevin

Customer number is different. 2 users can share customer number - that is the account number. So using customer number, if set on the user when making the purchase, would give you orders across several users.

BR Nicolai

Nicolai, In this instance we actually want to be able pull orders from mulitple users if they share the same customer number.  Is there a work around for this?

It also works with customer number. We do that our selves as well.

The order objects in the database have to have the customer number on them though.

So if the order objects only have userid and the users on the user database have customer number, the orders from other users with same customer number is not located.

The orders on the order table will have to have the customer number on them as well.

Could that be the case - that it is missing?

Thanks Nicolai,

Sorry for the delay in response, I wanted to double check some things before posting again.  On this particular project we currently don't utilize OrderCustomerAccessUserId, instead we track OrderCustomerNumber.  However when running the search based upon OrderCustomerNumber, we are given the same 4 products regardless of logged in user.  

I ran a SQL query to pull up what should be shown from user CustomerNumber 000100-000100 and it yeilded 2 pages of results: 

Hopefully that gives a better picture of the issues we are having.  Does anything stand out to you as a possible issue?

Thanks again,

Kevin

Yeah, it is not that simple since that method also handles security in terms of what can be seen and not.

Try to set all these properties on your filter:

IncludeImpersonation = False
CustomerID = 123 (This ID has to be of a user that has the below customer number)
CustomerNumber = '000100-001-00'

Thanks Nicolai, we will first need to add userID to the orders then I can try and implement your recommendations.

Thanks,

Kevin