[OFBIZ-3797] Find Orders Broken

• Type: Bug
• Status: Closed
• Priority: Blocker
• Resolution: Fixed
• Affects Version/s: Trunk
• Fix Version/s: Trunk
• Component/s: order
• Assignee: Adam Heath
• Reporter: Chirag Manocha
• Created: 02/Jun/10 08:50
• Updated: 03/Jun/10 06:11
• Resolved: 03/Jun/10 05:57

Description

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.)