details: https://code.openbravo.com/erp/devel/pi/rev/731797e5038f
changeset: 17714:731797e5038f
user: David Miguelez <david.miguelez <at> openbravo.com>
date: Mon Aug 20 15:18:26 2012 +0200
summary: Fixes issue 0021393: Orders the query properly.
diffstat:
src/org/openbravo/costing/CostingServer.java | 2 +-
1 files changed, 1 insertions(+), 1 deletions(-)
diffs (12 lines):
diff -r 72d6045b34d9 -r 731797e5038f
src/org/openbravo/costing/CostingServer.java
--- a/src/org/openbravo/costing/CostingServer.java Mon Aug 20 13:40:26
2012 +0200
+++ b/src/org/openbravo/costing/CostingServer.java Mon Aug 20 15:18:26
2012 +0200
@@ -152,7 +152,7 @@
where.append(" and (" + CostingRule.PROPERTY_ENDINGDATE + " is null");
where.append(" or " + CostingRule.PROPERTY_ENDINGDATE + " > :enddate )");
where.append(" order by case when " + CostingRule.PROPERTY_STARTINGDATE
- + " is null then 0 else 1 end, " + CostingRule.PROPERTY_STARTINGDATE +
" desc");
+ + " is null then 1 else 0 end, " + CostingRule.PROPERTY_STARTINGDATE +
" desc");
where.append(" and " + CostingRule.PROPERTY_VALIDATED + " = true");
OBQuery<CostingRule> crQry =
OBDal.getInstance().createQuery(CostingRule.class,
where.toString());
------------------------------------------------------------------------------
Live Security Virtual Conference
Exclusive live event will cover all the ways today's security and
threat landscape has changed and how IT managers can respond. Discussions
will include endpoint security, mobile security and the latest in malware
threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/
_______________________________________________
Openbravo-commits mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/openbravo-commits
