[ https://issues.apache.org/jira/browse/OFBIZ-3797?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Chirag Manocha reopened OFBIZ-3797: ----------------------------------- > 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 > Assignee: Adam Heath > Priority: Blocker > Fix For: SVN trunk > > Attachments: OFBiz-3797.png > > > 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.