Find Orders Broken ------------------ Key: OFBIZ-3797 URL: https://issues.apache.org/jira/browse/OFBIZ-3797 Project: OFBiz Issue Type: Bug Components: order Affects Versions: SVN trunk Reporter: Chirag Manocha Priority: Blocker Fix For: SVN trunk
Go to Order Manager Go to Find Orders Click on Search Expected Result : All orders should be Displayed or No order Founds should be displayed in search result. Actual Result : The Following Errors Occurred: SQL Exception while executing the following:SELECT DISTINCT OH.ORDER_ID, OH.ORDER_TYPE_ID, OH.ORDER_NAME, OH.ORDER_DATE, OH.STATUS_ID, OH.CURRENCY_UOM, OH.REMAINING_SUB_TOTAL, OH.GRAND_TOTAL FROM OFBIZ.ORDER_HEADER OH WHERE () ORDER BY OH.ORDER_DATE DESC, OH.ORDER_ID DESC (Syntax error: Encountered ")" at line 1, column 182.) -- This message is automatically generated by JIRA. - You can reply to this email to add a comment to the issue online.