Skip to Main Content
Customer Feedback

We love feedback from you on our products and the problems in your daily work that you would like us to solve. Please describe the challenge you're encountering and your desired outcome. Be as detailed as possible.

For technical issues or bugs please head to Support or our Developer Community. You can assign up to 10 votes in total. Thank you for your feedback.

Categories Order Management
Created by Guest
Created on Apr 8, 2022

Error in OOTB P21:07 - Order History Step 2 SQL

I've noticed an error in the OOTB sql script for the Order History - Order Detail job step.

Navigate to the following link and review the WHERE clause. The final statement has oh.date_last_modified twice and I believe one of these should be ol.date_last_modified instead.

https://thedistributionpoint.commerce.insitesandbox.com/admin/data/jobdefinitionsteps/ab436103-441b-4299-802b-fa1451bb2c6e?parents=jobDefinitions&parentids=30ffa786-ce2c-4faf-87b8-4e02bc5284fe

I have not had any errors reported due to this issue. Low priority.