Modified example query list widget to add a fixed parameter with a js expression as value.
authorGorka Ion Damián <gorkaion.damian@openbravo.com>
Mon, 13 Dec 2010 16:46:57 +0100
changeset 9102 b8ec45242e12
parent 9101 b8ffaca422e9
child 9103 cf8a679bf9fc
Modified example query list widget to add a fixed parameter with a js expression as value.
modules/org.openbravo.client.querylist/src-db/database/sourcedata/OBCQL_WIDGET_QUERY.xml
modules/org.openbravo.client.querylist/src-db/database/sourcedata/OBUIAPP_PARAMETER.xml
--- a/modules/org.openbravo.client.querylist/src-db/database/sourcedata/OBCQL_WIDGET_QUERY.xml	Mon Dec 13 16:46:18 2010 +0100
+++ b/modules/org.openbravo.client.querylist/src-db/database/sourcedata/OBCQL_WIDGET_QUERY.xml	Mon Dec 13 16:46:57 2010 +0100
@@ -9,6 +9,7 @@
 <!--C0A8491CDB43466D9F2645018473588B-->  <HQL><![CDATA[select tab.window.name as windowName, tab.name as tabName, tab.id as tabId
 from ADTab tab
 where window.name like :window_name
+  and window.client.id = :client
 order by tab.window.name]]></HQL>
 <!--C0A8491CDB43466D9F2645018473588B--></OBCQL_WIDGET_QUERY>
 
--- a/modules/org.openbravo.client.querylist/src-db/database/sourcedata/OBUIAPP_PARAMETER.xml	Mon Dec 13 16:46:18 2010 +0100
+++ b/modules/org.openbravo.client.querylist/src-db/database/sourcedata/OBUIAPP_PARAMETER.xml	Mon Dec 13 16:46:57 2010 +0100
@@ -56,4 +56,23 @@
 <!--95F5AD0B752C48A2E040007F01001111-->  <EM_OBKMO_WIDGET_CLASS_ID><![CDATA[D1E4261099AE4095B2F2DAEE0F7E7784]]></EM_OBKMO_WIDGET_CLASS_ID>
 <!--95F5AD0B752C48A2E040007F01001111--></OBUIAPP_PARAMETER>
 
+<!--AAF45F634C164AF2AED1B57FAF0CF124--><OBUIAPP_PARAMETER>
+<!--AAF45F634C164AF2AED1B57FAF0CF124-->  <OBUIAPP_PARAMETER_ID><![CDATA[AAF45F634C164AF2AED1B57FAF0CF124]]></OBUIAPP_PARAMETER_ID>
+<!--AAF45F634C164AF2AED1B57FAF0CF124-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--AAF45F634C164AF2AED1B57FAF0CF124-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--AAF45F634C164AF2AED1B57FAF0CF124-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--AAF45F634C164AF2AED1B57FAF0CF124-->  <AD_MODULE_ID><![CDATA[0A060B2AF1974E8EAA8DB61388E9AECC]]></AD_MODULE_ID>
+<!--AAF45F634C164AF2AED1B57FAF0CF124-->  <NAME><![CDATA[Client]]></NAME>
+<!--AAF45F634C164AF2AED1B57FAF0CF124-->  <SEQNO><![CDATA[0]]></SEQNO>
+<!--AAF45F634C164AF2AED1B57FAF0CF124-->  <AD_REFERENCE_ID><![CDATA[10]]></AD_REFERENCE_ID>
+<!--AAF45F634C164AF2AED1B57FAF0CF124-->  <COLUMNNAME><![CDATA[client]]></COLUMNNAME>
+<!--AAF45F634C164AF2AED1B57FAF0CF124-->  <ISCENTRALLYMAINTAINED><![CDATA[Y]]></ISCENTRALLYMAINTAINED>
+<!--AAF45F634C164AF2AED1B57FAF0CF124-->  <FIELDLENGTH><![CDATA[0]]></FIELDLENGTH>
+<!--AAF45F634C164AF2AED1B57FAF0CF124-->  <ISMANDATORY><![CDATA[N]]></ISMANDATORY>
+<!--AAF45F634C164AF2AED1B57FAF0CF124-->  <ISFIXED><![CDATA[Y]]></ISFIXED>
+<!--AAF45F634C164AF2AED1B57FAF0CF124-->  <FIXEDVALUE><![CDATA[OB.getContext().getCurrentClient().id]]></FIXEDVALUE>
+<!--AAF45F634C164AF2AED1B57FAF0CF124-->  <EVALUATEFIXEDVALUE><![CDATA[Y]]></EVALUATEFIXEDVALUE>
+<!--AAF45F634C164AF2AED1B57FAF0CF124-->  <EM_OBKMO_WIDGET_CLASS_ID><![CDATA[D1E4261099AE4095B2F2DAEE0F7E7784]]></EM_OBKMO_WIDGET_CLASS_ID>
+<!--AAF45F634C164AF2AED1B57FAF0CF124--></OBUIAPP_PARAMETER>
+
 </data>