details: https://code.openbravo.com/erp/devel/main/rev/73d62bd34183 changeset: 34109:73d62bd34183 user: RM packaging bot <staff.rm <at> openbravo.com> date: Wed May 30 14:59:09 2018 +0000 summary: CI: merge back from main
details: https://code.openbravo.com/erp/devel/main/rev/ccd31fe0e137 changeset: 34110:ccd31fe0e137 user: Javier Armendáriz <javier.armendariz <at> openbravo.com> date: Thu May 10 09:02:56 2018 +0200 summary: [ropr] Default pool can be defined as a preference. This preference takes precedence when requesting a non-default pool. E.g. if preference is set to "DEFAULT" and requested "RO", "DEFAULT" pool will be returned. details: https://code.openbravo.com/erp/devel/main/rev/9dda59fdcefc changeset: 34111:9dda59fdcefc user: Javier Armendáriz <javier.armendariz <at> openbravo.com> date: Mon May 14 10:38:39 2018 +0200 summary: [ropr] Moving preference set up as using Preferences directly in OBDal leads to compilation errors. details: https://code.openbravo.com/erp/devel/main/rev/389ff56fef22 changeset: 34112:389ff56fef22 user: Javier Armendáriz <javier.armendariz <at> openbravo.com> date: Mon May 14 16:35:01 2018 +0200 summary: [ropr] Created Data pool selection table and window details: https://code.openbravo.com/erp/devel/main/rev/37b27453790e changeset: 34113:37b27453790e user: Javier Armendáriz <javier.armendariz <at> openbravo.com> date: Tue May 15 14:27:44 2018 +0200 summary: [ropr] OBDal checks preference and DataPoolSelection to decide which pool returns. details: https://code.openbravo.com/erp/devel/main/rev/f2be61e4c8e2 changeset: 34114:f2be61e4c8e2 user: Javier Armendáriz <javier.armendariz <at> openbravo.com> date: Tue May 15 19:27:34 2018 +0200 summary: [ropr] Reorganized code and adding an info message when DataPoolSel window opens. details: https://code.openbravo.com/erp/devel/main/rev/908b897ed057 changeset: 34115:908b897ed057 user: Javier Armendáriz <javier.armendariz <at> openbravo.com> date: Wed May 16 10:30:08 2018 +0200 summary: [ropr] Showing message only when RO Pool is not enabled. details: https://code.openbravo.com/erp/devel/main/rev/6c403e90fc9b changeset: 34116:6c403e90fc9b user: Javier Armendáriz <javier.armendariz <at> openbravo.com> date: Wed May 16 16:22:15 2018 +0200 summary: [ropr] Fixed cases where behaviors are not as expected. details: https://code.openbravo.com/erp/devel/main/rev/9329c5043cf1 changeset: 34117:9329c5043cf1 user: Javier Armendáriz <javier.armendariz <at> openbravo.com> date: Wed May 16 18:21:32 2018 +0200 summary: [ropr] Adding test case to refactor DataPoolChecker trying to make it more readable. details: https://code.openbravo.com/erp/devel/main/rev/c9b87a8ff740 changeset: 34118:c9b87a8ff740 user: Javier Armendáriz <javier.armendariz <at> openbravo.com> date: Thu May 17 11:03:03 2018 +0200 summary: [ropr] Reordered fields and restricted processes fields to show reports only details: https://code.openbravo.com/erp/devel/main/rev/92fce384fab4 changeset: 34119:92fce384fab4 user: Javier Armendáriz <javier.armendariz <at> openbravo.com> date: Thu May 17 17:03:46 2018 +0200 summary: [ropr] Updating process selection after updating DataPoolSelection entries details: https://code.openbravo.com/erp/devel/main/rev/c289ced96863 changeset: 34120:c289ced96863 user: Javier Armendáriz <javier.armendariz <at> openbravo.com> date: Wed May 23 15:48:17 2018 +0200 summary: Merging changes from ro-pool-per-report details: https://code.openbravo.com/erp/devel/main/rev/61f325a63483 changeset: 34121:61f325a63483 user: Javier Armendáriz <javier.armendariz <at> openbravo.com> date: Wed May 23 15:48:38 2018 +0200 summary: [ropr] Created a View to group all reports in a single location. This view can be referenced using a tabledir reference to select a report from all availables from ad_process and obuiapp_process. details: https://code.openbravo.com/erp/devel/main/rev/b2625c63a128 changeset: 34122:b2625c63a128 user: Javier Armendáriz <javier.armendariz <at> openbravo.com> date: Wed May 23 16:40:05 2018 +0200 summary: [ropr] Using reports view instead of referencing each process table. details: https://code.openbravo.com/erp/devel/main/rev/12f36d4fff75 changeset: 34123:12f36d4fff75 user: Javier Armendáriz <javier.armendariz <at> openbravo.com> date: Wed May 23 17:43:27 2018 +0200 summary: [ropr] Created selector to improve filtering of reports in data pool selection. details: https://code.openbravo.com/erp/devel/main/rev/853a93ba7bf5 changeset: 34124:853a93ba7bf5 user: Javier Armendáriz <javier.armendariz <at> openbravo.com> date: Thu May 24 09:01:53 2018 +0200 summary: [ropr] Report field in data pool selection should be required. details: https://code.openbravo.com/erp/devel/main/rev/ccb03e77de60 changeset: 34125:ccb03e77de60 user: Javier Armendáriz <javier.armendariz <at> openbravo.com> date: Thu May 24 11:28:17 2018 +0200 summary: [ropr] Replacing table reference in report to window reference. In addition, filter is improved to exclude toolbar print reports and include reports marked as Jasper but not as a report in AD_Process. details: https://code.openbravo.com/erp/devel/main/rev/ae7969aa49e0 changeset: 34126:ae7969aa49e0 user: Javier Armendáriz <javier.armendariz <at> openbravo.com> date: Thu May 24 13:45:39 2018 +0200 summary: [ropr] Adding test cases in DalTest, fixing warning and updating labels. details: https://code.openbravo.com/erp/devel/main/rev/4ecbfe25eceb changeset: 34127:4ecbfe25eceb user: Carlos Aristu <carlos.aristu <at> openbravo.com> date: Fri May 25 08:28:56 2018 +0200 summary: [ropr] Merge with pi details: https://code.openbravo.com/erp/devel/main/rev/275ec33e0504 changeset: 34128:275ec33e0504 user: Carlos Aristu <carlos.aristu <at> openbravo.com> date: Fri May 25 09:53:06 2018 +0200 summary: [ropr] Missing changes from merge details: https://code.openbravo.com/erp/devel/main/rev/e45f6e10d7ea changeset: 34129:e45f6e10d7ea user: Javier Armendáriz <javier.armendariz <at> openbravo.com> date: Thu May 24 17:30:31 2018 +0200 summary: [ropr] Fixed view definition for Oracle details: https://code.openbravo.com/erp/devel/main/rev/e3a48dee20b9 changeset: 34130:e3a48dee20b9 user: Javier Armendáriz <javier.armendariz <at> openbravo.com> date: Fri May 25 01:32:04 2018 +0200 summary: [ropr] Changed column name to avoid warning of undefined foreign key. details: https://code.openbravo.com/erp/devel/main/rev/e96da52f33aa changeset: 34131:e96da52f33aa user: Javier Armendáriz <javier.armendariz <at> openbravo.com> date: Mon May 28 12:15:33 2018 +0200 summary: [ropr] Code review fixes. - Cleaned code in DataPoolSelectionWindowInjector - Data pool field in obuiapp_data_pool_sel set as required - Removed data pool selection tab specific code from ob-standard-view - Converted DataPoolChecker to an Application scoped class instead of relying on static method/fields - Adding unique constraint to report field in obuiapp_data_pool_sel details: https://code.openbravo.com/erp/devel/main/rev/9daa72da6910 changeset: 34132:9daa72da6910 user: Javier Armendáriz <javier.armendariz <at> openbravo.com> date: Mon May 28 15:44:51 2018 +0200 summary: [ropr] Code review fixes. - Adding processId to report using PrintJR class to make it identificable - Generalized OB.DataPoolSel to a generic callback function that can be used to show an info message in any window. - Changed DataPoolChecker to implement OBSingleton instead of using Weld. - Refactored DataPoolChecker to minimize its public API - Removed TestCases for DataPoolChecker - Improving description/help text of Data Pool Selection window - General code cleanup details: https://code.openbravo.com/erp/devel/main/rev/dcbc565fb798 changeset: 34133:dcbc565fb798 user: Javier Armendáriz <javier.armendariz <at> openbravo.com> date: Tue May 29 13:38:18 2018 +0200 summary: Merge with pi details: https://code.openbravo.com/erp/devel/main/rev/fffcff7de7af changeset: 34134:fffcff7de7af user: Javier Armendáriz <javier.armendariz <at> openbravo.com> date: Wed May 30 13:32:37 2018 +0200 summary: [ropr] Review fixes - Changed ExtraWindowSettingCallbackUtils to be part of OB.Utils - Corrected sequence number of columns of OBUIAPP_Data_Pool_Sel and OBUIAPP_Pool_Report - Moving DataPoolSelectionEventHandler to application module package. - Improved documentation - Small code improvements details: https://code.openbravo.com/erp/devel/main/rev/711f3078e488 changeset: 34135:711f3078e488 user: Javier Armendáriz <javier.armendariz <at> openbravo.com> date: Wed May 30 18:31:24 2018 +0200 summary: [ropr] Review fixes - Moved preference to client.application module - Changed name of ExtraWindowSettingsAction utilities file - DataPoolSelectionEventHandler now caches DataPoolChecker - Improved code comments. - Fixed raw type warning details: https://code.openbravo.com/erp/devel/main/rev/9996235926db changeset: 34136:9996235926db user: Javier Armendáriz <javier.armendariz <at> openbravo.com> date: Wed May 30 19:16:11 2018 +0200 summary: [ropr] Small fixes. details: https://code.openbravo.com/erp/devel/main/rev/e5764910c260 changeset: 34137:e5764910c260 user: Javier Armendáriz <javier.armendariz <at> openbravo.com> date: Wed May 30 19:21:28 2018 +0200 summary: Fixed issue 38479: Enable read-only pool per report details: https://code.openbravo.com/erp/devel/main/rev/df98c99a846d changeset: 34138:df98c99a846d user: Javier Armendáriz <javier.armendariz <at> openbravo.com> date: Thu May 31 09:29:11 2018 +0200 summary: Related to isue 38479: Removed unused validation rule. details: https://code.openbravo.com/erp/devel/main/rev/5ae34663c033 changeset: 34139:5ae34663c033 user: Asier Lostalé <asier.lostale <at> openbravo.com> date: Wed May 30 13:03:45 2018 +0200 summary: fixes 38659: new roles should be manual by default * By default, new roles are now maked as manual and not advanced * When a role is moved from manual to automatic, permissions are now recalculated * Roles created in Initial Client and Org setup are kept as privileged details: https://code.openbravo.com/erp/devel/main/rev/85397f1d9ed3 changeset: 34140:85397f1d9ed3 user: David Miguelez <david.miguelez <at> openbravo.com> date: Tue May 29 11:49:24 2018 +0200 summary: Fixes Issue 38547. When cloning a sales order, exploded non stocked BOM product is related with the original order line * When an order line that has been created from an exploded BOM is created, it is added to a list to fix the relationship after cloning all order lines * When all order lines are cloned, this relationship is fixed by pointing to the cloned order line of the parent bom product * Moved logic for fixing services relationship into it's own method details: https://code.openbravo.com/erp/devel/main/rev/4e724a6b981c changeset: 34141:4e724a6b981c user: David Miguelez <david.miguelez <at> openbravo.com> date: Tue May 29 12:30:08 2018 +0200 summary: Related to Issue 38547. Code Refactor: * Moved logic to clone order into it's own method * Moved logic to clone order lines into it's own method * Remove unnecessary save * Reorder methods * Add final modifiers to method parameters details: https://code.openbravo.com/erp/devel/main/rev/d3f7aa6b4ab4 changeset: 34142:d3f7aa6b4ab4 user: Iñaki Garcia <inaki.garcia <at> openbravo.com> date: Thu May 31 18:53:23 2018 +0200 summary: Adding the data created by the RTVa001 test to the Sample Data of QA Testing client details: https://code.openbravo.com/erp/devel/main/rev/12eeb2e88344 changeset: 34143:12eeb2e88344 user: Iñaki Garcia <inaki.garcia <at> openbravo.com> date: Fri Jun 01 09:21:14 2018 +0200 summary: Removing bad changes in sourcedata from the previous commit details: https://code.openbravo.com/erp/devel/main/rev/275b95fc2b25 changeset: 34144:275b95fc2b25 user: Iñaki Garcia <inaki.garcia <at> openbravo.com> date: Fri Jun 01 12:48:01 2018 +0200 summary: Adding product of RTVa002 to QA Admin client sample data details: https://code.openbravo.com/erp/devel/main/rev/afb2d019fd78 changeset: 34145:afb2d019fd78 user: Asier Lostalé <asier.lostale <at> openbravo.com> date: Tue Apr 24 08:16:45 2018 +0200 summary: [license] remove obsolete public key details: https://code.openbravo.com/erp/devel/main/rev/77cc4f65b1d0 changeset: 34146:77cc4f65b1d0 user: Asier Lostalé <asier.lostale <at> openbravo.com> date: Tue Apr 24 09:51:12 2018 +0200 summary: [license] removed support for On Demand licenses details: https://code.openbravo.com/erp/devel/main/rev/893677531a1b changeset: 34147:893677531a1b user: Asier Lostalé <asier.lostale <at> openbravo.com> date: Tue Apr 24 09:59:22 2018 +0200 summary: [license] don't use HSAS as ConnectionProvider in InstanceManagement form details: https://code.openbravo.com/erp/devel/main/rev/6e50c5e7df62 changeset: 34148:6e50c5e7df62 user: Asier Lostalé <asier.lostale <at> openbravo.com> date: Tue Apr 24 10:31:53 2018 +0200 summary: [license] Instance Activation form: removed 2.50 UI components details: https://code.openbravo.com/erp/devel/main/rev/ac189b130d73 changeset: 34149:ac189b130d73 user: Asier Lostalé <asier.lostale <at> openbravo.com> date: Tue Apr 24 11:15:02 2018 +0200 summary: [license] moved HTML license visualization to Instance Activation Servlet details: https://code.openbravo.com/erp/devel/main/rev/d9ce9a9f3c40 changeset: 34150:d9ce9a9f3c40 user: Asier Lostalé <asier.lostale <at> openbravo.com> date: Tue Apr 24 11:15:48 2018 +0200 summary: [license] limit named users only if set in properties details: https://code.openbravo.com/erp/devel/main/rev/ddccda9c7091 changeset: 34151:ddccda9c7091 user: Asier Lostalé <asier.lostale <at> openbravo.com> date: Mon May 14 11:19:22 2018 +0200 summary: [license] Removed concurrent named user restrictions Now it is no longer possible to define in Openbravo.properties concurrent named user restriction. details: https://code.openbravo.com/erp/devel/main/rev/3c86e8920502 changeset: 34152:3c86e8920502 user: Asier Lostalé <asier.lostale <at> openbravo.com> date: Mon May 14 12:38:19 2018 +0200 summary: [license] removed already deprecated ad_module.commercial_tier column This information was set to support Basic instances which now are no longer supported in Central Repository, so they can be removed. details: https://code.openbravo.com/erp/devel/main/rev/9e34b49d6804 changeset: 34153:9e34b49d6804 user: Asier Lostalé <asier.lostale <at> openbravo.com> date: Wed May 30 16:08:26 2018 +0200 summary: [license] pi merge details: https://code.openbravo.com/erp/devel/main/rev/498bb9729855 changeset: 34154:498bb9729855 user: Asier Lostalé <asier.lostale <at> openbravo.com> date: Wed May 30 16:50:03 2018 +0200 summary: [license] use set for better perfomance details: https://code.openbravo.com/erp/devel/main/rev/d6db8cc14085 changeset: 34155:d6db8cc14085 user: Asier Lostalé <asier.lostale <at> openbravo.com> date: Wed May 30 17:01:27 2018 +0200 summary: [license] removed openInstanceManagementForm as out of demand platform was its only user details: https://code.openbravo.com/erp/devel/main/rev/753060462f38 changeset: 34156:753060462f38 user: Asier Lostalé <asier.lostale <at> openbravo.com> date: Thu May 31 09:29:46 2018 +0200 summary: [license] pi merge details: https://code.openbravo.com/erp/devel/main/rev/98d4794d0fc1 changeset: 34157:98d4794d0fc1 user: Asier Lostalé <asier.lostale <at> openbravo.com> date: Thu May 31 12:32:09 2018 +0200 summary: [license] trying to refresh with a broken license This can happen in case of old Basic licenses that were singed with a now invalid key. Refreshing the license from Butler will fix the problem. details: https://code.openbravo.com/erp/devel/main/rev/b63c083262e3 changeset: 34158:b63c083262e3 user: Asier Lostalé <asier.lostale <at> openbravo.com> date: Fri Jun 01 10:40:19 2018 +0200 summary: [license] removed some clutter details: https://code.openbravo.com/erp/devel/main/rev/7a4554ef6d4a changeset: 34159:7a4554ef6d4a user: Asier Lostalé <asier.lostale <at> openbravo.com> date: Fri Jun 01 11:56:17 2018 +0200 summary: fixes 38679: remove obsolete License features Removed: - On demand license - Named users restrictions - Commercial module tiers details: https://code.openbravo.com/erp/devel/main/rev/4bd839ca0394 changeset: 34160:4bd839ca0394 user: Asier Lostalé <asier.lostale <at> openbravo.com> date: Fri Jun 01 12:49:04 2018 +0200 summary: [license] pi merge details: https://code.openbravo.com/erp/devel/main/rev/99a1cd55eaaa changeset: 34161:99a1cd55eaaa user: Carlos Aristu <carlos.aristu <at> openbravo.com> date: Fri Jun 01 14:53:03 2018 +0200 summary: related to issue 38661: initial code clean up Removed some unused variables details: https://code.openbravo.com/erp/devel/main/rev/b06b5a1512ec changeset: 34162:b06b5a1512ec user: Carlos Aristu <carlos.aristu <at> openbravo.com> date: Fri Jun 01 09:20:31 2018 +0200 summary: fixes bug 38661: False form change detection due to blur event of 'Time' fields When a blur was performed on time fields, false changes were being detected in the form. This was happening because the comparison done by SC between the value of the field and the value returned with the mapDisplayToValue() function were different. Changes were detected because time fields stores also the date, and when getting/setting the value todays date is set as date. This change was not being done in the mapDisplayToValue() function. So, now we are setting todays date in the value returned by mapDisplayToValue() in order to be consistent. This avoids the false change detection in the form. Note that we are extracting the setTodaysDate as a class method of OBTimeItem, this is because how SC TimeItem is invoking the mapDisplayToValue() function[1]. This way we ensure that the function can always be found. [1] https://code.openbravo.com/erp/mods/org.openbravo.userinterface.smartclient.dev/file/tip/web/org.openbravo.userinterface.smartclient/isomorphic/client/widgets/form/TimeItem.js#l281 details: https://code.openbravo.com/erp/devel/main/rev/e7f187bd7238 changeset: 34163:e7f187bd7238 user: Asier Lostalé <asier.lostale <at> openbravo.com> date: Mon Jun 04 08:39:10 2018 +0200 summary: related to issue 38679: removed unused message details: https://code.openbravo.com/erp/devel/main/rev/270c8e805fb3 changeset: 34164:270c8e805fb3 user: Carlos Aristu <carlos.aristu <at> openbravo.com> date: Mon Jun 04 12:30:03 2018 +0200 summary: fixes bug 38689: Avoid setting as automatic a role that inherits permissions details: https://code.openbravo.com/erp/devel/main/rev/7332b0c1a8cd changeset: 34165:7332b0c1a8cd user: Carlos Aristu <carlos.aristu <at> openbravo.com> date: Mon Jun 04 19:32:10 2018 +0200 summary: fixes bug 38593: Wrong cell style calculation when hiding the calendar lanes This was an issue in Smartclient, fixed here[1]. When hidding the calendar lanes, the chosen date was not being retrieved properly, avoiding the proper calculation of the cell styles. [1] https://code.openbravo.com/private/com.isomorphic.smartclient/diff/073b213e9dc4/SmartClient/smartclientSDK/source/client/widgets/CalendarView.js#l1.339 details: https://code.openbravo.com/erp/devel/main/rev/909e2725902f changeset: 34166:909e2725902f user: Asier Lostalé <asier.lostale <at> openbravo.com> date: Tue Jun 05 11:29:06 2018 +0200 summary: fixed bug bug 38700: incorrect PL inconsistency warn in ORA When generating patterns to standardardize invocations to PL functions with output parameters, take into account all functions, not just the ones defined in current module. details: https://code.openbravo.com/erp/devel/main/rev/8317f2f73d00 changeset: 34167:8317f2f73d00 user: RM packaging bot <staff.rm <at> openbravo.com> date: Tue Jun 05 15:14:32 2018 +0000 summary: CI: update AD_MODULE to version 34166 diffstat: config/Openbravo.properties.template | 3 - modules/org.openbravo.advpaymentmngt/src-db/database/sourcedata/AD_MODULE.xml | 2 +- modules/org.openbravo.advpaymentmngt/src-db/database/sourcedata/AD_MODULE_DEPENDENCY.xml | 4 +- modules/org.openbravo.apachejdbcconnectionpool/src-db/database/sourcedata/AD_MODULE.xml | 2 +- modules/org.openbravo.apachejdbcconnectionpool/src-db/database/sourcedata/AD_MODULE_DEPENDENCY.xml | 2 +- modules/org.openbravo.base.weld/src-db/database/sourcedata/AD_MODULE.xml | 2 +- modules/org.openbravo.base.weld/src-db/database/sourcedata/AD_MODULE_DEPENDENCY.xml | 2 +- modules/org.openbravo.client.application/src-db/database/model/tables/OBUIAPP_DATA_POOL_SEL.xml | 55 + modules/org.openbravo.client.application/src-db/database/model/views/OBUIAPP_POOL_REPORT_V.xml | 4 + modules/org.openbravo.client.application/src-db/database/sourcedata/AD_COLUMN.xml | 773 ++++++++++ modules/org.openbravo.client.application/src-db/database/sourcedata/AD_ELEMENT.xml | 42 + modules/org.openbravo.client.application/src-db/database/sourcedata/AD_FIELD.xml | 168 ++ modules/org.openbravo.client.application/src-db/database/sourcedata/AD_MENU.xml | 14 + modules/org.openbravo.client.application/src-db/database/sourcedata/AD_MESSAGE.xml | 24 +- modules/org.openbravo.client.application/src-db/database/sourcedata/AD_MODULE.xml | 2 +- modules/org.openbravo.client.application/src-db/database/sourcedata/AD_MODULE_DEPENDENCY.xml | 8 +- modules/org.openbravo.client.application/src-db/database/sourcedata/AD_PREFERENCE.xml | 13 + modules/org.openbravo.client.application/src-db/database/sourcedata/AD_REFERENCE.xml | 28 + modules/org.openbravo.client.application/src-db/database/sourcedata/AD_REF_LIST.xml | 12 + modules/org.openbravo.client.application/src-db/database/sourcedata/AD_TAB.xml | 31 + modules/org.openbravo.client.application/src-db/database/sourcedata/AD_TABLE.xml | 49 + modules/org.openbravo.client.application/src-db/database/sourcedata/AD_TREENODE.xml | 23 +- modules/org.openbravo.client.application/src-db/database/sourcedata/AD_WINDOW.xml | 17 + modules/org.openbravo.client.application/src-db/database/sourcedata/OBUISEL_SELECTOR.xml | 19 + modules/org.openbravo.client.application/src-db/database/sourcedata/OBUISEL_SELECTOR_FIELD.xml | 47 + modules/org.openbravo.client.application/src/org/openbravo/client/application/ApplicationComponentProvider.java | 7 +- modules/org.openbravo.client.application/src/org/openbravo/client/application/HeartBeatPopUpComponent.java | 4 +- modules/org.openbravo.client.application/src/org/openbravo/client/application/businesslogic/CloneOrderActionHandler.java | 224 +- modules/org.openbravo.client.application/src/org/openbravo/client/application/event/DataPoolSelectionEventHandler.java | 96 + modules/org.openbravo.client.application/src/org/openbravo/client/application/window/hooks/DataPoolSelectionWindowInjector.java | 79 + modules/org.openbravo.client.application/web/org.openbravo.client.application/js/callback/ob-extra-window-settings-actions.js | 33 + modules/org.openbravo.client.application/web/org.openbravo.client.application/js/classic/ob-classic-compatibility.js | 16 - modules/org.openbravo.client.application/web/org.openbravo.client.application/js/form/formitem/ob-formitem-time.js | 44 +- modules/org.openbravo.client.htmlwidget/src-db/database/sourcedata/AD_MODULE.xml | 2 +- modules/org.openbravo.client.htmlwidget/src-db/database/sourcedata/AD_MODULE_DEPENDENCY.xml | 2 +- modules/org.openbravo.client.kernel/src-db/database/sourcedata/AD_MODULE.xml | 2 +- modules/org.openbravo.client.kernel/src-db/database/sourcedata/AD_MODULE_DEPENDENCY.xml | 6 +- modules/org.openbravo.client.myob/src-db/database/sourcedata/AD_MODULE.xml | 2 +- modules/org.openbravo.client.myob/src-db/database/sourcedata/AD_MODULE_DEPENDENCY.xml | 4 +- modules/org.openbravo.client.querylist/src-db/database/sourcedata/AD_MODULE.xml | 2 +- modules/org.openbravo.client.querylist/src-db/database/sourcedata/AD_MODULE_DEPENDENCY.xml | 2 +- modules/org.openbravo.client.widgets/src-db/database/sourcedata/AD_MODULE.xml | 2 +- modules/org.openbravo.client.widgets/src-db/database/sourcedata/AD_MODULE_DEPENDENCY.xml | 2 +- modules/org.openbravo.financial.paymentreport/src-db/database/sourcedata/AD_MODULE.xml | 2 +- modules/org.openbravo.financial.paymentreport/src-db/database/sourcedata/AD_MODULE_DEPENDENCY.xml | 2 +- modules/org.openbravo.reports.ordersawaitingdelivery/src-db/database/sourcedata/AD_MODULE.xml | 2 +- modules/org.openbravo.reports.ordersawaitingdelivery/src-db/database/sourcedata/AD_MODULE_DEPENDENCY.xml | 2 +- modules/org.openbravo.service.datasource/src-db/database/sourcedata/AD_MODULE.xml | 2 +- modules/org.openbravo.service.datasource/src-db/database/sourcedata/AD_MODULE_DEPENDENCY.xml | 10 +- modules/org.openbravo.service.integration.google/src-db/database/sourcedata/AD_MODULE.xml | 2 +- modules/org.openbravo.service.integration.google/src-db/database/sourcedata/AD_MODULE_DEPENDENCY.xml | 4 +- modules/org.openbravo.service.integration.openid/src-db/database/sourcedata/AD_MODULE.xml | 2 +- modules/org.openbravo.service.integration.openid/src-db/database/sourcedata/AD_MODULE_DEPENDENCY.xml | 2 +- modules/org.openbravo.service.json/src-db/database/sourcedata/AD_MODULE.xml | 2 +- modules/org.openbravo.service.json/src-db/database/sourcedata/AD_MODULE_DEPENDENCY.xml | 2 +- modules/org.openbravo.userinterface.selector/src-db/database/sourcedata/AD_MODULE.xml | 2 +- modules/org.openbravo.userinterface.selector/src-db/database/sourcedata/AD_MODULE_DEPENDENCY.xml | 12 +- modules/org.openbravo.userinterface.skin.250to300Comp/src-db/database/sourcedata/AD_MODULE.xml | 2 +- modules/org.openbravo.userinterface.skin.250to300Comp/src-db/database/sourcedata/AD_MODULE_DEPENDENCY.xml | 2 +- modules/org.openbravo.userinterface.smartclient/src-db/database/sourcedata/AD_MODULE.xml | 2 +- modules/org.openbravo.userinterface.smartclient/src-db/database/sourcedata/AD_MODULE_DEPENDENCY.xml | 6 +- modules/org.openbravo.userinterface.smartclient/web/org.openbravo.userinterface.smartclient/isomorphic/ISC_Combined.js | 2 +- modules/org.openbravo.utility.cleanup.log/src-db/database/sourcedata/AD_MODULE.xml | 2 +- modules/org.openbravo.utility.cleanup.log/src-db/database/sourcedata/AD_MODULE_DEPENDENCY.xml | 2 +- modules/org.openbravo.v3.datasets/src-db/database/sourcedata/AD_MODULE.xml | 2 +- modules/org.openbravo.v3.datasets/src-db/database/sourcedata/AD_MODULE_DEPENDENCY.xml | 6 +- modules/org.openbravo.v3.framework/src-db/database/sourcedata/AD_MODULE.xml | 2 +- modules/org.openbravo.v3.framework/src-db/database/sourcedata/AD_MODULE_DEPENDENCY.xml | 24 +- modules/org.openbravo.v3/src-db/database/sourcedata/AD_MODULE.xml | 2 +- modules/org.openbravo.v3/src-db/database/sourcedata/AD_MODULE_DEPENDENCY.xml | 22 +- referencedata/sampledata/QA_Testing/AD_SEQUENCE.xml | 20 + referencedata/sampledata/QA_Testing/AD_USER.xml | 4 +- referencedata/sampledata/QA_Testing/AD_WINDOW_ACCESS.xml | 168 ++ referencedata/sampledata/QA_Testing/C_BPARTNER.xml | 74 +- referencedata/sampledata/QA_Testing/FIN_FINANCIAL_ACCOUNT.xml | 7 + referencedata/sampledata/QA_Testing/M_PRODUCT.xml | 52 + referencedata/sampledata/QA_Testing/M_PRODUCTPRICE.xml | 36 + referencedata/sampledata/QA_Testing/M_PRODUCT_ACCT.xml | 34 + referencedata/sampledata/QA_Testing/OBUIAPP_PROCESS_ACCESS.xml | 84 + src-db/database/lib/dbsourcemanager.jar | Bin src-db/database/model/tables/AD_MODULE.xml | 4 - src-db/database/model/tables/AD_MODULE_INSTALL.xml | 4 - src-db/database/model/tables/AD_ROLE.xml | 4 +- src-db/database/model/triggers/AD_MODULE_TRG2.xml | 1 - src-db/database/model/triggers/AD_MODULE_VERSION_TRG.xml | 14 +- src-db/database/model/triggers/AD_ROLE_CHECK_TRG.xml | 6 + src-db/database/model/triggers/AD_ROLE_TRG.xml | 5 +- src-db/database/sourcedata/AD_COLUMN.xml | 85 +- src-db/database/sourcedata/AD_ELEMENT.xml | 16 - src-db/database/sourcedata/AD_FIELD.xml | 31 - src-db/database/sourcedata/AD_MESSAGE.xml | 108 +- src-db/database/sourcedata/AD_MODULE.xml | 2 +- src-db/database/sourcedata/AD_REFERENCE.xml | 13 - src-db/database/sourcedata/AD_REF_LIST.xml | 48 +- src-db/database/sourcedata/AD_TREENODE.xml | 102 +- src-test/src/org/openbravo/test/AllAntTaskTests.java | 2 +- src/org/openbravo/base/secureApp/LoginHandler.java | 31 +- src/org/openbravo/dal/service/DataPoolChecker.java | 144 + src/org/openbravo/dal/service/OBDal.java | 26 +- src/org/openbravo/erpCommon/ad_forms/InstanceManagement.html | 4 +- src/org/openbravo/erpCommon/ad_forms/InstanceManagement.java | 267 ++- src/org/openbravo/erpCommon/ad_forms/InstanceManagement.xml | 4 +- src/org/openbravo/erpCommon/ad_forms/InstanceManagementActivateOnline.xml | 4 +- src/org/openbravo/erpCommon/ad_forms/InstancePurpose.java | 6 +- src/org/openbravo/erpCommon/ad_process/HeartbeatProcess.java | 8 +- src/org/openbravo/erpCommon/businessUtility/InitialSetupUtility.java | 4 +- src/org/openbravo/erpCommon/obps/ActivationKey.java | 371 +--- src/org/openbravo/erpCommon/obps/ActiveInstanceProcess.java | 8 +- src/org/openbravo/erpCommon/utility/PrintJR.java | 10 +- src/org/openbravo/service/system/DatabaseValidator.java | 3 +- 110 files changed, 2722 insertions(+), 1091 deletions(-) diffs (truncated from 6847 to 300 lines): diff -r 10bad01a186a -r 8317f2f73d00 config/Openbravo.properties.template --- a/config/Openbravo.properties.template Wed May 30 14:45:14 2018 +0000 +++ b/config/Openbravo.properties.template Tue Jun 05 15:14:32 2018 +0000 @@ -201,9 +201,6 @@ login.trial.delay.max=3 login.trial.user.lock=0 -# Prevents concurrent sessions for same user. -login.limit.user.session=false - ########## # Others # ########## diff -r 10bad01a186a -r 8317f2f73d00 modules/org.openbravo.advpaymentmngt/src-db/database/sourcedata/AD_MODULE.xml --- a/modules/org.openbravo.advpaymentmngt/src-db/database/sourcedata/AD_MODULE.xml Wed May 30 14:45:14 2018 +0000 +++ b/modules/org.openbravo.advpaymentmngt/src-db/database/sourcedata/AD_MODULE.xml Tue Jun 05 15:14:32 2018 +0000 @@ -6,7 +6,7 @@ <!--A918E3331C404B889D69AA9BFAFB23AC--> <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID> <!--A918E3331C404B889D69AA9BFAFB23AC--> <ISACTIVE><![CDATA[Y]]></ISACTIVE> <!--A918E3331C404B889D69AA9BFAFB23AC--> <NAME><![CDATA[Advanced Payables and Receivables Mngmt]]></NAME> -<!--A918E3331C404B889D69AA9BFAFB23AC--> <VERSION><![CDATA[3.0.34107]]></VERSION> +<!--A918E3331C404B889D69AA9BFAFB23AC--> <VERSION><![CDATA[3.0.34166]]></VERSION> <!--A918E3331C404B889D69AA9BFAFB23AC--> <DESCRIPTION><![CDATA[Managing your finances with an ERP does not have to be difficult. Enjoy a radically improved user experience that combines the power of an enterprise grade financial application with the simplicity and ease of a web 2.0 personal accounting service.]]></DESCRIPTION> <!--A918E3331C404B889D69AA9BFAFB23AC--> <HELP><![CDATA[Advanced Payables and Receivables Management simplifies and automates the business processes around the management of financial accounts, from the receipt and issue of payment, to the reconciliation of those events with bank statements. If you would like to help shape this module you are welcome to take part in the forum discussions or register feature requests or issues in the corresponding (Forum and Bug Tracking) sections in the Advanced Payables and Receivable project in the OB Forge.]]></HELP> diff -r 10bad01a186a -r 8317f2f73d00 modules/org.openbravo.advpaymentmngt/src-db/database/sourcedata/AD_MODULE_DEPENDENCY.xml --- a/modules/org.openbravo.advpaymentmngt/src-db/database/sourcedata/AD_MODULE_DEPENDENCY.xml Wed May 30 14:45:14 2018 +0000 +++ b/modules/org.openbravo.advpaymentmngt/src-db/database/sourcedata/AD_MODULE_DEPENDENCY.xml Tue Jun 05 15:14:32 2018 +0000 @@ -7,7 +7,7 @@ <!--89326AE95DAD449D85DFAB2C5B1C6683--> <ISACTIVE><![CDATA[Y]]></ISACTIVE> <!--89326AE95DAD449D85DFAB2C5B1C6683--> <AD_MODULE_ID><![CDATA[A918E3331C404B889D69AA9BFAFB23AC]]></AD_MODULE_ID> <!--89326AE95DAD449D85DFAB2C5B1C6683--> <AD_DEPENDENT_MODULE_ID><![CDATA[5EB4F15C80684ACA904756BDC12ADBE5]]></AD_DEPENDENT_MODULE_ID> -<!--89326AE95DAD449D85DFAB2C5B1C6683--> <STARTVERSION><![CDATA[2.1.34107]]></STARTVERSION> +<!--89326AE95DAD449D85DFAB2C5B1C6683--> <STARTVERSION><![CDATA[2.1.34166]]></STARTVERSION> <!--89326AE95DAD449D85DFAB2C5B1C6683--> <ISINCLUDED><![CDATA[N]]></ISINCLUDED> <!--89326AE95DAD449D85DFAB2C5B1C6683--> <DEPENDANT_MODULE_NAME><![CDATA[User Interface Selector]]></DEPENDANT_MODULE_NAME> <!--89326AE95DAD449D85DFAB2C5B1C6683--> <DEPENDENCY_ENFORCEMENT><![CDATA[MAJOR]]></DEPENDENCY_ENFORCEMENT> @@ -21,7 +21,7 @@ <!--B97FC854C6DD41E692161585645A900F--> <ISACTIVE><![CDATA[Y]]></ISACTIVE> <!--B97FC854C6DD41E692161585645A900F--> <AD_MODULE_ID><![CDATA[A918E3331C404B889D69AA9BFAFB23AC]]></AD_MODULE_ID> <!--B97FC854C6DD41E692161585645A900F--> <AD_DEPENDENT_MODULE_ID><![CDATA[0]]></AD_DEPENDENT_MODULE_ID> -<!--B97FC854C6DD41E692161585645A900F--> <STARTVERSION><![CDATA[3.0.34107]]></STARTVERSION> +<!--B97FC854C6DD41E692161585645A900F--> <STARTVERSION><![CDATA[3.0.34166]]></STARTVERSION> <!--B97FC854C6DD41E692161585645A900F--> <ISINCLUDED><![CDATA[N]]></ISINCLUDED> <!--B97FC854C6DD41E692161585645A900F--> <DEPENDANT_MODULE_NAME><![CDATA[core]]></DEPENDANT_MODULE_NAME> <!--B97FC854C6DD41E692161585645A900F--> <DEPENDENCY_ENFORCEMENT><![CDATA[MAJOR]]></DEPENDENCY_ENFORCEMENT> diff -r 10bad01a186a -r 8317f2f73d00 modules/org.openbravo.apachejdbcconnectionpool/src-db/database/sourcedata/AD_MODULE.xml --- a/modules/org.openbravo.apachejdbcconnectionpool/src-db/database/sourcedata/AD_MODULE.xml Wed May 30 14:45:14 2018 +0000 +++ b/modules/org.openbravo.apachejdbcconnectionpool/src-db/database/sourcedata/AD_MODULE.xml Tue Jun 05 15:14:32 2018 +0000 @@ -6,7 +6,7 @@ <!--8A098711BB324335A19833286BDB093D--> <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID> <!--8A098711BB324335A19833286BDB093D--> <ISACTIVE><![CDATA[Y]]></ISACTIVE> <!--8A098711BB324335A19833286BDB093D--> <NAME><![CDATA[Apache External Connection Pool]]></NAME> -<!--8A098711BB324335A19833286BDB093D--> <VERSION><![CDATA[1.0.34107]]></VERSION> +<!--8A098711BB324335A19833286BDB093D--> <VERSION><![CDATA[1.0.34166]]></VERSION> <!--8A098711BB324335A19833286BDB093D--> <DESCRIPTION><![CDATA[Apache External Connection Pool]]></DESCRIPTION> <!--8A098711BB324335A19833286BDB093D--> <HELP><![CDATA[This module implements the Apache JDBC Connection Pool (http://wiki.openbravo.com/wiki/Modules:Apache_JDBC_Connection_Pool).]]></HELP> <!--8A098711BB324335A19833286BDB093D--> <TYPE><![CDATA[M]]></TYPE> diff -r 10bad01a186a -r 8317f2f73d00 modules/org.openbravo.apachejdbcconnectionpool/src-db/database/sourcedata/AD_MODULE_DEPENDENCY.xml --- a/modules/org.openbravo.apachejdbcconnectionpool/src-db/database/sourcedata/AD_MODULE_DEPENDENCY.xml Wed May 30 14:45:14 2018 +0000 +++ b/modules/org.openbravo.apachejdbcconnectionpool/src-db/database/sourcedata/AD_MODULE_DEPENDENCY.xml Tue Jun 05 15:14:32 2018 +0000 @@ -7,7 +7,7 @@ <!--1467C397BC5F4999A5606F39CD6FF8A4--> <ISACTIVE><![CDATA[Y]]></ISACTIVE> <!--1467C397BC5F4999A5606F39CD6FF8A4--> <AD_MODULE_ID><![CDATA[8A098711BB324335A19833286BDB093D]]></AD_MODULE_ID> <!--1467C397BC5F4999A5606F39CD6FF8A4--> <AD_DEPENDENT_MODULE_ID><![CDATA[7E48CDD73B7E493A8BED4F7253E7C989]]></AD_DEPENDENT_MODULE_ID> -<!--1467C397BC5F4999A5606F39CD6FF8A4--> <STARTVERSION><![CDATA[2.1.34107]]></STARTVERSION> +<!--1467C397BC5F4999A5606F39CD6FF8A4--> <STARTVERSION><![CDATA[2.1.34166]]></STARTVERSION> <!--1467C397BC5F4999A5606F39CD6FF8A4--> <ISINCLUDED><![CDATA[N]]></ISINCLUDED> <!--1467C397BC5F4999A5606F39CD6FF8A4--> <DEPENDANT_MODULE_NAME><![CDATA[Openbravo 3.0 Framework]]></DEPENDANT_MODULE_NAME> <!--1467C397BC5F4999A5606F39CD6FF8A4--> <DEPENDENCY_ENFORCEMENT><![CDATA[MAJOR]]></DEPENDENCY_ENFORCEMENT> diff -r 10bad01a186a -r 8317f2f73d00 modules/org.openbravo.base.weld/src-db/database/sourcedata/AD_MODULE.xml --- a/modules/org.openbravo.base.weld/src-db/database/sourcedata/AD_MODULE.xml Wed May 30 14:45:14 2018 +0000 +++ b/modules/org.openbravo.base.weld/src-db/database/sourcedata/AD_MODULE.xml Tue Jun 05 15:14:32 2018 +0000 @@ -6,7 +6,7 @@ <!--C70732EA90A14EC0916078B85CC33D2D--> <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID> <!--C70732EA90A14EC0916078B85CC33D2D--> <ISACTIVE><![CDATA[Y]]></ISACTIVE> <!--C70732EA90A14EC0916078B85CC33D2D--> <NAME><![CDATA[JBoss Weld]]></NAME> -<!--C70732EA90A14EC0916078B85CC33D2D--> <VERSION><![CDATA[1.1.34107]]></VERSION> +<!--C70732EA90A14EC0916078B85CC33D2D--> <VERSION><![CDATA[1.1.34166]]></VERSION> <!--C70732EA90A14EC0916078B85CC33D2D--> <DESCRIPTION><![CDATA[JBoss Weld]]></DESCRIPTION> <!--C70732EA90A14EC0916078B85CC33D2D--> <HELP><![CDATA[Provides the JBoss Weld framework: Java Contexts and Dependency Injection for the Java EE platform (CDI). For more information see http://seamframework.org/Weld]]></HELP> <!--C70732EA90A14EC0916078B85CC33D2D--> <URL><![CDATA[http://forge.openbravo.com/projects/weld]]></URL> diff -r 10bad01a186a -r 8317f2f73d00 modules/org.openbravo.base.weld/src-db/database/sourcedata/AD_MODULE_DEPENDENCY.xml --- a/modules/org.openbravo.base.weld/src-db/database/sourcedata/AD_MODULE_DEPENDENCY.xml Wed May 30 14:45:14 2018 +0000 +++ b/modules/org.openbravo.base.weld/src-db/database/sourcedata/AD_MODULE_DEPENDENCY.xml Tue Jun 05 15:14:32 2018 +0000 @@ -7,7 +7,7 @@ <!--8BDE81545C1A43EAAC4BA3C5ED754DC8--> <ISACTIVE><![CDATA[Y]]></ISACTIVE> <!--8BDE81545C1A43EAAC4BA3C5ED754DC8--> <AD_MODULE_ID><![CDATA[C70732EA90A14EC0916078B85CC33D2D]]></AD_MODULE_ID> <!--8BDE81545C1A43EAAC4BA3C5ED754DC8--> <AD_DEPENDENT_MODULE_ID><![CDATA[0]]></AD_DEPENDENT_MODULE_ID> -<!--8BDE81545C1A43EAAC4BA3C5ED754DC8--> <STARTVERSION><![CDATA[3.0.34107]]></STARTVERSION> +<!--8BDE81545C1A43EAAC4BA3C5ED754DC8--> <STARTVERSION><![CDATA[3.0.34166]]></STARTVERSION> <!--8BDE81545C1A43EAAC4BA3C5ED754DC8--> <ISINCLUDED><![CDATA[N]]></ISINCLUDED> <!--8BDE81545C1A43EAAC4BA3C5ED754DC8--> <DEPENDANT_MODULE_NAME><![CDATA[Core]]></DEPENDANT_MODULE_NAME> <!--8BDE81545C1A43EAAC4BA3C5ED754DC8--> <DEPENDENCY_ENFORCEMENT><![CDATA[MAJOR]]></DEPENDENCY_ENFORCEMENT> diff -r 10bad01a186a -r 8317f2f73d00 modules/org.openbravo.client.application/src-db/database/model/tables/OBUIAPP_DATA_POOL_SEL.xml --- /dev/null Thu Jan 01 00:00:00 1970 +0000 +++ b/modules/org.openbravo.client.application/src-db/database/model/tables/OBUIAPP_DATA_POOL_SEL.xml Tue Jun 05 15:14:32 2018 +0000 @@ -0,0 +1,55 @@ +<?xml version="1.0"?> + <database name="TABLE OBUIAPP_DATA_POOL_SEL"> + <table name="OBUIAPP_DATA_POOL_SEL" primaryKey="OBUIAPP_DPS_KEY"> + <column name="OBUIAPP_DATA_POOL_SEL_ID" primaryKey="true" required="true" type="VARCHAR" size="32" autoIncrement="false"> + <default/> + <onCreateDefault/> + </column> + <column name="AD_CLIENT_ID" primaryKey="false" required="true" type="VARCHAR" size="32" autoIncrement="false"> + <default/> + <onCreateDefault/> + </column> + <column name="AD_ORG_ID" primaryKey="false" required="true" type="VARCHAR" size="32" autoIncrement="false"> + <default/> + <onCreateDefault/> + </column> + <column name="ISACTIVE" primaryKey="false" required="true" type="CHAR" size="1" autoIncrement="false"> + <default><![CDATA[Y]]></default> + <onCreateDefault/> + </column> + <column name="CREATED" primaryKey="false" required="true" type="TIMESTAMP" size="7" autoIncrement="false"> + <default><![CDATA[SYSDATE]]></default> + <onCreateDefault/> + </column> + <column name="CREATEDBY" primaryKey="false" required="true" type="VARCHAR" size="32" autoIncrement="false"> + <default/> + <onCreateDefault/> + </column> + <column name="UPDATED" primaryKey="false" required="true" type="TIMESTAMP" size="7" autoIncrement="false"> + <default><![CDATA[SYSDATE]]></default> + <onCreateDefault/> + </column> + <column name="UPDATEDBY" primaryKey="false" required="true" type="VARCHAR" size="32" autoIncrement="false"> + <default/> + <onCreateDefault/> + </column> + <column name="OBUIAPP_POOL_REPORT_V_ID" primaryKey="false" required="true" type="VARCHAR" size="32" autoIncrement="false"> + <default/> + <onCreateDefault/> + </column> + <column name="DATA_POOL" primaryKey="false" required="true" type="VARCHAR" size="60" autoIncrement="false"> + <default/> + <onCreateDefault/> + </column> + <foreign-key foreignTable="AD_CLIENT" name="OBUIAPP_DPS_CLIENT"> + <reference local="AD_CLIENT_ID" foreign="AD_CLIENT_ID"/> + </foreign-key> + <foreign-key foreignTable="AD_ORG" name="OBUIAPP_DPS_ORG"> + <reference local="AD_ORG_ID" foreign="AD_ORG_ID"/> + </foreign-key> + <index name="OBUIAPP_DPS_REPORT_V_ID_UNIQUE" unique="true"> + <index-column name="OBUIAPP_POOL_REPORT_V_ID"/> + </index> + <check name="OBUIAPP_DPS_ISACTIVE_CHK"><![CDATA[ISACTIVE IN ('Y', 'N')]]></check> + </table> + </database> diff -r 10bad01a186a -r 8317f2f73d00 modules/org.openbravo.client.application/src-db/database/model/views/OBUIAPP_POOL_REPORT_V.xml --- /dev/null Thu Jan 01 00:00:00 1970 +0000 +++ b/modules/org.openbravo.client.application/src-db/database/model/views/OBUIAPP_POOL_REPORT_V.xml Tue Jun 05 15:14:32 2018 +0000 @@ -0,0 +1,4 @@ +<?xml version="1.0"?> + <database name="VIEW OBUIAPP_POOL_REPORT_V"> + <view name="OBUIAPP_POOL_REPORT_V"><![CDATA[SELECT p.ad_process_id AS obuiapp_pool_report_v_id, p.ad_org_id, p.ad_client_id, to_char(p.name) AS name, '165' AS ad_window_id, p.isactive, p.created, p.createdby, p.updated, p.updatedby FROM ad_process p WHERE (p.isreport = 'Y' OR p.isjasper = 'Y') AND NOT (p.ad_process_id IN (SELECT DISTINCT ad_tab.ad_process_id FROM ad_tab WHERE ad_tab.ad_process_id IS NOT NULL)) UNION SELECT p.obuiapp_process_id AS obuiapp_pool_report_v_id, p.ad_org_id, p.ad_client_id, to_char(p.name) AS name, 'FF80818132D7FB620132D8193C0C0043' AS ad_window_id, p.isactive, p.created, p.createdby, p.updated, p.updatedby FROM obuiapp_process p WHERE p.uipattern = 'OBUIAPP_Report']]></view> + </database> diff -r 10bad01a186a -r 8317f2f73d00 modules/org.openbravo.client.application/src-db/database/sourcedata/AD_COLUMN.xml --- a/modules/org.openbravo.client.application/src-db/database/sourcedata/AD_COLUMN.xml Wed May 30 14:45:14 2018 +0000 +++ b/modules/org.openbravo.client.application/src-db/database/sourcedata/AD_COLUMN.xml Tue Jun 05 15:14:32 2018 +0000 @@ -39,6 +39,84 @@ <!--0060401C958644D4AA38E9226FBEE232--> <ALLOWED_CROSS_ORG_LINK><![CDATA[N]]></ALLOWED_CROSS_ORG_LINK> <!--0060401C958644D4AA38E9226FBEE232--></AD_COLUMN> +<!--01028007CFC142A3A45BD2D1809C0538--><AD_COLUMN> +<!--01028007CFC142A3A45BD2D1809C0538--> <AD_COLUMN_ID><![CDATA[01028007CFC142A3A45BD2D1809C0538]]></AD_COLUMN_ID> +<!--01028007CFC142A3A45BD2D1809C0538--> <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID> +<!--01028007CFC142A3A45BD2D1809C0538--> <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID> +<!--01028007CFC142A3A45BD2D1809C0538--> <ISACTIVE><![CDATA[Y]]></ISACTIVE> +<!--01028007CFC142A3A45BD2D1809C0538--> <NAME><![CDATA[Data Pool]]></NAME> +<!--01028007CFC142A3A45BD2D1809C0538--> <DESCRIPTION><![CDATA[Lists all possible database pools which OBDal can use to retrieve data.]]></DESCRIPTION> +<!--01028007CFC142A3A45BD2D1809C0538--> <HELP><![CDATA[Lists all possible database pools which OBDal can use to retrieve data.]]></HELP> +<!--01028007CFC142A3A45BD2D1809C0538--> <COLUMNNAME><![CDATA[Data_Pool]]></COLUMNNAME> +<!--01028007CFC142A3A45BD2D1809C0538--> <AD_TABLE_ID><![CDATA[7C71A0B4544B4E448195E72DDDF0CA5E]]></AD_TABLE_ID> +<!--01028007CFC142A3A45BD2D1809C0538--> <AD_REFERENCE_ID><![CDATA[17]]></AD_REFERENCE_ID> +<!--01028007CFC142A3A45BD2D1809C0538--> <AD_REFERENCE_VALUE_ID><![CDATA[159EBE3F67A6431B842695888C5F1E79]]></AD_REFERENCE_VALUE_ID> +<!--01028007CFC142A3A45BD2D1809C0538--> <FIELDLENGTH><![CDATA[60]]></FIELDLENGTH> +<!--01028007CFC142A3A45BD2D1809C0538--> <DEFAULTVALUE><![CDATA[RO]]></DEFAULTVALUE> +<!--01028007CFC142A3A45BD2D1809C0538--> <ISKEY><![CDATA[N]]></ISKEY> +<!--01028007CFC142A3A45BD2D1809C0538--> <ISPARENT><![CDATA[N]]></ISPARENT> +<!--01028007CFC142A3A45BD2D1809C0538--> <ISMANDATORY><![CDATA[Y]]></ISMANDATORY> +<!--01028007CFC142A3A45BD2D1809C0538--> <ISUPDATEABLE><![CDATA[Y]]></ISUPDATEABLE> +<!--01028007CFC142A3A45BD2D1809C0538--> <ISIDENTIFIER><![CDATA[N]]></ISIDENTIFIER> +<!--01028007CFC142A3A45BD2D1809C0538--> <SEQNO><![CDATA[90]]></SEQNO> +<!--01028007CFC142A3A45BD2D1809C0538--> <ISTRANSLATED><![CDATA[N]]></ISTRANSLATED> +<!--01028007CFC142A3A45BD2D1809C0538--> <ISENCRYPTED><![CDATA[N]]></ISENCRYPTED> +<!--01028007CFC142A3A45BD2D1809C0538--> <ISSELECTIONCOLUMN><![CDATA[N]]></ISSELECTIONCOLUMN> +<!--01028007CFC142A3A45BD2D1809C0538--> <AD_ELEMENT_ID><![CDATA[B86D9D39A3234489A642BA8BCC749835]]></AD_ELEMENT_ID> +<!--01028007CFC142A3A45BD2D1809C0538--> <ISSESSIONATTR><![CDATA[N]]></ISSESSIONATTR> +<!--01028007CFC142A3A45BD2D1809C0538--> <ISSECONDARYKEY><![CDATA[N]]></ISSECONDARYKEY> +<!--01028007CFC142A3A45BD2D1809C0538--> <ISDESENCRYPTABLE><![CDATA[N]]></ISDESENCRYPTABLE> +<!--01028007CFC142A3A45BD2D1809C0538--> <DEVELOPMENTSTATUS><![CDATA[RE]]></DEVELOPMENTSTATUS> +<!--01028007CFC142A3A45BD2D1809C0538--> <AD_MODULE_ID><![CDATA[9BA0836A3CD74EE4AB48753A47211BCC]]></AD_MODULE_ID> +<!--01028007CFC142A3A45BD2D1809C0538--> <POSITION><![CDATA[10]]></POSITION> +<!--01028007CFC142A3A45BD2D1809C0538--> <ISTRANSIENT><![CDATA[N]]></ISTRANSIENT> +<!--01028007CFC142A3A45BD2D1809C0538--> <ISAUTOSAVE><![CDATA[Y]]></ISAUTOSAVE> +<!--01028007CFC142A3A45BD2D1809C0538--> <VALIDATEONNEW><![CDATA[Y]]></VALIDATEONNEW> +<!--01028007CFC142A3A45BD2D1809C0538--> <IMAGESIZEVALUESACTION><![CDATA[N]]></IMAGESIZEVALUESACTION> +<!--01028007CFC142A3A45BD2D1809C0538--> <ISUSEDSEQUENCE><![CDATA[N]]></ISUSEDSEQUENCE> +<!--01028007CFC142A3A45BD2D1809C0538--> <ALLOWSORTING><![CDATA[Y]]></ALLOWSORTING> +<!--01028007CFC142A3A45BD2D1809C0538--> <ALLOWFILTERING><![CDATA[Y]]></ALLOWFILTERING> +<!--01028007CFC142A3A45BD2D1809C0538--> <ALLOWED_CROSS_ORG_LINK><![CDATA[N]]></ALLOWED_CROSS_ORG_LINK> +<!--01028007CFC142A3A45BD2D1809C0538--></AD_COLUMN> + +<!--010847596B1A4654A673BBA86A27D4B3--><AD_COLUMN> +<!--010847596B1A4654A673BBA86A27D4B3--> <AD_COLUMN_ID><![CDATA[010847596B1A4654A673BBA86A27D4B3]]></AD_COLUMN_ID> +<!--010847596B1A4654A673BBA86A27D4B3--> <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID> +<!--010847596B1A4654A673BBA86A27D4B3--> <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID> +<!--010847596B1A4654A673BBA86A27D4B3--> <ISACTIVE><![CDATA[Y]]></ISACTIVE> +<!--010847596B1A4654A673BBA86A27D4B3--> <NAME><![CDATA[Obuiapp_Data_Pool_Sel_ID]]></NAME> +<!--010847596B1A4654A673BBA86A27D4B3--> <DESCRIPTION><![CDATA[Data pool selection for Reports]]></DESCRIPTION> +<!--010847596B1A4654A673BBA86A27D4B3--> <HELP><![CDATA[Holds the relationship between a report and the database pool where its data will be fetched.]]></HELP> +<!--010847596B1A4654A673BBA86A27D4B3--> <COLUMNNAME><![CDATA[Obuiapp_Data_Pool_Sel_ID]]></COLUMNNAME> +<!--010847596B1A4654A673BBA86A27D4B3--> <AD_TABLE_ID><![CDATA[7C71A0B4544B4E448195E72DDDF0CA5E]]></AD_TABLE_ID> +<!--010847596B1A4654A673BBA86A27D4B3--> <AD_REFERENCE_ID><![CDATA[13]]></AD_REFERENCE_ID> +<!--010847596B1A4654A673BBA86A27D4B3--> <FIELDLENGTH><![CDATA[32]]></FIELDLENGTH> +<!--010847596B1A4654A673BBA86A27D4B3--> <ISKEY><![CDATA[Y]]></ISKEY> +<!--010847596B1A4654A673BBA86A27D4B3--> <ISPARENT><![CDATA[N]]></ISPARENT> +<!--010847596B1A4654A673BBA86A27D4B3--> <ISMANDATORY><![CDATA[Y]]></ISMANDATORY> +<!--010847596B1A4654A673BBA86A27D4B3--> <ISUPDATEABLE><![CDATA[N]]></ISUPDATEABLE> +<!--010847596B1A4654A673BBA86A27D4B3--> <ISIDENTIFIER><![CDATA[N]]></ISIDENTIFIER> +<!--010847596B1A4654A673BBA86A27D4B3--> <SEQNO><![CDATA[10]]></SEQNO> +<!--010847596B1A4654A673BBA86A27D4B3--> <ISTRANSLATED><![CDATA[N]]></ISTRANSLATED> +<!--010847596B1A4654A673BBA86A27D4B3--> <ISENCRYPTED><![CDATA[N]]></ISENCRYPTED> +<!--010847596B1A4654A673BBA86A27D4B3--> <ISSELECTIONCOLUMN><![CDATA[N]]></ISSELECTIONCOLUMN> +<!--010847596B1A4654A673BBA86A27D4B3--> <AD_ELEMENT_ID><![CDATA[3303E3F5D9714BFB81B967BAFD6AE5C9]]></AD_ELEMENT_ID> +<!--010847596B1A4654A673BBA86A27D4B3--> <ISSESSIONATTR><![CDATA[N]]></ISSESSIONATTR> +<!--010847596B1A4654A673BBA86A27D4B3--> <ISSECONDARYKEY><![CDATA[N]]></ISSECONDARYKEY> +<!--010847596B1A4654A673BBA86A27D4B3--> <ISDESENCRYPTABLE><![CDATA[N]]></ISDESENCRYPTABLE> +<!--010847596B1A4654A673BBA86A27D4B3--> <DEVELOPMENTSTATUS><![CDATA[RE]]></DEVELOPMENTSTATUS> +<!--010847596B1A4654A673BBA86A27D4B3--> <AD_MODULE_ID><![CDATA[9BA0836A3CD74EE4AB48753A47211BCC]]></AD_MODULE_ID> +<!--010847596B1A4654A673BBA86A27D4B3--> <POSITION><![CDATA[1]]></POSITION> +<!--010847596B1A4654A673BBA86A27D4B3--> <ISTRANSIENT><![CDATA[N]]></ISTRANSIENT> +<!--010847596B1A4654A673BBA86A27D4B3--> <ISAUTOSAVE><![CDATA[Y]]></ISAUTOSAVE> +<!--010847596B1A4654A673BBA86A27D4B3--> <VALIDATEONNEW><![CDATA[Y]]></VALIDATEONNEW> +<!--010847596B1A4654A673BBA86A27D4B3--> <IMAGESIZEVALUESACTION><![CDATA[N]]></IMAGESIZEVALUESACTION> +<!--010847596B1A4654A673BBA86A27D4B3--> <ISUSEDSEQUENCE><![CDATA[N]]></ISUSEDSEQUENCE> +<!--010847596B1A4654A673BBA86A27D4B3--> <ALLOWSORTING><![CDATA[Y]]></ALLOWSORTING> +<!--010847596B1A4654A673BBA86A27D4B3--> <ALLOWFILTERING><![CDATA[Y]]></ALLOWFILTERING> +<!--010847596B1A4654A673BBA86A27D4B3--> <ALLOWED_CROSS_ORG_LINK><![CDATA[N]]></ALLOWED_CROSS_ORG_LINK> +<!--010847596B1A4654A673BBA86A27D4B3--></AD_COLUMN> + <!--018328092C15478F8E3F523E43172748--><AD_COLUMN> <!--018328092C15478F8E3F523E43172748--> <AD_COLUMN_ID><![CDATA[018328092C15478F8E3F523E43172748]]></AD_COLUMN_ID> <!--018328092C15478F8E3F523E43172748--> <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID> @@ -346,6 +424,44 @@ <!--0785044C8E2F41AA9F8999360F70837D--> <ALLOWED_CROSS_ORG_LINK><![CDATA[N]]></ALLOWED_CROSS_ORG_LINK> <!--0785044C8E2F41AA9F8999360F70837D--></AD_COLUMN> +<!--081CE45046ED42CC811ED604ABD64CD4--><AD_COLUMN> +<!--081CE45046ED42CC811ED604ABD64CD4--> <AD_COLUMN_ID><![CDATA[081CE45046ED42CC811ED604ABD64CD4]]></AD_COLUMN_ID> +<!--081CE45046ED42CC811ED604ABD64CD4--> <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID> +<!--081CE45046ED42CC811ED604ABD64CD4--> <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID> +<!--081CE45046ED42CC811ED604ABD64CD4--> <ISACTIVE><![CDATA[Y]]></ISACTIVE> +<!--081CE45046ED42CC811ED604ABD64CD4--> <NAME><![CDATA[Updated By]]></NAME> +<!--081CE45046ED42CC811ED604ABD64CD4--> <DESCRIPTION><![CDATA[User who updated this records]]></DESCRIPTION> +<!--081CE45046ED42CC811ED604ABD64CD4--> <HELP><![CDATA[The Updated By field indicates the user who updated this record.]]></HELP> +<!--081CE45046ED42CC811ED604ABD64CD4--> <COLUMNNAME><![CDATA[Updatedby]]></COLUMNNAME> +<!--081CE45046ED42CC811ED604ABD64CD4--> <AD_TABLE_ID><![CDATA[C41826412A134A488D94C84EB8C6EE81]]></AD_TABLE_ID> +<!--081CE45046ED42CC811ED604ABD64CD4--> <AD_REFERENCE_ID><![CDATA[30]]></AD_REFERENCE_ID> +<!--081CE45046ED42CC811ED604ABD64CD4--> <FIELDLENGTH><![CDATA[32]]></FIELDLENGTH> +<!--081CE45046ED42CC811ED604ABD64CD4--> <ISKEY><![CDATA[N]]></ISKEY> +<!--081CE45046ED42CC811ED604ABD64CD4--> <ISPARENT><![CDATA[N]]></ISPARENT> +<!--081CE45046ED42CC811ED604ABD64CD4--> <ISMANDATORY><![CDATA[N]]></ISMANDATORY> +<!--081CE45046ED42CC811ED604ABD64CD4--> <ISUPDATEABLE><![CDATA[N]]></ISUPDATEABLE> +<!--081CE45046ED42CC811ED604ABD64CD4--> <ISIDENTIFIER><![CDATA[N]]></ISIDENTIFIER> +<!--081CE45046ED42CC811ED604ABD64CD4--> <SEQNO><![CDATA[90]]></SEQNO> +<!--081CE45046ED42CC811ED604ABD64CD4--> <ISTRANSLATED><![CDATA[N]]></ISTRANSLATED> +<!--081CE45046ED42CC811ED604ABD64CD4--> <ISENCRYPTED><![CDATA[N]]></ISENCRYPTED> +<!--081CE45046ED42CC811ED604ABD64CD4--> <ISSELECTIONCOLUMN><![CDATA[N]]></ISSELECTIONCOLUMN> +<!--081CE45046ED42CC811ED604ABD64CD4--> <AD_ELEMENT_ID><![CDATA[608]]></AD_ELEMENT_ID> +<!--081CE45046ED42CC811ED604ABD64CD4--> <ISSESSIONATTR><![CDATA[N]]></ISSESSIONATTR> +<!--081CE45046ED42CC811ED604ABD64CD4--> <ISSECONDARYKEY><![CDATA[N]]></ISSECONDARYKEY> +<!--081CE45046ED42CC811ED604ABD64CD4--> <ISDESENCRYPTABLE><![CDATA[N]]></ISDESENCRYPTABLE> +<!--081CE45046ED42CC811ED604ABD64CD4--> <DEVELOPMENTSTATUS><![CDATA[RE]]></DEVELOPMENTSTATUS> +<!--081CE45046ED42CC811ED604ABD64CD4--> <AD_MODULE_ID><![CDATA[9BA0836A3CD74EE4AB48753A47211BCC]]></AD_MODULE_ID> +<!--081CE45046ED42CC811ED604ABD64CD4--> <POSITION><![CDATA[10]]></POSITION> +<!--081CE45046ED42CC811ED604ABD64CD4--> <ISTRANSIENT><![CDATA[N]]></ISTRANSIENT> +<!--081CE45046ED42CC811ED604ABD64CD4--> <ISAUTOSAVE><![CDATA[Y]]></ISAUTOSAVE> +<!--081CE45046ED42CC811ED604ABD64CD4--> <VALIDATEONNEW><![CDATA[Y]]></VALIDATEONNEW> +<!--081CE45046ED42CC811ED604ABD64CD4--> <IMAGESIZEVALUESACTION><![CDATA[N]]></IMAGESIZEVALUESACTION> +<!--081CE45046ED42CC811ED604ABD64CD4--> <ISUSEDSEQUENCE><![CDATA[N]]></ISUSEDSEQUENCE> +<!--081CE45046ED42CC811ED604ABD64CD4--> <ALLOWSORTING><![CDATA[Y]]></ALLOWSORTING> +<!--081CE45046ED42CC811ED604ABD64CD4--> <ALLOWFILTERING><![CDATA[Y]]></ALLOWFILTERING> +<!--081CE45046ED42CC811ED604ABD64CD4--> <ALLOWED_CROSS_ORG_LINK><![CDATA[N]]></ALLOWED_CROSS_ORG_LINK> +<!--081CE45046ED42CC811ED604ABD64CD4--></AD_COLUMN> + <!--08AF323AC6B566ADE050007F0100548B--><AD_COLUMN> <!--08AF323AC6B566ADE050007F0100548B--> <AD_COLUMN_ID><![CDATA[08AF323AC6B566ADE050007F0100548B]]></AD_COLUMN_ID> <!--08AF323AC6B566ADE050007F0100548B--> <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID> @@ -845,6 +961,44 @@ <!--0933E14B5EC040F7AABAF84468E1BA92--> <ALLOWED_CROSS_ORG_LINK><![CDATA[N]]></ALLOWED_CROSS_ORG_LINK> <!--0933E14B5EC040F7AABAF84468E1BA92--></AD_COLUMN> +<!--09A37827B9BC4CDC93DB8C99A055C60C--><AD_COLUMN> +<!--09A37827B9BC4CDC93DB8C99A055C60C--> <AD_COLUMN_ID><![CDATA[09A37827B9BC4CDC93DB8C99A055C60C]]></AD_COLUMN_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
