details: https://code.openbravo.com/erp/devel/pi/rev/66d0835d6c60
changeset: 19653:66d0835d6c60
user: Augusto Mauch <augusto.mauch <at> openbravo.com>
date: Tue Feb 12 12:49:06 2013 +0100
summary: Fixes issue 22932: Computed columns are ignored in the linked items
Computed columns (columns with sqllogic not null) are ignored in the linked
items, to prevent trying to search for its physical column (they don't have
one).
diffstat:
src/org/openbravo/erpCommon/utility/UsedByLink_data.xsql | 1 +
1 files changed, 1 insertions(+), 0 deletions(-)
diffs (11 lines):
diff -r 98421b245460 -r 66d0835d6c60
src/org/openbravo/erpCommon/utility/UsedByLink_data.xsql
--- a/src/org/openbravo/erpCommon/utility/UsedByLink_data.xsql Tue Feb 12
12:38:29 2013 +0100
+++ b/src/org/openbravo/erpCommon/utility/UsedByLink_data.xsql Tue Feb 12
12:49:06 2013 +0100
@@ -94,6 +94,7 @@
AND TB.ISACTIVE = 'Y'
AND W.ISACTIVE = 'Y'
AND (TB.WHERECLAUSE IS NULL OR TB.WHERECLAUSE NOT LIKE '%@%')
+ AND C.SQLLOGIC is NULL
GROUP BY M.AD_MENU_ID, (case when Wt.NAME IS NULL then W.NAME else
Wt.NAME end),
(case when TBt.NAME IS NULL then TB.NAME else TBt.NAME end),
a.referenced_column_id, T.TABLENAME, C.COLUMNNAME, TB.AD_TAB_ID, W.AD_WINDOW_ID
ORDER BY 1, (case when Wt.NAME IS NULL then W.NAME else Wt.NAME end),
------------------------------------------------------------------------------
Free Next-Gen Firewall Hardware Offer
Buy your Sophos next-gen firewall before the end March 2013
and get the hardware for free! Learn more.
http://p.sf.net/sfu/sophos-d2d-feb
_______________________________________________
Openbravo-commits mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/openbravo-commits
