details: https://code.openbravo.com/erp/devel/pi/rev/cdb20a382e76 changeset: 32727:cdb20a382e76 user: David Miguelez <david.miguelez <at> openbravo.com> date: Wed Sep 20 09:18:17 2017 +0200 summary: Fixes Issue 36900. Adds fields to the User selector so it can be seen as a pop up
details: https://code.openbravo.com/erp/devel/pi/rev/3828947e9507 changeset: 32728:3828947e9507 user: David Miguelez <david.miguelez <at> openbravo.com> date: Wed Sep 20 09:18:40 2017 +0200 summary: Fixes Issue 36901. Adds indexes in Product Organization Table details: https://code.openbravo.com/erp/devel/pi/rev/adab8b682f7a changeset: 32729:adab8b682f7a user: David Miguelez <david.miguelez <at> openbravo.com> date: Wed Sep 20 12:17:52 2017 +0200 summary: Related to Issue 36900. Synchronized Terminology diffstat: src-db/database/model/tables/M_PRODUCT_ORG.xml | 7 ++ src-db/database/sourcedata/OBUISEL_SELECTOR_FIELD.xml | 66 +++++++++++++++++++ 2 files changed, 73 insertions(+), 0 deletions(-) diffs (107 lines): diff -r 828a35bc2b9b -r adab8b682f7a src-db/database/model/tables/M_PRODUCT_ORG.xml --- a/src-db/database/model/tables/M_PRODUCT_ORG.xml Tue Sep 19 11:24:16 2017 -0400 +++ b/src-db/database/model/tables/M_PRODUCT_ORG.xml Wed Sep 20 12:17:52 2017 +0200 @@ -110,6 +110,13 @@ <foreign-key foreignTable="M_PRODUCT_PO" name="M_PRODUCT_ORG_PRODUCTPO"> <reference local="M_PRODUCT_PO_ID" foreign="M_PRODUCT_PO_ID"/> </foreign-key> + <index name="M_PRODUCT_ORG_BIN" unique="false"> + <index-column name="M_LOCATOR_ID"/> + <whereClause><![CDATA[M_LOCATOR_ID IS NOT NULL]]></whereClause> + </index> + <index name="M_PRODUCT_ORG_PRODUCT" unique="false"> + <index-column name="M_PRODUCT_ID"/> + </index> <unique name="M_PRODUCT_ORG_ORG_PRODUCT_UN"> <unique-column name="M_PRODUCT_ID"/> <unique-column name="AD_ORG_ID"/> diff -r 828a35bc2b9b -r adab8b682f7a src-db/database/sourcedata/OBUISEL_SELECTOR_FIELD.xml --- a/src-db/database/sourcedata/OBUISEL_SELECTOR_FIELD.xml Tue Sep 19 11:24:16 2017 -0400 +++ b/src-db/database/sourcedata/OBUISEL_SELECTOR_FIELD.xml Wed Sep 20 12:17:52 2017 +0200 @@ -2278,6 +2278,28 @@ <!--7408792B65234E049547D6C78BB074A4--> <SHOWINPICKLIST><![CDATA[Y]]></SHOWINPICKLIST> <!--7408792B65234E049547D6C78BB074A4--></OBUISEL_SELECTOR_FIELD> +<!--74A9A9D8D6464C7DB5A5AD5A80450697--><OBUISEL_SELECTOR_FIELD> +<!--74A9A9D8D6464C7DB5A5AD5A80450697--> <OBUISEL_SELECTOR_FIELD_ID><![CDATA[74A9A9D8D6464C7DB5A5AD5A80450697]]></OBUISEL_SELECTOR_FIELD_ID> +<!--74A9A9D8D6464C7DB5A5AD5A80450697--> <OBUISEL_SELECTOR_ID><![CDATA[06A43991412642449E511F495C408EC8]]></OBUISEL_SELECTOR_ID> +<!--74A9A9D8D6464C7DB5A5AD5A80450697--> <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID> +<!--74A9A9D8D6464C7DB5A5AD5A80450697--> <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID> +<!--74A9A9D8D6464C7DB5A5AD5A80450697--> <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID> +<!--74A9A9D8D6464C7DB5A5AD5A80450697--> <AD_COLUMN_ID><![CDATA[800170]]></AD_COLUMN_ID> +<!--74A9A9D8D6464C7DB5A5AD5A80450697--> <NAME><![CDATA[First Name]]></NAME> +<!--74A9A9D8D6464C7DB5A5AD5A80450697--> <DESCRIPTION><![CDATA[Name of the contact]]></DESCRIPTION> +<!--74A9A9D8D6464C7DB5A5AD5A80450697--> <HELP><![CDATA[First Name of the contact]]></HELP> +<!--74A9A9D8D6464C7DB5A5AD5A80450697--> <PROPERTY><![CDATA[firstName]]></PROPERTY> +<!--74A9A9D8D6464C7DB5A5AD5A80450697--> <ISCENTRALLYMAINTAINED><![CDATA[Y]]></ISCENTRALLYMAINTAINED> +<!--74A9A9D8D6464C7DB5A5AD5A80450697--> <SORT><![CDATA[Y]]></SORT> +<!--74A9A9D8D6464C7DB5A5AD5A80450697--> <FILTER><![CDATA[Y]]></FILTER> +<!--74A9A9D8D6464C7DB5A5AD5A80450697--> <SEARCHINSUGGESTIONBOX><![CDATA[N]]></SEARCHINSUGGESTIONBOX> +<!--74A9A9D8D6464C7DB5A5AD5A80450697--> <SHOWINGRID><![CDATA[Y]]></SHOWINGRID> +<!--74A9A9D8D6464C7DB5A5AD5A80450697--> <SORTNO><![CDATA[20]]></SORTNO> +<!--74A9A9D8D6464C7DB5A5AD5A80450697--> <ISACTIVE><![CDATA[Y]]></ISACTIVE> +<!--74A9A9D8D6464C7DB5A5AD5A80450697--> <ISOUTFIELD><![CDATA[N]]></ISOUTFIELD> +<!--74A9A9D8D6464C7DB5A5AD5A80450697--> <SHOWINPICKLIST><![CDATA[N]]></SHOWINPICKLIST> +<!--74A9A9D8D6464C7DB5A5AD5A80450697--></OBUISEL_SELECTOR_FIELD> + <!--76225C69A4F24D84BCD98E177D16B99F--><OBUISEL_SELECTOR_FIELD> <!--76225C69A4F24D84BCD98E177D16B99F--> <OBUISEL_SELECTOR_FIELD_ID><![CDATA[76225C69A4F24D84BCD98E177D16B99F]]></OBUISEL_SELECTOR_FIELD_ID> <!--76225C69A4F24D84BCD98E177D16B99F--> <OBUISEL_SELECTOR_ID><![CDATA[1F9CEAB7298046CF8156462ED33006D5]]></OBUISEL_SELECTOR_ID> @@ -3213,6 +3235,28 @@ <!--A29D60CD276243789FCACA4D044318FE--> <SHOWINPICKLIST><![CDATA[N]]></SHOWINPICKLIST> <!--A29D60CD276243789FCACA4D044318FE--></OBUISEL_SELECTOR_FIELD> +<!--A42569D7B66A42BD8D89640542E587BD--><OBUISEL_SELECTOR_FIELD> +<!--A42569D7B66A42BD8D89640542E587BD--> <OBUISEL_SELECTOR_FIELD_ID><![CDATA[A42569D7B66A42BD8D89640542E587BD]]></OBUISEL_SELECTOR_FIELD_ID> +<!--A42569D7B66A42BD8D89640542E587BD--> <OBUISEL_SELECTOR_ID><![CDATA[06A43991412642449E511F495C408EC8]]></OBUISEL_SELECTOR_ID> +<!--A42569D7B66A42BD8D89640542E587BD--> <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID> +<!--A42569D7B66A42BD8D89640542E587BD--> <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID> +<!--A42569D7B66A42BD8D89640542E587BD--> <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID> +<!--A42569D7B66A42BD8D89640542E587BD--> <AD_COLUMN_ID><![CDATA[801059]]></AD_COLUMN_ID> +<!--A42569D7B66A42BD8D89640542E587BD--> <NAME><![CDATA[Username]]></NAME> +<!--A42569D7B66A42BD8D89640542E587BD--> <DESCRIPTION><![CDATA[User Name]]></DESCRIPTION> +<!--A42569D7B66A42BD8D89640542E587BD--> <HELP><![CDATA[Name that identifies the user in the System]]></HELP> +<!--A42569D7B66A42BD8D89640542E587BD--> <PROPERTY><![CDATA[username]]></PROPERTY> +<!--A42569D7B66A42BD8D89640542E587BD--> <ISCENTRALLYMAINTAINED><![CDATA[Y]]></ISCENTRALLYMAINTAINED> +<!--A42569D7B66A42BD8D89640542E587BD--> <SORT><![CDATA[Y]]></SORT> +<!--A42569D7B66A42BD8D89640542E587BD--> <FILTER><![CDATA[Y]]></FILTER> +<!--A42569D7B66A42BD8D89640542E587BD--> <SEARCHINSUGGESTIONBOX><![CDATA[N]]></SEARCHINSUGGESTIONBOX> +<!--A42569D7B66A42BD8D89640542E587BD--> <SHOWINGRID><![CDATA[Y]]></SHOWINGRID> +<!--A42569D7B66A42BD8D89640542E587BD--> <SORTNO><![CDATA[10]]></SORTNO> +<!--A42569D7B66A42BD8D89640542E587BD--> <ISACTIVE><![CDATA[Y]]></ISACTIVE> +<!--A42569D7B66A42BD8D89640542E587BD--> <ISOUTFIELD><![CDATA[N]]></ISOUTFIELD> +<!--A42569D7B66A42BD8D89640542E587BD--> <SHOWINPICKLIST><![CDATA[N]]></SHOWINPICKLIST> +<!--A42569D7B66A42BD8D89640542E587BD--></OBUISEL_SELECTOR_FIELD> + <!--A70124FC61904F7BAD6F8BDF436931B4--><OBUISEL_SELECTOR_FIELD> <!--A70124FC61904F7BAD6F8BDF436931B4--> <OBUISEL_SELECTOR_FIELD_ID><![CDATA[A70124FC61904F7BAD6F8BDF436931B4]]></OBUISEL_SELECTOR_FIELD_ID> <!--A70124FC61904F7BAD6F8BDF436931B4--> <OBUISEL_SELECTOR_ID><![CDATA[F132874BE0954A9B8C1301BE20704730]]></OBUISEL_SELECTOR_ID> @@ -3758,6 +3802,28 @@ <!--C68D5472E5C94D01AD29C3AA4946B698--> <SHOWINPICKLIST><![CDATA[N]]></SHOWINPICKLIST> <!--C68D5472E5C94D01AD29C3AA4946B698--></OBUISEL_SELECTOR_FIELD> +<!--C822ACC9CBB042B2B6569F9A92C59F3D--><OBUISEL_SELECTOR_FIELD> +<!--C822ACC9CBB042B2B6569F9A92C59F3D--> <OBUISEL_SELECTOR_FIELD_ID><![CDATA[C822ACC9CBB042B2B6569F9A92C59F3D]]></OBUISEL_SELECTOR_FIELD_ID> +<!--C822ACC9CBB042B2B6569F9A92C59F3D--> <OBUISEL_SELECTOR_ID><![CDATA[06A43991412642449E511F495C408EC8]]></OBUISEL_SELECTOR_ID> +<!--C822ACC9CBB042B2B6569F9A92C59F3D--> <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID> +<!--C822ACC9CBB042B2B6569F9A92C59F3D--> <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID> +<!--C822ACC9CBB042B2B6569F9A92C59F3D--> <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID> +<!--C822ACC9CBB042B2B6569F9A92C59F3D--> <AD_COLUMN_ID><![CDATA[800171]]></AD_COLUMN_ID> +<!--C822ACC9CBB042B2B6569F9A92C59F3D--> <NAME><![CDATA[Last Name]]></NAME> +<!--C822ACC9CBB042B2B6569F9A92C59F3D--> <DESCRIPTION><![CDATA[Last name of the contact]]></DESCRIPTION> +<!--C822ACC9CBB042B2B6569F9A92C59F3D--> <HELP><![CDATA[Last name of the contact]]></HELP> +<!--C822ACC9CBB042B2B6569F9A92C59F3D--> <PROPERTY><![CDATA[lastName]]></PROPERTY> +<!--C822ACC9CBB042B2B6569F9A92C59F3D--> <ISCENTRALLYMAINTAINED><![CDATA[Y]]></ISCENTRALLYMAINTAINED> +<!--C822ACC9CBB042B2B6569F9A92C59F3D--> <SORT><![CDATA[Y]]></SORT> +<!--C822ACC9CBB042B2B6569F9A92C59F3D--> <FILTER><![CDATA[Y]]></FILTER> +<!--C822ACC9CBB042B2B6569F9A92C59F3D--> <SEARCHINSUGGESTIONBOX><![CDATA[N]]></SEARCHINSUGGESTIONBOX> +<!--C822ACC9CBB042B2B6569F9A92C59F3D--> <SHOWINGRID><![CDATA[Y]]></SHOWINGRID> +<!--C822ACC9CBB042B2B6569F9A92C59F3D--> <SORTNO><![CDATA[30]]></SORTNO> +<!--C822ACC9CBB042B2B6569F9A92C59F3D--> <ISACTIVE><![CDATA[Y]]></ISACTIVE> +<!--C822ACC9CBB042B2B6569F9A92C59F3D--> <ISOUTFIELD><![CDATA[N]]></ISOUTFIELD> +<!--C822ACC9CBB042B2B6569F9A92C59F3D--> <SHOWINPICKLIST><![CDATA[N]]></SHOWINPICKLIST> +<!--C822ACC9CBB042B2B6569F9A92C59F3D--></OBUISEL_SELECTOR_FIELD> + <!--C8D400B2F068460C882BB44977BEAAEF--><OBUISEL_SELECTOR_FIELD> <!--C8D400B2F068460C882BB44977BEAAEF--> <OBUISEL_SELECTOR_FIELD_ID><![CDATA[C8D400B2F068460C882BB44977BEAAEF]]></OBUISEL_SELECTOR_FIELD_ID> <!--C8D400B2F068460C882BB44977BEAAEF--> <OBUISEL_SELECTOR_ID><![CDATA[F132874BE0954A9B8C1301BE20704730]]></OBUISEL_SELECTOR_ID> ------------------------------------------------------------------------------ Check out the vibrant tech community on one of the world's most engaging tech sites, Slashdot.org! http://sdm.link/slashdot _______________________________________________ Openbravo-commits mailing list Openbravo-commits@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/openbravo-commits
