Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
0028708Openbravo ERPA. Platformpublic2015-01-21 11:162015-01-21 11:16
jecharri 
AugustoMauch 
highminoralways
newopen 
5
 
 
Core
No
0028708: Case statement is not supported in Order By clause
Case statement is not supported in Order By clause
-login as system
-go to tables and columns and use CASE statement

If you enable the hql log in log4j.lcf you will see that Openbravo is removing the case statement an inserting something strange

For case:
CASE etapa WHEN 'P' THEN 1 WHEN 'M' THEN 2 WHEN 'E' THEN 3 WHEN 'D' THEN 4 WHEN 'C' THEN 5 ELSE 6 END
Openbravo is doing
order by e etapa
No tags attached.
Issue History
2015-01-21 11:16jecharriNew Issue
2015-01-21 11:16jecharriAssigned To => AugustoMauch
2015-01-21 11:16jecharriModules => Core
2015-01-21 11:16jecharriTriggers an Emergency Pack => No

There are no notes attached to this issue.