Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0025248Openbravo ERP00. Application dictionarypublic2013-11-28 22:422013-12-22 07:30
Reportercaristu 
Assigned Toalostale 
PriorityimmediateSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target Version3.0MP31Fixed in Version3.0MP31 
Merge Request Status
Review Assigned Toshankarb
OBNetwork customer
Web browser
ModulesCore
Support ticket
Regression levelPre packaging ( pi )
Regression date
Regression introduced in release
Regression introduced by commithttps://code.openbravo.com/erp/devel/pi/rev/67e80e28874b0d93cd69094cec39febc89a03b11 [^]
Triggers an Emergency PackNo
Summary0025248: Error after sorting by a computed column
DescriptionAn error is raised (see attached) if sorting a window using a computed column and after that we click on the funnel icon to remove the filters.
Steps To Reproduce1) Go to the [Sales Order] window
2) Order the header records by Delivery Status (this is a computed column)
3) Click on the funnel icon
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
related to defect 00250413.0MP29 closed marvintm Problem when filtering by a computed column with list reference 
related to defect 00253783.0PR14Q2 closed alostale drop down filter doesn't work in FK property columns 
related to defect 00251823.0PR14Q2 closed alostale Query in org drop down in the list field is having bad performance 
related to defect 0026412 closed alostale Property fields based on computed columns with a FK fail 
Attached Filespng ErrorCC.png (23,541) 2013-11-28 22:47
https://issues.openbravo.com/file_download.php?file_id=6538&type=bug
png

? org.openbravo.check.computedcols-0.0.0.obx (4,704) 2013-12-19 17:08
https://issues.openbravo.com/file_download.php?file_id=6582&type=bug
Issue History
Date ModifiedUsernameFieldChange
2013-11-28 22:42caristuNew Issue
2013-11-28 22:42caristuAssigned To => AugustoMauch
2013-11-28 22:42caristuModules => Core
2013-11-28 22:42caristuTriggers an Emergency Pack => No
2013-11-28 22:47caristuFile Added: ErrorCC.png
2013-11-28 22:47caristuIssue Monitored: networkb
2013-11-28 22:49caristuRegression level => Pre packaging ( pi )
2013-11-28 22:49caristuRegression introduced by commit => https://code.openbravo.com/erp/devel/pi/rev/67e80e28874b0d93cd69094cec39febc89a03b11 [^]
2013-11-28 22:55caristuSteps to Reproduce Updatedbug_revision_view_page.php?rev_id=5225#r5225
2013-12-19 16:56alostaleRelationship addedrelated to 0025041
2013-12-19 16:56alostaleAssigned ToAugustoMauch => alostale
2013-12-19 16:56alostaleTarget Version => 3.0MP31
2013-12-19 17:08alostaleFile Added: org.openbravo.check.computedcols-0.0.0.obx
2013-12-19 17:24alostaleNote Added: 0062879
2013-12-19 17:28alostaleRelationship addedrelated to 0025378
2013-12-19 17:30alostaleRelationship addedrelated to 0025182
2013-12-20 07:41hgbotCheckin
2013-12-20 07:41hgbotNote Added: 0062956
2013-12-20 07:41hgbotCheckin
2013-12-20 07:41hgbotNote Added: 0062957
2013-12-20 07:41hgbotStatusnew => resolved
2013-12-20 07:41hgbotResolutionopen => fixed
2013-12-20 07:41hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/a9326df8fa4a7dc620a9a9e55dcc4173113674da [^]
2013-12-20 07:42alostaleReview Assigned To => shankarb
2013-12-20 17:25hudsonbotCheckin
2013-12-20 17:25hudsonbotNote Added: 0063033
2013-12-20 17:25hudsonbotCheckin
2013-12-20 17:25hudsonbotNote Added: 0063034
2013-12-22 07:30shankarbNote Added: 0063045
2013-12-22 07:30shankarbStatusresolved => closed
2013-12-22 07:30shankarbFixed in Version => 3.0MP31
2014-04-30 15:38alostaleRelationship addedrelated to 0026412

Notes
(0062879)
alostale   
2013-12-19 17:24   
Executed test cases:

-Installed attached module that deploys some additional computed columns in Sales Order
-Open Sales Order window and remove filters to force backend sorting
-Sort by Delivery Status
-Sort by Invoice Status
-Sort by EM_CC_Rule (list reference)
-Sort by EM_CC_BP (FK reference)
-Sort by EM_CC_BPNmae (String reference)
-Filter by Delivery Status
-Filter by Invoice Status
-Filter by EM_CC_Rule (list reference) -> Checking issue 0025041 is not reopened
-Filter by EM_CC_BPNmae (String reference)
-Filter by EM_CC_BP (FK reference)
  -It works by typing in filter text field
  -It fails trying to open drop down list (reported as new issue)
(0062956)
hgbot   
2013-12-20 07:41   
Repository: erp/devel/pi
Changeset: b718b3ee2462bdd381bc76b332a779e3d8ecbe3d
Author: Asier Lostalé <asier.lostale <at> openbravo.com>
Date: Fri Dec 20 07:39:46 2013 +0100
URL: http://code.openbravo.com/erp/devel/pi/rev/b718b3ee2462bdd381bc76b332a779e3d8ecbe3d [^]

related to bug 25248: prevent null values in delivery and invoice status

this causes backend sorting to to work as expected

---
M src-db/database/sourcedata/AD_COLUMN.xml
---
(0062957)
hgbot   
2013-12-20 07:41   
Repository: erp/devel/pi
Changeset: a9326df8fa4a7dc620a9a9e55dcc4173113674da
Author: Asier Lostalé <asier.lostale <at> openbravo.com>
Date: Fri Dec 20 07:40:50 2013 +0100
URL: http://code.openbravo.com/erp/devel/pi/rev/a9326df8fa4a7dc620a9a9e55dcc4173113674da [^]

fixed bug 25248: error when sorting by a computed column

---
M modules/org.openbravo.service.json/src/org/openbravo/service/json/AdvancedQueryBuilder.java
---
(0063033)
hudsonbot   
2013-12-20 17:25   
A changeset related to this issue has been promoted main and to the
Central Repository, after passing a series of tests.

Promotion changeset: https://code.openbravo.com/erp/devel/main/rev/a9326df8fa4a [^]

Maturity status: Test
(0063034)
hudsonbot   
2013-12-20 17:25   
A changeset related to this issue has been promoted main and to the
Central Repository, after passing a series of tests.

Promotion changeset: https://code.openbravo.com/erp/devel/main/rev/a9326df8fa4a [^]

Maturity status: Test
(0063045)
shankarb   
2013-12-22 07:30   
Code reviewed and verified in pi changeset a0194e74f446