Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0031315Openbravo ERPA. Platformpublic2015-10-30 13:522022-02-01 08:09
Reportercaristu 
Assigned ToTriage Platform Base 
PriorityhighSeveritymajorReproducibilityalways
StatusacknowledgedResolutionopen 
PlatformOS5OS Version
Product Version 
Target VersionFixed in Version 
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
Summary0031315: Equals other column filter is not working
DescriptionIs not possible to filter the grid using the "equals other column" operator[1]. Also, is not specified for which type of columns (reference type) this operator can be used.

[1] http://wiki.openbravo.com/wiki/User_Interface_Introduction#Column_Filters [^]
Steps To Reproduce1) Go to the [Sales Invoice] window
2) Use the following expression for the "Amount Currently Due": =.outstandingAmount

This should show the records with the same value in the "Amount Currently Due" and "Total Outstanding" amount. But the following error appears instead: "Invalid filter value =.outstandingAmount"

Notice that in the request the "equals" operator is sent. This is incorrect:

criteria:{"fieldName":"dueAmount","operator":"equals","value":"=.outstandingAmount","_constructor":"AdvancedCriteria"}
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
related to defect 0030800 closed caristu Filter on Property field in a table reference column doesn't work 
related to defect 0018557 closed mtaal Filter Expression: comparing to other field (column) values 
related to feature request 0031616 acknowledged Triage Platform Base Remove incomplete code regarding equals other column operator 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2015-10-30 13:52caristuNew Issue
2015-10-30 13:52caristuAssigned To => platform
2015-10-30 13:52caristuOBNetwork customer => No
2015-10-30 13:52caristuModules => Core
2015-10-30 13:52caristuTriggers an Emergency Pack => No
2015-10-30 13:53caristuRelationship addedrelated to 0030800
2015-11-04 09:12alostaleStatusnew => acknowledged
2015-11-11 11:34alostalePrioritynormal => high
2015-11-13 09:48caristuAssigned Toplatform => caristu
2015-11-20 15:45caristuStatusacknowledged => scheduled
2015-11-27 13:22caristuRelationship addedrelated to 0018557
2015-11-27 13:32caristuNote Added: 0082428
2015-11-27 13:33caristuTypedefect => design defect
2015-11-27 13:36caristuRelationship addedrelated to 0031616
2015-11-27 14:00caristuAssigned Tocaristu => platform
2015-11-27 14:00caristuStatusscheduled => acknowledged
2022-02-01 08:09alostaleAssigned Toplatform => Triage Platform Base

Notes
(0082428)
caristu   
2015-11-27 13:32   
Moved to design defect, it is needed a complete design to fully support this feature including the exact behavior of this operator when comparing fields with different references.

In addition, there are several types of filtering that never worked, even after fixing issue 0018557:

- Date reference comparison
- List reference comparison
- String with number comparison
- There is not a defined behavior when comparing foreign key fields

The documentation[1] has been updated to avoid possible missunderstanding.

[1] http://wiki.openbravo.com/wiki/User_Interface_Introduction#Column_Filters [^]