Thu, 12 Mar 2015 10:39:35 +0100Fixes issue 29092: Inconsistent data is not shown in the form view
Augusto Mauch <augusto.mauch@openbravo.com> [Thu, 12 Mar 2015 10:39:35 +0100] rev 26167
Fixes issue 29092: Inconsistent data is not shown in the form view

This issue was reproduced in the following scenario:
- A subtab is open in form view
- A change is done in its parent tab. That change (either through an event handler or through a trigger) deletes the record selected in the subtab and creates a new one
- The subtab is automatically refreshed. When the tab is refreshed:
* The whole grid is reloaded, it now contains all the current records
* The form view is shown again, and it tries to obtain the updated records from the grid. As the record selected in the form view is not present in the grid, the form view contains the old values

To fix this, when the record that was selected in the form view is no longer contained in the grid after the tab is refreshed, the form view is not shown. This was the grid view will be visible, and it will show the updated info.

Thu, 12 Mar 2015 15:48:01 +0000CI: update AD_MODULE to version 26165
RM packaging bot <staff.rm@openbravo.com> [Thu, 12 Mar 2015 15:48:01 +0000] rev 26166
CI: update AD_MODULE to version 26165

Wed, 11 Mar 2015 13:23:31 +0100Related to issue 29110: Added a clear inside the loop
Alvaro Ferraz <alvaro.ferraz@openbravo.com> [Wed, 11 Mar 2015 13:23:31 +0100] rev 26165
Related to issue 29110: Added a clear inside the loop

Added a clear inside the loop to avoid performance problems

Wed, 11 Mar 2015 11:48:22 +0530Fixes Issue 29110:It is not possible to change currency in header tab in G/L
Atul Gaware <atul.gaware@openbravo.com> [Wed, 11 Mar 2015 11:48:22 +0530] rev 26164
Fixes Issue 29110:It is not possible to change currency in header tab in G/L
Journal

As there is trigger mutating error, updation of gl journal line currency and
currency rate is moved to a event handler from gl_journal_trg trigger.

Wed, 11 Mar 2015 15:19:41 +0000CI: merge back from main
RM packaging bot <staff.rm@openbravo.com> [Wed, 11 Mar 2015 15:19:41 +0000] rev 26163
CI: merge back from main

Wed, 11 Mar 2015 13:56:36 +0100Fixes issue 29245: An email related with the alert is sent to inactive users
Javier Etxarri <javier.echarri@openbravo.com> [Wed, 11 Mar 2015 13:56:36 +0100] rev 26162
Fixes issue 29245: An email related with the alert is sent to inactive users

Wed, 11 Mar 2015 10:42:05 +0100Fixed issue 28968: When installing a module the rebuild takes long to start.
Inigo Sanchez <inigo.sanchez@openbravo.com> [Wed, 11 Mar 2015 10:42:05 +0100] rev 26161
Fixed issue 28968: When installing a module the rebuild takes long to start.

The problem was that when installing a module the rebuild takes long to start.
This happened on environments with a lot of rows (Tested with 260.000 rows) on
the ad_session table.The result was this:

explain UPDATE AD_SESSION SET SESSION_ACTIVE='N' WHERE CREATEDBY<>'100'
Update on ad_session (cost=0.00..21546.15 rows=266303 width=147)

-> Seq Scan on ad_session (cost=0.00..21546.15 rows=266303 width=147)
Filter: ((createdby)::text <> '100'::text)
Approx time execution: 30000 ms

The new SQL Query to update is this:

explain UPDATE AD_SESSION SET SESSION_ACTIVE='N' WHERE CREATEDBY<>'100' and SESSION_ACTIVE='Y'
Update on ad_session (cost=0.42..4.44 rows=1 width=147)

-> Index Scan using ad_session_active_idx on ad_session (cost=0.42..4.44 rows=1 width=147)
Index Cond: (session_active = 'Y'::bpchar)
Filter: ((createdby)::text <> '100'::text)
Approx time execution: 30 ms

Adding the new condition "SESSION_ACTIVE = 'Y'" has been achieved to improve the performance.

Wed, 11 Mar 2015 15:01:31 +0000CI: update AD_MODULE to version 26159
RM packaging bot <staff.rm@openbravo.com> [Wed, 11 Mar 2015 15:01:31 +0000] rev 26160
CI: update AD_MODULE to version 26159

Wed, 11 Mar 2015 09:17:00 +0100Related bug 28999: The i index is wrong.
Inigo Sanchez <inigo.sanchez@openbravo.com> [Wed, 11 Mar 2015 09:17:00 +0100] rev 26159
Related bug 28999: The i index is wrong.

Wed, 11 Mar 2015 07:13:25 +0000CI: merge back from main
RM packaging bot <staff.rm@openbravo.com> [Wed, 11 Mar 2015 07:13:25 +0000] rev 26158
CI: merge back from main