Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0005620Openbravo ERPB. User interfacepublic2008-10-22 19:482009-02-23 11:36
Reporterpjuvara 
Assigned Toiperdomo 
PriorityhighSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS20OS VersionUbuntu 8.04
Product Version2.40 
Target VersionFixed in Versionpi 
Merge Request Status
Review Assigned To
OBNetwork customerNo
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0005620: Data grid export fails when audit info is shown
DescriptionWhen audit info is shown in a data grid and you export to Excel, the export fails and the export file is empty, regardless of the data in the grid.
Steps To Reproduce1) Choose Openbravo Admin role
2) Navigate to Business Partner screen
3) Query all business partners
4) Switch the window to grid mode
5) Press Export to Excel => the data in the grid is exported - OK!
6) Press Audit Info => the grid is refreshed and the audit info is shown - OK!
7) Press Export to Excel again => the exported file is 0 bytes in length - FAIL!!
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
depends on backport 0005667 closed iperdomo Data grid export fails when audit info is shown 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2008-10-22 19:48pjuvaraNew Issue
2008-10-22 19:48pjuvaraAssigned To => cromero
2008-10-22 19:48pjuvarasf_bug_id0 => 2187296
2008-10-22 19:48pjuvaraOBNetwork customer => No
2008-10-22 19:48pjuvaraRegression testing => No
2008-10-27 10:10psarobeStatusnew => scheduled
2008-10-27 10:10psarobeAssigned Tocromero => alostale
2008-10-27 10:10psarobefix_in_branch => trunk
2008-10-31 17:55svnbotCheckin
2008-10-31 17:55svnbotNote Added: 0009897
2008-10-31 17:55svnbotStatusscheduled => resolved
2008-10-31 17:55svnbotResolutionopen => fixed
2008-10-31 17:55svnbotsvn_revision => 9531
2008-10-31 17:58svnbotCheckin
2008-10-31 17:58svnbotNote Added: 0009898
2008-10-31 17:58svnbotsvn_revision9531 => 9532
2008-10-31 18:02svnbotCheckin
2008-10-31 18:02svnbotNote Added: 0009899
2008-10-31 18:02svnbotsvn_revision9532 => 9533
2008-10-31 18:04alostaleNote Added: 0009900
2008-11-03 09:28svnbotCheckin
2008-11-03 09:28svnbotNote Added: 0009913
2008-11-03 09:28svnbotsvn_revision9533 => 9550
2008-11-03 09:37svnbotCheckin
2008-11-03 09:37svnbotNote Added: 0009914
2008-11-03 09:37svnbotsvn_revision9550 => 9552
2008-11-03 09:48svnbotCheckin
2008-11-03 09:48svnbotNote Added: 0009915
2008-11-03 09:48svnbotsvn_revision9552 => 9554
2008-11-06 17:19shuehnerStatusresolved => new
2008-11-06 17:19shuehnerResolutionfixed => open
2008-11-06 17:19shuehnerNote Added: 0010050
2008-11-09 20:16psarobeStatusnew => scheduled
2008-11-09 20:16psarobeNote Added: 0010106
2008-12-10 09:50alostaleAssigned Toalostale => iperdomo
2008-12-30 12:42svnbotCheckin
2008-12-30 12:42svnbotNote Added: 0011760
2008-12-30 12:42svnbotStatusscheduled => resolved
2008-12-30 12:42svnbotResolutionopen => fixed
2008-12-30 12:42svnbotsvn_revision9554 => 11609
2008-12-30 12:43svnbotCheckin
2008-12-30 12:43svnbotNote Added: 0011761
2008-12-30 12:43svnbotsvn_revision11609 => 11610
2009-02-23 11:36sureshbabuStatusresolved => closed
2009-02-23 11:36sureshbabuNote Added: 0013908
2009-02-23 11:36sureshbabuFixed in Version => trunk

Notes
(0009897)
svnbot   
2008-10-31 17:55   
Repository: openbravo
Revision: 9531
Author: alostale
Date: 2008-10-31 17:55:34 +0100 (Fri, 31 Oct 2008)

fixed bug 0005620: Don't show all the users in the audit info fields

---
U trunk/src-wad/src/org/openbravo/wad/Fields_data.xsql
U trunk/src-wad/src/org/openbravo/wad/Wad.java
U trunk/src-wad/src/org/openbravo/wad/WadUtility.java
U trunk/src-wad/src/org/openbravo/wad/datasource.xsqlxml
---

