with the customer's second purchase, this column will return a value of 1-2 .
You are joining sales_order and sales_order_item table correctly also add
the table, and commonly used in joins to other tables within the Magento instance ... to sales_order.increment_id and returning the sales_order.created_at field.
You can add a new column, a field in sales_order_item table using
created_at, Creation timestamp of the order item, usually stored locally in UTC .
After lots of research, I've come up with various solutions to this problem, non of which seem ideal, but someone might be able to improve on ...
Besides the above solutions to help you get order collect filter, there is another way.
Step 2. in the second step just replace the code with below one.
You can add a new column, a field in sales_order_item table using db_schema.xml under your module, etc
Bug fixes for these projects are documented in separate,