[OBUISEL] Added HQL and Entity Alias field on Defined Selector tab
authorGorka Ion Damián <gorkaion.damian@openbravo.com>
Thu, 20 Jan 2011 18:23:46 +0100
changeset 10000 ace3d9ec29a7
parent 9999 2fa360c469d2
child 10001 d066934659bc
[OBUISEL] Added HQL and Entity Alias field on Defined Selector tab
modules/org.openbravo.userinterface.selector/src-db/database/model/tables/OBUISEL_SELECTOR.xml
modules/org.openbravo.userinterface.selector/src-db/database/sourcedata/AD_COLUMN.xml
modules/org.openbravo.userinterface.selector/src-db/database/sourcedata/AD_ELEMENT.xml
modules/org.openbravo.userinterface.selector/src-db/database/sourcedata/AD_FIELD.xml
--- a/modules/org.openbravo.userinterface.selector/src-db/database/model/tables/OBUISEL_SELECTOR.xml	Thu Jan 20 18:10:06 2011 +0100
+++ b/modules/org.openbravo.userinterface.selector/src-db/database/model/tables/OBUISEL_SELECTOR.xml	Thu Jan 20 18:23:46 2011 +0100
@@ -93,6 +93,14 @@
         <default><![CDATA[startsWith]]></default>
         <onCreateDefault><![CDATA['startsWith']]></onCreateDefault>
       </column>
+      <column name="HQL" primaryKey="false" required="false" type="VARCHAR" size="4000" autoIncrement="false">
+        <default/>
+        <onCreateDefault/>
+      </column>
+      <column name="ENTITY_ALIAS" primaryKey="false" required="false" type="VARCHAR" size="60" autoIncrement="false">
+        <default/>
+        <onCreateDefault/>
+      </column>
       <foreign-key foreignTable="AD_CLIENT" name="OBUISEL_S_AD_CLIENT">
         <reference local="AD_CLIENT_ID" foreign="AD_CLIENT_ID"/>
       </foreign-key>
--- a/modules/org.openbravo.userinterface.selector/src-db/database/sourcedata/AD_COLUMN.xml	Thu Jan 20 18:10:06 2011 +0100
+++ b/modules/org.openbravo.userinterface.selector/src-db/database/sourcedata/AD_COLUMN.xml	Thu Jan 20 18:23:46 2011 +0100
@@ -1584,6 +1584,72 @@
 <!--991EB88C248A48A58043C65806DE9708-->  <VALIDATEONNEW><![CDATA[Y]]></VALIDATEONNEW>
 <!--991EB88C248A48A58043C65806DE9708--></AD_COLUMN>
 