https://dev.openbravo.com/websvn/openbravo/?rev=9531&sc=1 [^]
(0009898)
svnbot   
2008-10-31 17:58   
Repository: openbravo
Revision: 9532
Author: alostale
Date: 2008-10-31 17:58:05 +0100 (Fri, 31 Oct 2008)

fixed bug 0005620: Don't show all the users in the audit info fields (db function)

---
U trunk/src-db/database/model/functions/AD_TABLE_IMPORT.xml
---

https://dev.openbravo.com/websvn/openbravo/?rev=9532&sc=1 [^]
(0009899)
svnbot   
2008-10-31 18:02   
Repository: openbravo
Revision: 9533
Author: alostale
Date: 2008-10-31 18:02:17 +0100 (Fri, 31 Oct 2008)

fixed bug 0005620: Don't show all the users in the audit info fields (db data)

---
U trunk/src-db/database/sourcedata/AD_COLUMN.xml
---

https://dev.openbravo.com/websvn/openbravo/?rev=9533&sc=1 [^]
(0009900)
alostale   
2008-10-31 18:04   
To backport this bug:
*merge revisions 9531 and 9532
*for the database data execute
  update ad_column
  set ad_reference_id = '30',
  ad_reference_value_id = null
  where lower(columnname)='updatedby' or lower(columnname)='createdby';
(0009913)
svnbot   
2008-11-03 09:28   
Repository: openbravo
Revision: 9550
Author: alostale
Date: 2008-11-03 09:28:49 +0100 (Mon, 03 Nov 2008)

fixed bug 0005620: Fixed warnings about not found columns when generating windows

---
U trunk/src-wad/src/org/openbravo/wad/WadUtility.java
---

https://dev.openbravo.com/websvn/openbravo/?rev=9550&sc=1 [^]
(0009914)
svnbot   
2008-11-03 09:37   
Repository: openbravo
Revision: 9552
Author: alostale
Date: 2008-11-03 09:37:35 +0100 (Mon, 03 Nov 2008)

fixed bug 0005620: Fixed minor bugs with this issue

---
U trunk/src-wad/src/org/openbravo/wad/Fields_data.xsql
U trunk/src-wad/src/org/openbravo/wad/WadUtility.java
---

https://dev.openbravo.com/websvn/openbravo/?rev=9552&sc=1 [^]
(0009915)
svnbot   
2008-11-03 09:48   
Repository: openbravo
Revision: 9554
Author: huehner
Date: 2008-11-03 09:48:16 +0100 (Mon, 03 Nov 2008)

Issue 5620
add missing 'as' to fix sql statement on postgres

---
U trunk/src-wad/src/org/openbravo/wad/Fields_data.xsql
---

https://dev.openbravo.com/websvn/openbravo/?rev=9554&sc=1 [^]
(0010050)
shuehner   
2008-11-06 17:19   
Reopen, as the commited changes really belonged to 5539 and this issue is still not fixed.
(0010106)
psarobe   
2008-11-09 20:16   
Reminder to engineers: Please write the steps and the issues to verify when the bug is fixed so QA team can check if the fixed is correct
(0011760)
svnbot   
2008-12-30 12:42   
Repository: openbravo
Revision: 11609
Author: iperdomo
Date: 2008-12-30 12:42:40 +0100 (Tue, 30 Dec 2008)

Fixes issue 5667: Fixes issue 5620: Define a name when the column don't have a field associated, prevent a NPE and be able to get a text length

---
U branches/r2.40/src/org/openbravo/erpCommon/utility/TableSQLQuery_data.xsql
---

https://dev.openbravo.com/websvn/openbravo/?rev=11609&sc=1 [^]
(0011761)
svnbot   
2008-12-30 12:43   
Repository: openbravo
Revision: 11610
Author: iperdomo
Date: 2008-12-30 12:43:44 +0100 (Tue, 30 Dec 2008)

Fixes issue 5620: Define a name when the column don't have a field associated, prevent a NPE and be able to get a text length

---
U trunk/src/org/openbravo/erpCommon/utility/TableSQLQuery_data.xsql
---

https://dev.openbravo.com/websvn/openbravo/?rev=11610&sc=1 [^]
(0013908)
sureshbabu   
2009-02-23 11:36   
Retested in context http://79.125.56.185/openbravotrunk [^]