Developer forum

Forum » CMS - Standard features » Smart search: Total order value for a periode

Smart search: Total order value for a periode

E-mail notifications
Johannes van den Berg Dynamicweb Employee
Johannes van den Berg
Reply
Posted on 28/04/2021 19:26:50

Hi all,

I have a list of orders:

As you can see, Mr. Business have a total order value of $ 5.604,88 in the month April

 

I add a smart search:

So what I'm expecting with this smart search is that the system is searching for ordersvalues higher as 5700 in the month April 2021

But the outcome is:

Is this a mis interpretation from my end or a bug? In this case the smart search count the total value of orders AND looks if there is an order placed in April. 

Hopefully I hear


Replies

 
Nicolai Pedersen
Posted on 28/04/2021 20:52:17
Reply

Those 2 fields and conditions are not connected.

You are searching users. So you look for users that has any order after april 1st and users that has ordered for more than 5700 in total at all times. Not the total in that period.

So what you are trying is not possible I am affraid.

 
Nicolai Pedersen
Posted on 28/04/2021 20:53:09
Reply

Consider the logic if it was an 'or' instead of an 'and'. How should that work...?

 

You must be logged in to post in the forum