details: https://code.openbravo.com/erp/devel/pi/rev/ae79cd15bab6
changeset: 18204:ae79cd15bab6
user: Shankar Balachandran <shankar.balachandran <at> openbravo.com>
date: Tue Oct 09 15:35:09 2012 +0200
summary: Fixes Issue 0021883: Linked items to the 'Table Reference' tab not
working.
Fixed case where navigation through linked items fails where the table has
primary and secondary keys.
diffstat:
src/org/openbravo/erpCommon/utility/UsedByLink_data.xsql | 2 +-
1 files changed, 1 insertions(+), 1 deletions(-)
diffs (12 lines):
diff -r ebea3541b581 -r ae79cd15bab6
src/org/openbravo/erpCommon/utility/UsedByLink_data.xsql
--- a/src/org/openbravo/erpCommon/utility/UsedByLink_data.xsql Thu Oct 11
17:36:43 2012 +0200
+++ b/src/org/openbravo/erpCommon/utility/UsedByLink_data.xsql Tue Oct 09
15:35:09 2012 +0200
@@ -156,7 +156,7 @@
FROM AD_COLUMN C, AD_FIELD F
WHERE C.AD_COLUMN_ID = F.AD_COLUMN_ID
AND C.ISACTIVE = 'Y'
- AND (C.ISKEY = 'Y' OR ISSECONDARYKEY = 'Y')
+ AND COALESCE(C.ISKEY,C.ISSECONDARYKEY) = 'Y'
AND F.AD_TAB_ID = ?
ORDER BY C.SEQNO
]]>
------------------------------------------------------------------------------
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
