Issue on Smart Search Filter

Yoon Peti Nwe

Posted on 09/12/2022 05:21:28

Dear Nicolai,

I would like to report the issue that we are getting when creating smart search by using the filter in the attached image however it return the SQL error.

Could you please suggest on this?

We are using DW version 9.14.5 however this issue happening on older version as well.

Error Message

Incorrect syntax near the keyword 'group'.: SELECT * FROM AccessUser WHERE AccessUserID IN (SELECT AccessUser.AccessUserID FROM AccessUser left outer join (select count(EcomOrders.OrderID) as last_month_orders_quantity, EcomOrders.OrderCustomerAccessUserID from EcomOrders where EcomOrders.OrderComplete = 1 and EcomOrders.OrderCompletedDate > '2022-11-08 19:21:36') group by EcomOrders.OrderCustomerAccessUserID) as _pseudo_ecommerce_last_month_orders_quantityEcomOrders on _pseudo_ecommerce_last_month_orders_quantityEcomOrders.OrderCustomerAccessUserID = AccessUser.AccessUserID WHERE AccessUserType IN (1,3,4,5,15) AND ((_pseudo_ecommerce_last_month_orders_quantityEcomOrders.last_month_orders_quantity = 1))) ORDER BY AccessUserId Desc

Thanks,

Yoon

Replies

Oleg Rodionov

Posted on 12/12/2022 04:16:25

Hi Yoon,

I was able to reproduce the issue on test environment based on 9.14.5 as well. I've created new task 11106 to fix it. Thanks a lot for finding!

BR, Oleg QA

Kristian Kirkholt

Posted on 15/12/2022 15:26:29

Hi Yoon

The problem #11106 On backend user list based on smart search
Has been fixed in Dynamicweb version 9.14.6
You can get this release from the download section https://doc.dynamicweb.dk/downloads/dynamicweb-9

Sorry for any inconvenience this may have caused

Kind Regards
Care Support
Kristian Kirkholt

Yoon Peti Nwe

Posted on 16/12/2022 03:58:19

Dear Both,

Thank you for your swift responses. :)

I will check on the upgrade version.

Thanks,

Yoon

You must be logged in to post in the forum

Developer forum

Issue on Smart Search Filter

Replies