Don't miss out Virtual Happy Hour this Friday (April 26).

Try our conversational search powered by Generative AI!

Fetching Past 30 days Recent orders

Vote:
 

Hi All,

I am trying to fetch past 30 days order history(similar to episerver commerce admin functionality). 

I am able to fetch for a particular customer but not able to fetch as whole.

Can you please let me know if there are any existing methods or api's related to it.

Thanks in advance.

Regards,

Manik

#199684
Dec 05, 2018 14:15
Vote:
 

You can use this parameters and options for orders modified in last 30 days

                OrderSearchParameters parameters = new OrderSearchParameters
                {
                    SqlMetaWhereClause = $"Meta.Modified <  GETDATE() - 30 ",
                };

                OrderSearchOptions options = new OrderSearchOptions {Namespace = "Mediachase.Commerce.Orders"};

Or use Meta.Created for orders created in last 30 days

#199685
Dec 05, 2018 14:58
Vote:
 

Thanks for the information

#199696
Dec 06, 2018 14:26
* You are NOT allowed to include any hyperlinks in the post because your account hasn't associated to your company. User profile should be updated.