+<!--9A49A966B16D6348E040007F01007184--><AD_COLUMN>
+<!--9A49A966B16D6348E040007F01007184-->  <AD_COLUMN_ID><![CDATA[9A49A966B16D6348E040007F01007184]]></AD_COLUMN_ID>
+<!--9A49A966B16D6348E040007F01007184-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--9A49A966B16D6348E040007F01007184-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--9A49A966B16D6348E040007F01007184-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--9A49A966B16D6348E040007F01007184-->  <NAME><![CDATA[HQL]]></NAME>
+<!--9A49A966B16D6348E040007F01007184-->  <HELP><![CDATA[HQL Query code to populate selector's grid.
+
+Retrieved columns must have an alias defined, this alias is used to identify the returned value with a selector field. It is mandatory to set the "@additional_filters@" String on the main where clause. It is forbidden to include an Order by clause in the HQL, the order is defined on the Selector fields.]]></HELP>
+<!--9A49A966B16D6348E040007F01007184-->  <COLUMNNAME><![CDATA[HQL]]></COLUMNNAME>
+<!--9A49A966B16D6348E040007F01007184-->  <AD_TABLE_ID><![CDATA[7E50FCF61A884C9D966D1348705EC17C]]></AD_TABLE_ID>
+<!--9A49A966B16D6348E040007F01007184-->  <AD_REFERENCE_ID><![CDATA[14]]></AD_REFERENCE_ID>
+<!--9A49A966B16D6348E040007F01007184-->  <FIELDLENGTH><![CDATA[4000]]></FIELDLENGTH>
+<!--9A49A966B16D6348E040007F01007184-->  <ISKEY><![CDATA[N]]></ISKEY>
+<!--9A49A966B16D6348E040007F01007184-->  <ISPARENT><![CDATA[N]]></ISPARENT>
+<!--9A49A966B16D6348E040007F01007184-->  <ISMANDATORY><![CDATA[N]]></ISMANDATORY>
+<!--9A49A966B16D6348E040007F01007184-->  <ISUPDATEABLE><![CDATA[Y]]></ISUPDATEABLE>
+<!--9A49A966B16D6348E040007F01007184-->  <ISIDENTIFIER><![CDATA[N]]></ISIDENTIFIER>
+<!--9A49A966B16D6348E040007F01007184-->  <SEQNO><![CDATA[240]]></SEQNO>
+<!--9A49A966B16D6348E040007F01007184-->  <ISTRANSLATED><![CDATA[N]]></ISTRANSLATED>
+<!--9A49A966B16D6348E040007F01007184-->  <ISENCRYPTED><![CDATA[N]]></ISENCRYPTED>
+<!--9A49A966B16D6348E040007F01007184-->  <ISSELECTIONCOLUMN><![CDATA[N]]></ISSELECTIONCOLUMN>
+<!--9A49A966B16D6348E040007F01007184-->  <AD_ELEMENT_ID><![CDATA[9A4B096709FEB876E040007F01007259]]></AD_ELEMENT_ID>
+<!--9A49A966B16D6348E040007F01007184-->  <ISSESSIONATTR><![CDATA[N]]></ISSESSIONATTR>
+<!--9A49A966B16D6348E040007F01007184-->  <ISSECONDARYKEY><![CDATA[N]]></ISSECONDARYKEY>
+<!--9A49A966B16D6348E040007F01007184-->  <ISDESENCRYPTABLE><![CDATA[N]]></ISDESENCRYPTABLE>
+<!--9A49A966B16D6348E040007F01007184-->  <DEVELOPMENTSTATUS><![CDATA[RE]]></DEVELOPMENTSTATUS>
+<!--9A49A966B16D6348E040007F01007184-->  <AD_MODULE_ID><![CDATA[5EB4F15C80684ACA904756BDC12ADBE5]]></AD_MODULE_ID>
+<!--9A49A966B16D6348E040007F01007184-->  <POSITION><![CDATA[24]]></POSITION>
+<!--9A49A966B16D6348E040007F01007184-->  <ISTRANSIENT><![CDATA[N]]></ISTRANSIENT>
+<!--9A49A966B16D6348E040007F01007184-->  <ISAUTOSAVE><![CDATA[Y]]></ISAUTOSAVE>
+<!--9A49A966B16D6348E040007F01007184-->  <VALIDATEONNEW><![CDATA[Y]]></VALIDATEONNEW>
+<!--9A49A966B16D6348E040007F01007184--></AD_COLUMN>
+
+<!--9A4B111315EDCE2CE040007F01007260--><AD_COLUMN>
+<!--9A4B111315EDCE2CE040007F01007260-->  <AD_COLUMN_ID><![CDATA[9A4B111315EDCE2CE040007F01007260]]></AD_COLUMN_ID>
+<!--9A4B111315EDCE2CE040007F01007260-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--9A4B111315EDCE2CE040007F01007260-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--9A4B111315EDCE2CE040007F01007260-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--9A4B111315EDCE2CE040007F01007260-->  <NAME><![CDATA[Entity Alias]]></NAME>
+<!--9A4B111315EDCE2CE040007F01007260-->  <HELP><![CDATA[In case that the the selector's table has an alias in the HQL it is mandatory to set it on this field. This alias is used to add some mandatory filters on the Where clause replacing the @additional_filters@ string. Some examples of added filters are: client, organization and active flag.]]></HELP>
+<!--9A4B111315EDCE2CE040007F01007260-->  <COLUMNNAME><![CDATA[Entity_Alias]]></COLUMNNAME>
+<!--9A4B111315EDCE2CE040007F01007260-->  <AD_TABLE_ID><![CDATA[7E50FCF61A884C9D966D1348705EC17C]]></AD_TABLE_ID>
+<!--9A4B111315EDCE2CE040007F01007260-->  <AD_REFERENCE_ID><![CDATA[10]]></AD_REFERENCE_ID>
+<!--9A4B111315EDCE2CE040007F01007260-->  <FIELDLENGTH><![CDATA[60]]></FIELDLENGTH>
+<!--9A4B111315EDCE2CE040007F01007260-->  <ISKEY><![CDATA[N]]></ISKEY>
+<!--9A4B111315EDCE2CE040007F01007260-->  <ISPARENT><![CDATA[N]]></ISPARENT>
+<!--9A4B111315EDCE2CE040007F01007260-->  <ISMANDATORY><![CDATA[N]]></ISMANDATORY>
+<!--9A4B111315EDCE2CE040007F01007260-->  <ISUPDATEABLE><![CDATA[Y]]></ISUPDATEABLE>
+<!--9A4B111315EDCE2CE040007F01007260-->  <ISIDENTIFIER><![CDATA[N]]></ISIDENTIFIER>
+<!--9A4B111315EDCE2CE040007F01007260-->  <SEQNO><![CDATA[250]]></SEQNO>
+<!--9A4B111315EDCE2CE040007F01007260-->  <ISTRANSLATED><![CDATA[N]]></ISTRANSLATED>
+<!--9A4B111315EDCE2CE040007F01007260-->  <ISENCRYPTED><![CDATA[N]]></ISENCRYPTED>
+<!--9A4B111315EDCE2CE040007F01007260-->  <ISSELECTIONCOLUMN><![CDATA[N]]></ISSELECTIONCOLUMN>
+<!--9A4B111315EDCE2CE040007F01007260-->  <AD_ELEMENT_ID><![CDATA[9A4B09670A04B876E040007F01007259]]></AD_ELEMENT_ID>
+<!--9A4B111315EDCE2CE040007F01007260-->  <ISSESSIONATTR><![CDATA[N]]></ISSESSIONATTR>
+<!--9A4B111315EDCE2CE040007F01007260-->  <ISSECONDARYKEY><![CDATA[N]]></ISSECONDARYKEY>
+<!--9A4B111315EDCE2CE040007F01007260-->  <ISDESENCRYPTABLE><![CDATA[N]]></ISDESENCRYPTABLE>
+<!--9A4B111315EDCE2CE040007F01007260-->  <DEVELOPMENTSTATUS><![CDATA[RE]]></DEVELOPMENTSTATUS>
+<!--9A4B111315EDCE2CE040007F01007260-->  <AD_MODULE_ID><![CDATA[5EB4F15C80684ACA904756BDC12ADBE5]]></AD_MODULE_ID>
+<!--9A4B111315EDCE2CE040007F01007260-->  <POSITION><![CDATA[25]]></POSITION>
+<!--9A4B111315EDCE2CE040007F01007260-->  <ISTRANSIENT><![CDATA[N]]></ISTRANSIENT>
+<!--9A4B111315EDCE2CE040007F01007260-->  <ISAUTOSAVE><![CDATA[Y]]></ISAUTOSAVE>
+<!--9A4B111315EDCE2CE040007F01007260-->  <VALIDATEONNEW><![CDATA[Y]]></VALIDATEONNEW>
+<!--9A4B111315EDCE2CE040007F01007260--></AD_COLUMN>
+
 <!--9CFAD359FF0D433894E34EA05F6207FE--><AD_COLUMN>
 <!--9CFAD359FF0D433894E34EA05F6207FE-->  <AD_COLUMN_ID><![CDATA[9CFAD359FF0D433894E34EA05F6207FE]]></AD_COLUMN_ID>
 <!--9CFAD359FF0D433894E34EA05F6207FE-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
--- a/modules/org.openbravo.userinterface.selector/src-db/database/sourcedata/AD_ELEMENT.xml	Thu Jan 20 18:10:06 2011 +0100
+++ b/modules/org.openbravo.userinterface.selector/src-db/database/sourcedata/AD_ELEMENT.xml	Thu Jan 20 18:23:46 2011 +0100
@@ -124,6 +124,32 @@
 <!--7E3AF59AB6BB471DA2D0835926F92C07-->  <AD_MODULE_ID><![CDATA[5EB4F15C80684ACA904756BDC12ADBE5]]></AD_MODULE_ID>
 <!--7E3AF59AB6BB471DA2D0835926F92C07--></AD_ELEMENT>
 
+<!--9A4B096709FEB876E040007F01007259--><AD_ELEMENT>
+<!--9A4B096709FEB876E040007F01007259-->  <AD_ELEMENT_ID><![CDATA[9A4B096709FEB876E040007F01007259]]></AD_ELEMENT_ID>
+<!--9A4B096709FEB876E040007F01007259-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--9A4B096709FEB876E040007F01007259-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--9A4B096709FEB876E040007F01007259-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--9A4B096709FEB876E040007F01007259-->  <COLUMNNAME><![CDATA[HQL]]></COLUMNNAME>
+<!--9A4B096709FEB876E040007F01007259-->  <NAME><![CDATA[HQL]]></NAME>
+<!--9A4B096709FEB876E040007F01007259-->  <PRINTNAME><![CDATA[HQL]]></PRINTNAME>
+<!--9A4B096709FEB876E040007F01007259-->  <HELP><![CDATA[HQL Query code to populate selector's grid.
+
+Retrieved columns must have an alias defined, this alias is used to identify the returned value with a selector field. It is mandatory to set the "@additional_filters@" String on the main where clause. It is forbidden to include an Order by clause in the HQL, the order is defined on the Selector fields.]]></HELP>
+<!--9A4B096709FEB876E040007F01007259-->  <AD_MODULE_ID><![CDATA[5EB4F15C80684ACA904756BDC12ADBE5]]></AD_MODULE_ID>
+<!--9A4B096709FEB876E040007F01007259--></AD_ELEMENT>
+
+<!--9A4B09670A04B876E040007F01007259--><AD_ELEMENT>
+<!--9A4B09670A04B876E040007F01007259-->  <AD_ELEMENT_ID><![CDATA[9A4B09670A04B876E040007F01007259]]></AD_ELEMENT_ID>
+<!--9A4B09670A04B876E040007F01007259-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--9A4B09670A04B876E040007F01007259-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--9A4B09670A04B876E040007F01007259-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--9A4B09670A04B876E040007F01007259-->  <COLUMNNAME><![CDATA[Entity_Alias]]></COLUMNNAME>
+<!--9A4B09670A04B876E040007F01007259-->  <NAME><![CDATA[Entity Alias]]></NAME>
+<!--9A4B09670A04B876E040007F01007259-->  <PRINTNAME><![CDATA[Entity Alias]]></PRINTNAME>
+<!--9A4B09670A04B876E040007F01007259-->  <HELP><![CDATA[In case that the the selector's table has an alias in the HQL it is mandatory to set it on this field. This alias is used to add some mandatory filters on the Where clause replacing the @additional_filters@ string. Some examples of added filters are: client, organization and active flag.]]></HELP>
+<!--9A4B09670A04B876E040007F01007259-->  <AD_MODULE_ID><![CDATA[5EB4F15C80684ACA904756BDC12ADBE5]]></AD_MODULE_ID>
+<!--9A4B09670A04B876E040007F01007259--></AD_ELEMENT>
+
 <!--B843BE7E4A984128AA589685C313E709--><AD_ELEMENT>
 <!--B843BE7E4A984128AA589685C313E709-->  <AD_ELEMENT_ID><![CDATA[B843BE7E4A984128AA589685C313E709]]></AD_ELEMENT_ID>
 <!--B843BE7E4A984128AA589685C313E709-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
--- a/modules/org.openbravo.userinterface.selector/src-db/database/sourcedata/AD_FIELD.xml	Thu Jan 20 18:10:06 2011 +0100
+++ b/modules/org.openbravo.userinterface.selector/src-db/database/sourcedata/AD_FIELD.xml	Thu Jan 20 18:23:46 2011 +0100
@@ -495,7 +495,7 @@
 <!--4FFDB2B9948846699618FE27EF12D285-->  <DISPLAYLOGIC><![CDATA[@ad_table_id@!'']]></DISPLAYLOGIC>
 <!--4FFDB2B9948846699618FE27EF12D285-->  <DISPLAYLENGTH><![CDATA[32]]></DISPLAYLENGTH>
 <!--4FFDB2B9948846699618FE27EF12D285-->  <ISREADONLY><![CDATA[N]]></ISREADONLY>
-<!--4FFDB2B9948846699618FE27EF12D285-->  <SEQNO><![CDATA[100]]></SEQNO>
+<!--4FFDB2B9948846699618FE27EF12D285-->  <SEQNO><![CDATA[98]]></SEQNO>
 <!--4FFDB2B9948846699618FE27EF12D285-->  <ISSAMELINE><![CDATA[N]]></ISSAMELINE>
 <!--4FFDB2B9948846699618FE27EF12D285-->  <ISFIELDONLY><![CDATA[N]]></ISFIELDONLY>
 <!--4FFDB2B9948846699618FE27EF12D285-->  <ISENCRYPTED><![CDATA[N]]></ISENCRYPTED>
@@ -573,7 +573,7 @@
 <!--56F1199D9D4C41FFA5D3479A8901997F-->  <ISDISPLAYED><![CDATA[Y]]></ISDISPLAYED>
 <!--56F1199D9D4C41FFA5D3479A8901997F-->  <DISPLAYLENGTH><![CDATA[1]]></DISPLAYLENGTH>
 <!--56F1199D9D4C41FFA5D3479A8901997F-->  <ISREADONLY><![CDATA[N]]></ISREADONLY>
-<!--56F1199D9D4C41FFA5D3479A8901997F-->  <SEQNO><![CDATA[180]]></SEQNO>
+<!--56F1199D9D4C41FFA5D3479A8901997F-->  <SEQNO><![CDATA[75]]></SEQNO>
 <!--56F1199D9D4C41FFA5D3479A8901997F-->  <ISSAMELINE><![CDATA[N]]></ISSAMELINE>
 <!--56F1199D9D4C41FFA5D3479A8901997F-->  <ISFIELDONLY><![CDATA[N]]></ISFIELDONLY>
 <!--56F1199D9D4C41FFA5D3479A8901997F-->  <ISENCRYPTED><![CDATA[N]]></ISENCRYPTED>
@@ -626,7 +626,7 @@
 <!--612164CB9C26427BBDF9258EF159C5C9-->  <DISPLAYLOGIC><![CDATA[@Obserds_Datasource_ID@='']]></DISPLAYLOGIC>
 <!--612164CB9C26427BBDF9258EF159C5C9-->  <DISPLAYLENGTH><![CDATA[32]]></DISPLAYLENGTH>
 <!--612164CB9C26427BBDF9258EF159C5C9-->  <ISREADONLY><![CDATA[N]]></ISREADONLY>
-<!--612164CB9C26427BBDF9258EF159C5C9-->  <SEQNO><![CDATA[90]]></SEQNO>
+<!--612164CB9C26427BBDF9258EF159C5C9-->  <SEQNO><![CDATA[86]]></SEQNO>
 <!--612164CB9C26427BBDF9258EF159C5C9-->  <ISSAMELINE><![CDATA[N]]></ISSAMELINE>
 <!--612164CB9C26427BBDF9258EF159C5C9-->  <ISFIELDONLY><![CDATA[N]]></ISFIELDONLY>
 <!--612164CB9C26427BBDF9258EF159C5C9-->  <ISENCRYPTED><![CDATA[N]]></ISENCRYPTED>
@@ -934,6 +934,56 @@
 <!--96F9E917C88E4003BBC22CBDA354090C-->  <STARTNEWLINE><![CDATA[N]]></STARTNEWLINE>
 <!--96F9E917C88E4003BBC22CBDA354090C--></AD_FIELD>
 
+<!--9A4B111315EECE2CE040007F01007260--><AD_FIELD>
+<!--9A4B111315EECE2CE040007F01007260-->  <AD_FIELD_ID><![CDATA[9A4B111315EECE2CE040007F01007260]]></AD_FIELD_ID>
+<!--9A4B111315EECE2CE040007F01007260-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--9A4B111315EECE2CE040007F01007260-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--9A4B111315EECE2CE040007F01007260-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--9A4B111315EECE2CE040007F01007260-->  <NAME><![CDATA[HQL]]></NAME>
+<!--9A4B111315EECE2CE040007F01007260-->  <HELP><![CDATA[HQL Query code to populate selector's grid.
+
+Retrieved columns must have an alias defined, this alias is used to identify the returned value with a selector field. It is mandatory to set the "@additional_filters@" String on the main where clause. It is forbidden to include an Order by clause in the HQL, the order is defined on the Selector fields.]]></HELP>
+<!--9A4B111315EECE2CE040007F01007260-->  <ISCENTRALLYMAINTAINED><![CDATA[Y]]></ISCENTRALLYMAINTAINED>
+<!--9A4B111315EECE2CE040007F01007260-->  <AD_TAB_ID><![CDATA[10153E4B83EC4A5E8C558FCE74071FB0]]></AD_TAB_ID>
+<!--9A4B111315EECE2CE040007F01007260-->  <AD_COLUMN_ID><![CDATA[9A49A966B16D6348E040007F01007184]]></AD_COLUMN_ID>
+<!--9A4B111315EECE2CE040007F01007260-->  <ISDISPLAYED><![CDATA[Y]]></ISDISPLAYED>
+<!--9A4B111315EECE2CE040007F01007260-->  <DISPLAYLENGTH><![CDATA[4000]]></DISPLAYLENGTH>
+<!--9A4B111315EECE2CE040007F01007260-->  <ISREADONLY><![CDATA[N]]></ISREADONLY>
+<!--9A4B111315EECE2CE040007F01007260-->  <SEQNO><![CDATA[104]]></SEQNO>
+<!--9A4B111315EECE2CE040007F01007260-->  <ISSAMELINE><![CDATA[N]]></ISSAMELINE>
+<!--9A4B111315EECE2CE040007F01007260-->  <ISFIELDONLY><![CDATA[N]]></ISFIELDONLY>
+<!--9A4B111315EECE2CE040007F01007260-->  <ISENCRYPTED><![CDATA[N]]></ISENCRYPTED>
+<!--9A4B111315EECE2CE040007F01007260-->  <SHOWINRELATION><![CDATA[Y]]></SHOWINRELATION>
+<!--9A4B111315EECE2CE040007F01007260-->  <ISFIRSTFOCUSEDFIELD><![CDATA[N]]></ISFIRSTFOCUSEDFIELD>
+<!--9A4B111315EECE2CE040007F01007260-->  <AD_MODULE_ID><![CDATA[5EB4F15C80684ACA904756BDC12ADBE5]]></AD_MODULE_ID>
+<!--9A4B111315EECE2CE040007F01007260-->  <STARTINODDCOLUMN><![CDATA[N]]></STARTINODDCOLUMN>
+<!--9A4B111315EECE2CE040007F01007260-->  <STARTNEWLINE><![CDATA[N]]></STARTNEWLINE>
+<!--9A4B111315EECE2CE040007F01007260--></AD_FIELD>
+
+<!--9A4B111315EFCE2CE040007F01007260--><AD_FIELD>
+<!--9A4B111315EFCE2CE040007F01007260-->  <AD_FIELD_ID><![CDATA[9A4B111315EFCE2CE040007F01007260]]></AD_FIELD_ID>
+<!--9A4B111315EFCE2CE040007F01007260-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--9A4B111315EFCE2CE040007F01007260-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--9A4B111315EFCE2CE040007F01007260-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--9A4B111315EFCE2CE040007F01007260-->  <NAME><![CDATA[Entity Alias]]></NAME>
+<!--9A4B111315EFCE2CE040007F01007260-->  <HELP><![CDATA[In case that the the selector's table has an alias in the HQL it is mandatory to set it on this field. This alias is used to add some mandatory filters on the Where clause replacing the @additional_filters@ string. Some examples of added filters are: client, organization and active flag.]]></HELP>
+<!--9A4B111315EFCE2CE040007F01007260-->  <ISCENTRALLYMAINTAINED><![CDATA[Y]]></ISCENTRALLYMAINTAINED>
+<!--9A4B111315EFCE2CE040007F01007260-->  <AD_TAB_ID><![CDATA[10153E4B83EC4A5E8C558FCE74071FB0]]></AD_TAB_ID>
+<!--9A4B111315EFCE2CE040007F01007260-->  <AD_COLUMN_ID><![CDATA[9A4B111315EDCE2CE040007F01007260]]></AD_COLUMN_ID>
+<!--9A4B111315EFCE2CE040007F01007260-->  <ISDISPLAYED><![CDATA[Y]]></ISDISPLAYED>
+<!--9A4B111315EFCE2CE040007F01007260-->  <DISPLAYLENGTH><![CDATA[60]]></DISPLAYLENGTH>
+<!--9A4B111315EFCE2CE040007F01007260-->  <ISREADONLY><![CDATA[N]]></ISREADONLY>
+<!--9A4B111315EFCE2CE040007F01007260-->  <SEQNO><![CDATA[92]]></SEQNO>
+<!--9A4B111315EFCE2CE040007F01007260-->  <ISSAMELINE><![CDATA[Y]]></ISSAMELINE>
+<!--9A4B111315EFCE2CE040007F01007260-->  <ISFIELDONLY><![CDATA[N]]></ISFIELDONLY>
+<!--9A4B111315EFCE2CE040007F01007260-->  <ISENCRYPTED><![CDATA[N]]></ISENCRYPTED>
+<!--9A4B111315EFCE2CE040007F01007260-->  <SHOWINRELATION><![CDATA[Y]]></SHOWINRELATION>
+<!--9A4B111315EFCE2CE040007F01007260-->  <ISFIRSTFOCUSEDFIELD><![CDATA[N]]></ISFIRSTFOCUSEDFIELD>
+<!--9A4B111315EFCE2CE040007F01007260-->  <AD_MODULE_ID><![CDATA[5EB4F15C80684ACA904756BDC12ADBE5]]></AD_MODULE_ID>
+<!--9A4B111315EFCE2CE040007F01007260-->  <STARTINODDCOLUMN><![CDATA[N]]></STARTINODDCOLUMN>
+<!--9A4B111315EFCE2CE040007F01007260-->  <STARTNEWLINE><![CDATA[N]]></STARTNEWLINE>
+<!--9A4B111315EFCE2CE040007F01007260--></AD_FIELD>
+
 <!--9A5295F6BA6D4E6ABCB3039D5ABDADE3--><AD_FIELD>
 <!--9A5295F6BA6D4E6ABCB3039D5ABDADE3-->  <AD_FIELD_ID><![CDATA[9A5295F6BA6D4E6ABCB3039D5ABDADE3]]></AD_FIELD_ID>
 <!--9A5295F6BA6D4E6ABCB3039D5ABDADE3-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
@@ -1101,7 +1151,7 @@
 <!--B0D5C8AE6ECB45A7802FCC771F283241-->  <ISDISPLAYED><![CDATA[Y]]></ISDISPLAYED>
 <!--B0D5C8AE6ECB45A7802FCC771F283241-->  <DISPLAYLENGTH><![CDATA[32]]></DISPLAYLENGTH>
 <!--B0D5C8AE6ECB45A7802FCC771F283241-->  <ISREADONLY><![CDATA[Y]]></ISREADONLY>
-<!--B0D5C8AE6ECB45A7802FCC771F283241-->  <SEQNO><![CDATA[40]]></SEQNO>
+<!--B0D5C8AE6ECB45A7802FCC771F283241-->  <SEQNO><![CDATA[25]]></SEQNO>
 <!--B0D5C8AE6ECB45A7802FCC771F283241-->  <ISSAMELINE><![CDATA[N]]></ISSAMELINE>
 <!--B0D5C8AE6ECB45A7802FCC771F283241-->  <ISFIELDONLY><![CDATA[N]]></ISFIELDONLY>
 <!--B0D5C8AE6ECB45A7802FCC771F283241-->  <ISENCRYPTED><![CDATA[N]]></ISENCRYPTED>