Fixes issue 0027094: Error after opening a saved view ordered by a foreign key column in the Role window
authorShankar Balachandran <shankar.balachandran@openbravo.com>
Mon, 04 Aug 2014 12:16:50 +0530
changeset 24153 9ca3a8d726f5
parent 24152 bae6b944d95a
child 24154 7507a81f4e63
Fixes issue 0027094: Error after opening a saved view ordered by a foreign key column in the Role window

Added alias to hql where clause. When foreign key column is used a join is created, so client.id will not resolved properly.
src-db/database/sourcedata/AD_TAB.xml
--- a/src-db/database/sourcedata/AD_TAB.xml	Mon Aug 04 08:40:38 2014 +0200
+++ b/src-db/database/sourcedata/AD_TAB.xml	Mon Aug 04 12:16:50 2014 +0530
@@ -573,7 +573,7 @@
 <!--119-->  <ISSORTTAB><![CDATA[N]]></ISSORTTAB>
 <!--119-->  <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
 <!--119-->  <UIPATTERN><![CDATA[STD]]></UIPATTERN>
-<!--119-->  <HQLWHERECLAUSE><![CDATA[client.id = @#ad_client_id@]]></HQLWHERECLAUSE>
+<!--119-->  <HQLWHERECLAUSE><![CDATA[e.client.id = @#ad_client_id@]]></HQLWHERECLAUSE>
 <!--119-->  <SHOWPARENTBUTTONS><![CDATA[Y]]></SHOWPARENTBUTTONS>
 <!--119-->  <DISABLE_PARENT_KEY_PROPERTY><![CDATA[N]]></DISABLE_PARENT_KEY_PROPERTY>
 <!--119-->  <ISREADONLYTREE><![CDATA[N]]></ISREADONLYTREE>