details: https://code.openbravo.com/erp/devel/pi/rev/b43a95e243bf
changeset: 18166:b43a95e243bf
user: Shankar Balachandran <shankar.balachandran <at> openbravo.com>
date: Tue Oct 09 10:37:46 2012 +0200
summary: Fixes Issue 0021887: Error message when Completing an Invoice in
Oracle
Changed incorrect where clause for OBQuery in DefaultDataSourceService.java.
Related to fix 21868, Handling Inactive fields in Tab Access.
diffstat:
modules/org.openbravo.service.datasource/src/org/openbravo/service/datasource/DefaultDataSourceService.java
| 2 +-
1 files changed, 1 insertions(+), 1 deletions(-)
diffs (12 lines):
diff -r ed84b3d4f8e4 -r b43a95e243bf
modules/org.openbravo.service.datasource/src/org/openbravo/service/datasource/DefaultDataSourceService.java
---
a/modules/org.openbravo.service.datasource/src/org/openbravo/service/datasource/DefaultDataSourceService.java
Tue Oct 09 00:31:04 2012 +0200
+++
b/modules/org.openbravo.service.datasource/src/org/openbravo/service/datasource/DefaultDataSourceService.java
Tue Oct 09 10:37:46 2012 +0200
@@ -231,7 +231,7 @@
Field.class,
"as f where f.tab.id = :tabId"
+ " and (exists (from f.aDFieldAccessList fa where
fa.tabAccess.windowAccess.role.id = :roleId and fa.editableField = false and
fa.active = true and fa.ischeckonsave = true)"
- + " or (not exists (from f.aDFieldAccessList fa where
fa.tabAccess.windowAccess.role.id = :roleId and and fa.active = true)"
+ + " or (not exists (from f.aDFieldAccessList fa where
fa.tabAccess.windowAccess.role.id = :roleId and fa.active = true)"
+ " and exists (from f.tab.aDTabAccessList ta where
ta.windowAccess.role.id = :roleId and ta.editableField = false and ta.active =
true)"
+ " or not exists (from f.tab.aDTabAccessList ta
where ta.windowAccess.role.id = :roleId and ta.active = true)"
+ " and exists (from ADWindowAccess wa where
f.tab.window = wa.window and wa.role.id = :roleId and wa.editableField = false
and wa.active = true)))");
------------------------------------------------------------------------------
Don't let slow site performance ruin your business. Deploy New Relic APM
Deploy New Relic app performance management and know exactly
what is happening inside your Ruby, Python, PHP, Java, and .NET app
Try New Relic at no cost today and get our sweet Data Nerd shirt too!
http://p.sf.net/sfu/newrelic-dev2dev
_______________________________________________
Openbravo-commits mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/openbravo-commits
