details: /erp/devel/pi/rev/2a0022c73fbf
changeset: 8590:2a0022c73fbf
user: Martin Taal <martin.taal <at> openbravo.com>
date: Sun Oct 24 22:02:51 2010 +0200
summary: Added HQL whereclause/orderbyclause/filterclause to tab and reftables
diffstat:
src-db/database/model/tables/AD_REF_TABLE.xml | 8 +
src-db/database/model/tables/AD_TAB.xml | 12 ++
src-db/database/sourcedata/AD_COLUMN.xml | 155 ++++++++++++++++++++++++++
src-db/database/sourcedata/AD_ELEMENT.xml | 33 +++++
src-db/database/sourcedata/AD_FIELD.xml | 140 ++++++++++++++++++++---
5 files changed, 330 insertions(+), 18 deletions(-)
diffs (truncated from 594 to 300 lines):
diff -r 44841807a54d -r 2a0022c73fbf
src-db/database/model/tables/AD_REF_TABLE.xml
--- a/src-db/database/model/tables/AD_REF_TABLE.xml Fri Oct 22 18:15:12
2010 +0200
+++ b/src-db/database/model/tables/AD_REF_TABLE.xml Sun Oct 24 22:02:51
2010 +0200
@@ -57,6 +57,14 @@
<default/>
<onCreateDefault/>
</column>
+ <column name="HQLWHERECLAUSE" primaryKey="false" required="false"
type="VARCHAR" size="2000" autoIncrement="false">
+ <default/>
+ <onCreateDefault/>
+ </column>
+ <column name="HQLORDERBYCLAUSE" primaryKey="false" required="false"
type="VARCHAR" size="2000" autoIncrement="false">
+ <default/>
+ <onCreateDefault/>
+ </column>
<foreign-key foreignTable="AD_COLUMN" name="AD_COLUMN_REFTABLE_DISPLAY">
<reference local="AD_DISPLAY" foreign="AD_COLUMN_ID"/>
</foreign-key>
diff -r 44841807a54d -r 2a0022c73fbf src-db/database/model/tables/AD_TAB.xml
--- a/src-db/database/model/tables/AD_TAB.xml Fri Oct 22 18:15:12 2010 +0200
+++ b/src-db/database/model/tables/AD_TAB.xml Sun Oct 24 22:02:51 2010 +0200
@@ -145,6 +145,18 @@
<default><![CDATA[STD]]></default>
<onCreateDefault><![CDATA[CASE WHEN ISREADONLY='Y' THEN 'RO' ELSE
'STD' END]]></onCreateDefault>
</column>
+ <column name="HQLWHERECLAUSE" primaryKey="false" required="false"
type="VARCHAR" size="2000" autoIncrement="false">
+ <default/>
+ <onCreateDefault/>
+ </column>
+ <column name="HQLORDERBYCLAUSE" primaryKey="false" required="false"
type="VARCHAR" size="2000" autoIncrement="false">
+ <default/>
+ <onCreateDefault/>
+ </column>
+ <column name="HQLFILTERCLAUSE" primaryKey="false" required="false"
type="VARCHAR" size="2000" autoIncrement="false">
+ <default/>
+ <onCreateDefault/>
+ </column>
<foreign-key foreignTable="AD_COLUMN" name="AD_COLUMN_AD_TAB">
<reference local="AD_COLUMN_ID" foreign="AD_COLUMN_ID"/>
</foreign-key>
diff -r 44841807a54d -r 2a0022c73fbf src-db/database/sourcedata/AD_COLUMN.xml
--- a/src-db/database/sourcedata/AD_COLUMN.xml Fri Oct 22 18:15:12 2010 +0200
+++ b/src-db/database/sourcedata/AD_COLUMN.xml Sun Oct 24 22:02:51 2010 +0200
@@ -266846,6 +266846,37 @@
<!--46923D90F2BE11DD899E001D09C4A2FE-->
<VALIDATEONNEW><![CDATA[Y]]></VALIDATEONNEW>
<!--46923D90F2BE11DD899E001D09C4A2FE--></AD_COLUMN>
+<!--469587568C9D46DA9DB12E6B59AD6BDF--><AD_COLUMN>
+<!--469587568C9D46DA9DB12E6B59AD6BDF-->
<AD_COLUMN_ID><![CDATA[469587568C9D46DA9DB12E6B59AD6BDF]]></AD_COLUMN_ID>
+<!--469587568C9D46DA9DB12E6B59AD6BDF-->
<AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--469587568C9D46DA9DB12E6B59AD6BDF--> <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--469587568C9D46DA9DB12E6B59AD6BDF--> <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--469587568C9D46DA9DB12E6B59AD6BDF-->
<NAME><![CDATA[Hqlwhereclause]]></NAME>
+<!--469587568C9D46DA9DB12E6B59AD6BDF-->
<COLUMNNAME><![CDATA[Hqlwhereclause]]></COLUMNNAME>
+<!--469587568C9D46DA9DB12E6B59AD6BDF-->
<AD_TABLE_ID><![CDATA[103]]></AD_TABLE_ID>
+<!--469587568C9D46DA9DB12E6B59AD6BDF-->
<AD_REFERENCE_ID><![CDATA[10]]></AD_REFERENCE_ID>
+<!--469587568C9D46DA9DB12E6B59AD6BDF-->
<FIELDLENGTH><![CDATA[2000]]></FIELDLENGTH>
+<!--469587568C9D46DA9DB12E6B59AD6BDF--> <ISKEY><![CDATA[N]]></ISKEY>
+<!--469587568C9D46DA9DB12E6B59AD6BDF--> <ISPARENT><![CDATA[N]]></ISPARENT>
+<!--469587568C9D46DA9DB12E6B59AD6BDF-->
<ISMANDATORY><![CDATA[N]]></ISMANDATORY>
+<!--469587568C9D46DA9DB12E6B59AD6BDF-->
<ISUPDATEABLE><![CDATA[Y]]></ISUPDATEABLE>
+<!--469587568C9D46DA9DB12E6B59AD6BDF-->
<ISIDENTIFIER><![CDATA[N]]></ISIDENTIFIER>
+<!--469587568C9D46DA9DB12E6B59AD6BDF--> <SEQNO><![CDATA[11]]></SEQNO>
+<!--469587568C9D46DA9DB12E6B59AD6BDF-->
<ISTRANSLATED><![CDATA[N]]></ISTRANSLATED>
+<!--469587568C9D46DA9DB12E6B59AD6BDF-->
<ISENCRYPTED><![CDATA[N]]></ISENCRYPTED>
+<!--469587568C9D46DA9DB12E6B59AD6BDF-->
<ISSELECTIONCOLUMN><![CDATA[N]]></ISSELECTIONCOLUMN>
+<!--469587568C9D46DA9DB12E6B59AD6BDF-->
<AD_ELEMENT_ID><![CDATA[ECAC136184A746C39804BD71BC3C78DB]]></AD_ELEMENT_ID>
+<!--469587568C9D46DA9DB12E6B59AD6BDF-->
<ISSESSIONATTR><![CDATA[N]]></ISSESSIONATTR>
+<!--469587568C9D46DA9DB12E6B59AD6BDF-->
<ISSECONDARYKEY><![CDATA[N]]></ISSECONDARYKEY>
+<!--469587568C9D46DA9DB12E6B59AD6BDF-->
<ISDESENCRYPTABLE><![CDATA[N]]></ISDESENCRYPTABLE>
+<!--469587568C9D46DA9DB12E6B59AD6BDF-->
<DEVELOPMENTSTATUS><![CDATA[RE]]></DEVELOPMENTSTATUS>
+<!--469587568C9D46DA9DB12E6B59AD6BDF-->
<AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
+<!--469587568C9D46DA9DB12E6B59AD6BDF--> <POSITION><![CDATA[15]]></POSITION>
+<!--469587568C9D46DA9DB12E6B59AD6BDF-->
<ISTRANSIENT><![CDATA[N]]></ISTRANSIENT>
+<!--469587568C9D46DA9DB12E6B59AD6BDF--> <ISAUTOSAVE><![CDATA[Y]]></ISAUTOSAVE>
+<!--469587568C9D46DA9DB12E6B59AD6BDF-->
<VALIDATEONNEW><![CDATA[Y]]></VALIDATEONNEW>
+<!--469587568C9D46DA9DB12E6B59AD6BDF--></AD_COLUMN>
+
<!--46982462F2BE11DDA3E5001D09C4A2FE--><AD_COLUMN>
<!--46982462F2BE11DDA3E5001D09C4A2FE-->
<AD_COLUMN_ID><![CDATA[46982462F2BE11DDA3E5001D09C4A2FE]]></AD_COLUMN_ID>
<!--46982462F2BE11DDA3E5001D09C4A2FE-->
<AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
@@ -279867,6 +279898,37 @@
<!--5BE6AE18C0031D56E040007F010148F2-->
<VALIDATEONNEW><![CDATA[Y]]></VALIDATEONNEW>
<!--5BE6AE18C0031D56E040007F010148F2--></AD_COLUMN>
+<!--5C264276D5C94E7B8F05444D78FD0BA0--><AD_COLUMN>
+<!--5C264276D5C94E7B8F05444D78FD0BA0-->
<AD_COLUMN_ID><![CDATA[5C264276D5C94E7B8F05444D78FD0BA0]]></AD_COLUMN_ID>
+<!--5C264276D5C94E7B8F05444D78FD0BA0-->
<AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--5C264276D5C94E7B8F05444D78FD0BA0--> <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--5C264276D5C94E7B8F05444D78FD0BA0--> <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--5C264276D5C94E7B8F05444D78FD0BA0-->
<NAME><![CDATA[Hqlwhereclause]]></NAME>
+<!--5C264276D5C94E7B8F05444D78FD0BA0-->
<COLUMNNAME><![CDATA[Hqlwhereclause]]></COLUMNNAME>
+<!--5C264276D5C94E7B8F05444D78FD0BA0-->
<AD_TABLE_ID><![CDATA[106]]></AD_TABLE_ID>
+<!--5C264276D5C94E7B8F05444D78FD0BA0-->
<AD_REFERENCE_ID><![CDATA[10]]></AD_REFERENCE_ID>
+<!--5C264276D5C94E7B8F05444D78FD0BA0-->
<FIELDLENGTH><![CDATA[2000]]></FIELDLENGTH>
+<!--5C264276D5C94E7B8F05444D78FD0BA0--> <ISKEY><![CDATA[N]]></ISKEY>
+<!--5C264276D5C94E7B8F05444D78FD0BA0--> <ISPARENT><![CDATA[N]]></ISPARENT>
+<!--5C264276D5C94E7B8F05444D78FD0BA0-->
<ISMANDATORY><![CDATA[N]]></ISMANDATORY>
+<!--5C264276D5C94E7B8F05444D78FD0BA0-->
<ISUPDATEABLE><![CDATA[Y]]></ISUPDATEABLE>
+<!--5C264276D5C94E7B8F05444D78FD0BA0-->
<ISIDENTIFIER><![CDATA[N]]></ISIDENTIFIER>
+<!--5C264276D5C94E7B8F05444D78FD0BA0--> <SEQNO><![CDATA[52]]></SEQNO>
+<!--5C264276D5C94E7B8F05444D78FD0BA0-->
<ISTRANSLATED><![CDATA[N]]></ISTRANSLATED>
+<!--5C264276D5C94E7B8F05444D78FD0BA0-->
<ISENCRYPTED><![CDATA[N]]></ISENCRYPTED>
+<!--5C264276D5C94E7B8F05444D78FD0BA0-->
<ISSELECTIONCOLUMN><![CDATA[N]]></ISSELECTIONCOLUMN>
+<!--5C264276D5C94E7B8F05444D78FD0BA0-->
<AD_ELEMENT_ID><![CDATA[ECAC136184A746C39804BD71BC3C78DB]]></AD_ELEMENT_ID>
+<!--5C264276D5C94E7B8F05444D78FD0BA0-->
<ISSESSIONATTR><![CDATA[N]]></ISSESSIONATTR>
+<!--5C264276D5C94E7B8F05444D78FD0BA0-->
<ISSECONDARYKEY><![CDATA[N]]></ISSECONDARYKEY>
+<!--5C264276D5C94E7B8F05444D78FD0BA0-->
<ISDESENCRYPTABLE><![CDATA[N]]></ISDESENCRYPTABLE>
+<!--5C264276D5C94E7B8F05444D78FD0BA0-->
<DEVELOPMENTSTATUS><![CDATA[RE]]></DEVELOPMENTSTATUS>
+<!--5C264276D5C94E7B8F05444D78FD0BA0-->
<AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
+<!--5C264276D5C94E7B8F05444D78FD0BA0--> <POSITION><![CDATA[37]]></POSITION>
+<!--5C264276D5C94E7B8F05444D78FD0BA0-->
<ISTRANSIENT><![CDATA[N]]></ISTRANSIENT>
+<!--5C264276D5C94E7B8F05444D78FD0BA0--> <ISAUTOSAVE><![CDATA[Y]]></ISAUTOSAVE>
+<!--5C264276D5C94E7B8F05444D78FD0BA0-->
<VALIDATEONNEW><![CDATA[Y]]></VALIDATEONNEW>
+<!--5C264276D5C94E7B8F05444D78FD0BA0--></AD_COLUMN>
+
<!--5C2A95460C2B4FD5B6AB75C8F7021B41--><AD_COLUMN>
<!--5C2A95460C2B4FD5B6AB75C8F7021B41-->
<AD_COLUMN_ID><![CDATA[5C2A95460C2B4FD5B6AB75C8F7021B41]]></AD_COLUMN_ID>
<!--5C2A95460C2B4FD5B6AB75C8F7021B41-->
<AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
@@ -307514,6 +307576,37 @@
<!--A437240FB0894CFFAA0C96A925D69141-->
<VALIDATEONNEW><![CDATA[Y]]></VALIDATEONNEW>
<!--A437240FB0894CFFAA0C96A925D69141--></AD_COLUMN>
+<!--A6730B8F9A5F4EADA0976C1FF09CF66F--><AD_COLUMN>
+<!--A6730B8F9A5F4EADA0976C1FF09CF66F-->
<AD_COLUMN_ID><![CDATA[A6730B8F9A5F4EADA0976C1FF09CF66F]]></AD_COLUMN_ID>
+<!--A6730B8F9A5F4EADA0976C1FF09CF66F-->
<AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--A6730B8F9A5F4EADA0976C1FF09CF66F--> <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--A6730B8F9A5F4EADA0976C1FF09CF66F--> <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--A6730B8F9A5F4EADA0976C1FF09CF66F-->
<NAME><![CDATA[Hqlorderbyclause]]></NAME>
+<!--A6730B8F9A5F4EADA0976C1FF09CF66F-->
<COLUMNNAME><![CDATA[Hqlorderbyclause]]></COLUMNNAME>
+<!--A6730B8F9A5F4EADA0976C1FF09CF66F-->
<AD_TABLE_ID><![CDATA[106]]></AD_TABLE_ID>
+<!--A6730B8F9A5F4EADA0976C1FF09CF66F-->
<AD_REFERENCE_ID><![CDATA[10]]></AD_REFERENCE_ID>
+<!--A6730B8F9A5F4EADA0976C1FF09CF66F-->
<FIELDLENGTH><![CDATA[2000]]></FIELDLENGTH>
+<!--A6730B8F9A5F4EADA0976C1FF09CF66F--> <ISKEY><![CDATA[N]]></ISKEY>
+<!--A6730B8F9A5F4EADA0976C1FF09CF66F--> <ISPARENT><![CDATA[N]]></ISPARENT>
+<!--A6730B8F9A5F4EADA0976C1FF09CF66F-->
<ISMANDATORY><![CDATA[N]]></ISMANDATORY>
+<!--A6730B8F9A5F4EADA0976C1FF09CF66F-->
<ISUPDATEABLE><![CDATA[Y]]></ISUPDATEABLE>
+<!--A6730B8F9A5F4EADA0976C1FF09CF66F-->
<ISIDENTIFIER><![CDATA[N]]></ISIDENTIFIER>
+<!--A6730B8F9A5F4EADA0976C1FF09CF66F--> <SEQNO><![CDATA[62]]></SEQNO>
+<!--A6730B8F9A5F4EADA0976C1FF09CF66F-->
<ISTRANSLATED><![CDATA[N]]></ISTRANSLATED>
+<!--A6730B8F9A5F4EADA0976C1FF09CF66F-->
<ISENCRYPTED><![CDATA[N]]></ISENCRYPTED>
+<!--A6730B8F9A5F4EADA0976C1FF09CF66F-->
<ISSELECTIONCOLUMN><![CDATA[N]]></ISSELECTIONCOLUMN>
+<!--A6730B8F9A5F4EADA0976C1FF09CF66F-->
<AD_ELEMENT_ID><![CDATA[8348666AB4E04BDBAC130A4C921440CC]]></AD_ELEMENT_ID>
+<!--A6730B8F9A5F4EADA0976C1FF09CF66F-->
<ISSESSIONATTR><![CDATA[N]]></ISSESSIONATTR>
+<!--A6730B8F9A5F4EADA0976C1FF09CF66F-->
<ISSECONDARYKEY><![CDATA[N]]></ISSECONDARYKEY>
+<!--A6730B8F9A5F4EADA0976C1FF09CF66F-->
<ISDESENCRYPTABLE><![CDATA[N]]></ISDESENCRYPTABLE>
+<!--A6730B8F9A5F4EADA0976C1FF09CF66F-->
<DEVELOPMENTSTATUS><![CDATA[RE]]></DEVELOPMENTSTATUS>
+<!--A6730B8F9A5F4EADA0976C1FF09CF66F-->
<AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
+<!--A6730B8F9A5F4EADA0976C1FF09CF66F--> <POSITION><![CDATA[38]]></POSITION>
+<!--A6730B8F9A5F4EADA0976C1FF09CF66F-->
<ISTRANSIENT><![CDATA[N]]></ISTRANSIENT>
+<!--A6730B8F9A5F4EADA0976C1FF09CF66F--> <ISAUTOSAVE><![CDATA[Y]]></ISAUTOSAVE>
+<!--A6730B8F9A5F4EADA0976C1FF09CF66F-->
<VALIDATEONNEW><![CDATA[Y]]></VALIDATEONNEW>
+<!--A6730B8F9A5F4EADA0976C1FF09CF66F--></AD_COLUMN>
+
<!--A7354004EBD211DD897A0016D4EE9DB3--><AD_COLUMN>
<!--A7354004EBD211DD897A0016D4EE9DB3-->
<AD_COLUMN_ID><![CDATA[A7354004EBD211DD897A0016D4EE9DB3]]></AD_COLUMN_ID>
<!--A7354004EBD211DD897A0016D4EE9DB3-->
<AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
@@ -308703,6 +308796,37 @@
<!--C83C1EB5414D4A528EDB166768B22C84-->
<VALIDATEONNEW><![CDATA[Y]]></VALIDATEONNEW>
<!--C83C1EB5414D4A528EDB166768B22C84--></AD_COLUMN>
+<!--C8AE5CAA0579450D801E70F9BF497D46--><AD_COLUMN>
+<!--C8AE5CAA0579450D801E70F9BF497D46-->
<AD_COLUMN_ID><![CDATA[C8AE5CAA0579450D801E70F9BF497D46]]></AD_COLUMN_ID>
+<!--C8AE5CAA0579450D801E70F9BF497D46-->
<AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--C8AE5CAA0579450D801E70F9BF497D46--> <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--C8AE5CAA0579450D801E70F9BF497D46--> <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--C8AE5CAA0579450D801E70F9BF497D46-->
<NAME><![CDATA[Hqlorderbyclause]]></NAME>
+<!--C8AE5CAA0579450D801E70F9BF497D46-->
<COLUMNNAME><![CDATA[Hqlorderbyclause]]></COLUMNNAME>
+<!--C8AE5CAA0579450D801E70F9BF497D46-->
<AD_TABLE_ID><![CDATA[103]]></AD_TABLE_ID>
+<!--C8AE5CAA0579450D801E70F9BF497D46-->
<AD_REFERENCE_ID><![CDATA[10]]></AD_REFERENCE_ID>
+<!--C8AE5CAA0579450D801E70F9BF497D46-->
<FIELDLENGTH><![CDATA[2000]]></FIELDLENGTH>
+<!--C8AE5CAA0579450D801E70F9BF497D46--> <ISKEY><![CDATA[N]]></ISKEY>
+<!--C8AE5CAA0579450D801E70F9BF497D46--> <ISPARENT><![CDATA[N]]></ISPARENT>
+<!--C8AE5CAA0579450D801E70F9BF497D46-->
<ISMANDATORY><![CDATA[N]]></ISMANDATORY>
+<!--C8AE5CAA0579450D801E70F9BF497D46-->
<ISUPDATEABLE><![CDATA[Y]]></ISUPDATEABLE>
+<!--C8AE5CAA0579450D801E70F9BF497D46-->
<ISIDENTIFIER><![CDATA[N]]></ISIDENTIFIER>
+<!--C8AE5CAA0579450D801E70F9BF497D46--> <SEQNO><![CDATA[21]]></SEQNO>
+<!--C8AE5CAA0579450D801E70F9BF497D46-->
<ISTRANSLATED><![CDATA[N]]></ISTRANSLATED>
+<!--C8AE5CAA0579450D801E70F9BF497D46-->
<ISENCRYPTED><![CDATA[N]]></ISENCRYPTED>
+<!--C8AE5CAA0579450D801E70F9BF497D46-->
<ISSELECTIONCOLUMN><![CDATA[N]]></ISSELECTIONCOLUMN>
+<!--C8AE5CAA0579450D801E70F9BF497D46-->
<AD_ELEMENT_ID><![CDATA[8348666AB4E04BDBAC130A4C921440CC]]></AD_ELEMENT_ID>
+<!--C8AE5CAA0579450D801E70F9BF497D46-->
<ISSESSIONATTR><![CDATA[N]]></ISSESSIONATTR>
+<!--C8AE5CAA0579450D801E70F9BF497D46-->
<ISSECONDARYKEY><![CDATA[N]]></ISSECONDARYKEY>
+<!--C8AE5CAA0579450D801E70F9BF497D46-->
<ISDESENCRYPTABLE><![CDATA[N]]></ISDESENCRYPTABLE>
+<!--C8AE5CAA0579450D801E70F9BF497D46-->
<DEVELOPMENTSTATUS><![CDATA[RE]]></DEVELOPMENTSTATUS>
+<!--C8AE5CAA0579450D801E70F9BF497D46-->
<AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
+<!--C8AE5CAA0579450D801E70F9BF497D46--> <POSITION><![CDATA[16]]></POSITION>
+<!--C8AE5CAA0579450D801E70F9BF497D46-->
<ISTRANSIENT><![CDATA[N]]></ISTRANSIENT>
+<!--C8AE5CAA0579450D801E70F9BF497D46--> <ISAUTOSAVE><![CDATA[Y]]></ISAUTOSAVE>
+<!--C8AE5CAA0579450D801E70F9BF497D46-->
<VALIDATEONNEW><![CDATA[Y]]></VALIDATEONNEW>
+<!--C8AE5CAA0579450D801E70F9BF497D46--></AD_COLUMN>
+
<!--CA49F473D15C4B778B338AE9ECB5DEA7--><AD_COLUMN>
<!--CA49F473D15C4B778B338AE9ECB5DEA7-->
<AD_COLUMN_ID><![CDATA[CA49F473D15C4B778B338AE9ECB5DEA7]]></AD_COLUMN_ID>
<!--CA49F473D15C4B778B338AE9ECB5DEA7-->
<AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
@@ -308739,6 +308863,37 @@
<!--CA49F473D15C4B778B338AE9ECB5DEA7-->
<VALIDATEONNEW><![CDATA[Y]]></VALIDATEONNEW>
<!--CA49F473D15C4B778B338AE9ECB5DEA7--></AD_COLUMN>
+<!--CC3F4812548548AE9E1E8D0FCD8269DF--><AD_COLUMN>
+<!--CC3F4812548548AE9E1E8D0FCD8269DF-->
<AD_COLUMN_ID><![CDATA[CC3F4812548548AE9E1E8D0FCD8269DF]]></AD_COLUMN_ID>
+<!--CC3F4812548548AE9E1E8D0FCD8269DF-->
<AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--CC3F4812548548AE9E1E8D0FCD8269DF--> <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--CC3F4812548548AE9E1E8D0FCD8269DF--> <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--CC3F4812548548AE9E1E8D0FCD8269DF-->
<NAME><![CDATA[Hqlfilterclause]]></NAME>
+<!--CC3F4812548548AE9E1E8D0FCD8269DF-->
<COLUMNNAME><![CDATA[Hqlfilterclause]]></COLUMNNAME>
+<!--CC3F4812548548AE9E1E8D0FCD8269DF-->
<AD_TABLE_ID><![CDATA[106]]></AD_TABLE_ID>
+<!--CC3F4812548548AE9E1E8D0FCD8269DF-->
<AD_REFERENCE_ID><![CDATA[10]]></AD_REFERENCE_ID>
+<!--CC3F4812548548AE9E1E8D0FCD8269DF-->
<FIELDLENGTH><![CDATA[2000]]></FIELDLENGTH>
+<!--CC3F4812548548AE9E1E8D0FCD8269DF--> <ISKEY><![CDATA[N]]></ISKEY>
+<!--CC3F4812548548AE9E1E8D0FCD8269DF--> <ISPARENT><![CDATA[N]]></ISPARENT>
+<!--CC3F4812548548AE9E1E8D0FCD8269DF-->
<ISMANDATORY><![CDATA[N]]></ISMANDATORY>
+<!--CC3F4812548548AE9E1E8D0FCD8269DF-->
<ISUPDATEABLE><![CDATA[Y]]></ISUPDATEABLE>
+<!--CC3F4812548548AE9E1E8D0FCD8269DF-->
<ISIDENTIFIER><![CDATA[N]]></ISIDENTIFIER>
+<!--CC3F4812548548AE9E1E8D0FCD8269DF--> <SEQNO><![CDATA[72]]></SEQNO>
+<!--CC3F4812548548AE9E1E8D0FCD8269DF-->
<ISTRANSLATED><![CDATA[N]]></ISTRANSLATED>
+<!--CC3F4812548548AE9E1E8D0FCD8269DF-->
<ISENCRYPTED><![CDATA[N]]></ISENCRYPTED>
+<!--CC3F4812548548AE9E1E8D0FCD8269DF-->
<ISSELECTIONCOLUMN><![CDATA[N]]></ISSELECTIONCOLUMN>
+<!--CC3F4812548548AE9E1E8D0FCD8269DF-->
<AD_ELEMENT_ID><![CDATA[F3B77B38FDF84D7293862DF5A927783D]]></AD_ELEMENT_ID>
+<!--CC3F4812548548AE9E1E8D0FCD8269DF-->
<ISSESSIONATTR><![CDATA[N]]></ISSESSIONATTR>
+<!--CC3F4812548548AE9E1E8D0FCD8269DF-->
<ISSECONDARYKEY><![CDATA[N]]></ISSECONDARYKEY>
+<!--CC3F4812548548AE9E1E8D0FCD8269DF-->
<ISDESENCRYPTABLE><![CDATA[N]]></ISDESENCRYPTABLE>
+<!--CC3F4812548548AE9E1E8D0FCD8269DF-->
<DEVELOPMENTSTATUS><![CDATA[RE]]></DEVELOPMENTSTATUS>
+<!--CC3F4812548548AE9E1E8D0FCD8269DF-->
<AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
+<!--CC3F4812548548AE9E1E8D0FCD8269DF--> <POSITION><![CDATA[39]]></POSITION>
+<!--CC3F4812548548AE9E1E8D0FCD8269DF-->
<ISTRANSIENT><![CDATA[N]]></ISTRANSIENT>
+<!--CC3F4812548548AE9E1E8D0FCD8269DF--> <ISAUTOSAVE><![CDATA[Y]]></ISAUTOSAVE>
+<!--CC3F4812548548AE9E1E8D0FCD8269DF-->
<VALIDATEONNEW><![CDATA[Y]]></VALIDATEONNEW>
+<!--CC3F4812548548AE9E1E8D0FCD8269DF--></AD_COLUMN>
+
<!--CC754B47555D4F66974371B151632F41--><AD_COLUMN>
<!--CC754B47555D4F66974371B151632F41-->
<AD_COLUMN_ID><![CDATA[CC754B47555D4F66974371B151632F41]]></AD_COLUMN_ID>
<!--CC754B47555D4F66974371B151632F41-->
<AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
diff -r 44841807a54d -r 2a0022c73fbf src-db/database/sourcedata/AD_ELEMENT.xml
--- a/src-db/database/sourcedata/AD_ELEMENT.xml Fri Oct 22 18:15:12 2010 +0200
+++ b/src-db/database/sourcedata/AD_ELEMENT.xml Sun Oct 24 22:02:51 2010 +0200
@@ -26389,6 +26389,17 @@
<!--828EE0AE80575FA1E040007F010067C7-->
<AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
<!--828EE0AE80575FA1E040007F010067C7--></AD_ELEMENT>
+<!--8348666AB4E04BDBAC130A4C921440CC--><AD_ELEMENT>
+<!--8348666AB4E04BDBAC130A4C921440CC-->
<AD_ELEMENT_ID><![CDATA[8348666AB4E04BDBAC130A4C921440CC]]></AD_ELEMENT_ID>
+<!--8348666AB4E04BDBAC130A4C921440CC-->
<AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--8348666AB4E04BDBAC130A4C921440CC--> <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--8348666AB4E04BDBAC130A4C921440CC--> <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--8348666AB4E04BDBAC130A4C921440CC-->
<COLUMNNAME><![CDATA[Hqlorderbyclause]]></COLUMNNAME>
+<!--8348666AB4E04BDBAC130A4C921440CC--> <NAME><![CDATA[HQL Order by
Clause]]></NAME>
+<!--8348666AB4E04BDBAC130A4C921440CC--> <PRINTNAME><![CDATA[HQL Order by
Clause]]></PRINTNAME>
+<!--8348666AB4E04BDBAC130A4C921440CC-->
<AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
+<!--8348666AB4E04BDBAC130A4C921440CC--></AD_ELEMENT>
+
<!--841CB823976F391BE040007F0101218F--><AD_ELEMENT>
<!--841CB823976F391BE040007F0101218F-->
<AD_ELEMENT_ID><![CDATA[841CB823976F391BE040007F0101218F]]></AD_ELEMENT_ID>
<!--841CB823976F391BE040007F0101218F-->
<AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
@@ -27393,6 +27404,17 @@
<!--E89D147962E04590B41F406D9AEF4C8E-->
<AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
<!--E89D147962E04590B41F406D9AEF4C8E--></AD_ELEMENT>
+<!--ECAC136184A746C39804BD71BC3C78DB--><AD_ELEMENT>
+<!--ECAC136184A746C39804BD71BC3C78DB-->
<AD_ELEMENT_ID><![CDATA[ECAC136184A746C39804BD71BC3C78DB]]></AD_ELEMENT_ID>
+<!--ECAC136184A746C39804BD71BC3C78DB-->
<AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--ECAC136184A746C39804BD71BC3C78DB--> <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--ECAC136184A746C39804BD71BC3C78DB--> <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--ECAC136184A746C39804BD71BC3C78DB-->
<COLUMNNAME><![CDATA[Hqlwhereclause]]></COLUMNNAME>
+<!--ECAC136184A746C39804BD71BC3C78DB--> <NAME><![CDATA[HQL Where
Clause]]></NAME>
+<!--ECAC136184A746C39804BD71BC3C78DB--> <PRINTNAME><![CDATA[HQL Where
Clause]]></PRINTNAME>
+<!--ECAC136184A746C39804BD71BC3C78DB-->
<AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
+<!--ECAC136184A746C39804BD71BC3C78DB--></AD_ELEMENT>
+
<!--EFCDB5D6E2BD4E5C906C43D2839B1573--><AD_ELEMENT>
<!--EFCDB5D6E2BD4E5C906C43D2839B1573-->
<AD_ELEMENT_ID><![CDATA[EFCDB5D6E2BD4E5C906C43D2839B1573]]></AD_ELEMENT_ID>
<!--EFCDB5D6E2BD4E5C906C43D2839B1573-->
<AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
@@ -27419,6 +27441,17 @@
<!--F197B6D6CCCE4C2F8EB42C34B560428E-->
<AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
<!--F197B6D6CCCE4C2F8EB42C34B560428E--></AD_ELEMENT>
+<!--F3B77B38FDF84D7293862DF5A927783D--><AD_ELEMENT>
+<!--F3B77B38FDF84D7293862DF5A927783D-->
<AD_ELEMENT_ID><![CDATA[F3B77B38FDF84D7293862DF5A927783D]]></AD_ELEMENT_ID>
+<!--F3B77B38FDF84D7293862DF5A927783D-->
<AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--F3B77B38FDF84D7293862DF5A927783D--> <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--F3B77B38FDF84D7293862DF5A927783D--> <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--F3B77B38FDF84D7293862DF5A927783D-->
<COLUMNNAME><![CDATA[Hqlfilterclause]]></COLUMNNAME>
+<!--F3B77B38FDF84D7293862DF5A927783D--> <NAME><![CDATA[HQL Filter
Clause]]></NAME>
+<!--F3B77B38FDF84D7293862DF5A927783D--> <PRINTNAME><![CDATA[HQL Filter
Clause]]></PRINTNAME>
+<!--F3B77B38FDF84D7293862DF5A927783D-->
<AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
+<!--F3B77B38FDF84D7293862DF5A927783D--></AD_ELEMENT>
+
<!--F3BF680089754BAC858ECFF2D5D0F232--><AD_ELEMENT>
<!--F3BF680089754BAC858ECFF2D5D0F232-->
<AD_ELEMENT_ID><![CDATA[F3BF680089754BAC858ECFF2D5D0F232]]></AD_ELEMENT_ID>
<!--F3BF680089754BAC858ECFF2D5D0F232-->
<AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
diff -r 44841807a54d -r 2a0022c73fbf src-db/database/sourcedata/AD_FIELD.xml
--- a/src-db/database/sourcedata/AD_FIELD.xml Fri Oct 22 18:15:12 2010 +0200
+++ b/src-db/database/sourcedata/AD_FIELD.xml Sun Oct 24 22:02:51 2010 +0200
@@ -1452,7 +1452,7 @@
<!--183--> <DISPLAYLOGIC><![cda...@parentreference_id@='18']]></DISPLAYLOGIC>
<!--183--> <DISPLAYLENGTH><![CDATA[60]]></DISPLAYLENGTH>
<!--183--> <ISREADONLY><![CDATA[N]]></ISREADONLY>
-<!--183--> <SEQNO><![CDATA[100]]></SEQNO>
+<!--183--> <SEQNO><![CDATA[90]]></SEQNO>
<!--183--> <ISSAMELINE><![CDATA[N]]></ISSAMELINE>
------------------------------------------------------------------------------
Nokia and AT&T present the 2010 Calling All Innovators-North America contest
Create new apps & games for the Nokia N8 for consumers in U.S. and Canada
$10 million total in prizes - $4M cash, 500 devices, nearly $6M in marketing
Develop with Nokia Qt SDK, Web Runtime, or Java and Publish to Ovi Store
http://p.sf.net/sfu/nokia-dev2dev
_______________________________________________
Openbravo-commits mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/openbravo-commits
