Error when filtering Order grid by date - Githubissues

taxjar / taxjar-magento2-extension

Magento 2 Sales Tax Extension by TaxJar

http://www.taxjar.com/guides/integrations/magento2/

Open Software License 3.0

22 stars 29 forks source link

Error when filtering Order grid by date #341

Closed khoimm92 closed 1 year ago

khoimm92 commented 1 year ago

Prerequisites

[x] Are you running the latest version of our extension?
[x] Have you reviewed our integration guide?
[x] Did you search through existing issues?

Description

Can't filter the orders by Purchase date.

Steps to Reproduce

Go to the sales order page
Try filter by a purchase date

Expected Result

The result will be shown without any errors

Actual Result

There was an error, the grid keeps infinity loading. The log says:

Integrity constraint violation: 1052 Column 'created_at' in where clause is ambiguous

Versions

[x] Magento 2.4
[ ] Magento 2.3
[x] Magento Open Source (fka Magento 2 Community Edition)
[ ] Adobe Commerce (fka Magento 2 Enterprise Edition)
[ ] PHP 8.2
[x] PHP 8.1
[ ] PHP 7.4
[ ] PHP 7.3

sethobey commented 1 year ago