Anonymous | Login
Project:
RSS
  
News | My View | View Issues | Roadmap | Summary

View Issue DetailsJump to Notes ] Issue History ] Print ]
ID
0031315
TypeCategorySeverityReproducibilityDate SubmittedLast Update
design defect[Openbravo ERP] A. Platformmajoralways2015-10-30 13:522022-02-01 08:09
ReportercaristuView Statuspublic 
Assigned ToTriage Platform Base 
PriorityhighResolutionopenFixed in Version
StatusacknowledgedFix in branchFixed in SCM revision
ProjectionnoneETAnoneTarget Version
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product VersionSCM revision 
Review Assigned To
Web browser
ModulesCore
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0031315: 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"}
TagsNo tags attached.
Attached Files

- Relationships Relation Graph ] Dependency Graph ]
related to defect 0030800 closedcaristu Filter on Property field in a table reference column doesn't work 
related to defect 0018557 closedmtaal Filter Expression: comparing to other field (column) values 
related to feature request 0031616 acknowledgedTriage Platform Base Remove incomplete code regarding equals other column operator 

-  Notes
(0082428)
caristu (developer)
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 [^]

- Issue History
Date Modified Username Field Change
2015-10-30 13:52 caristu New Issue
2015-10-30 13:52 caristu Assigned To => platform
2015-10-30 13:52 caristu Modules => Core
2015-10-30 13:52 caristu Triggers an Emergency Pack => No
2015-10-30 13:53 caristu Relationship added related to 0030800
2015-11-04 09:12 alostale Status new => acknowledged
2015-11-11 11:34 alostale Priority normal => high
2015-11-13 09:48 caristu Assigned To platform => caristu
2015-11-20 15:45 caristu Status acknowledged => scheduled
2015-11-27 13:22 caristu Relationship added related to 0018557
2015-11-27 13:32 caristu Note Added: 0082428
2015-11-27 13:33 caristu Type defect => design defect
2015-11-27 13:36 caristu Relationship added related to 0031616
2015-11-27 14:00 caristu Assigned To caristu => platform
2015-11-27 14:00 caristu Status scheduled => acknowledged
2022-02-01 08:09 alostale Assigned To platform => Triage Platform Base


Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker