Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
0025210Openbravo ERPA. Platformpublic2013-11-25 12:512015-02-24 11:31
alostale 
AugustoMauch 
normalmajoralways
newopen 
5
 
 
Core
No
0025210: Adaptive filtering not working for FK dropdown filters
While typing in a foreign key drop down filter, queries to populate date applying entered text are executed.

This queries are executed in backend even the filter is more restrictive than previous one and previous one returned the whole page. This is, adaptive filtering is not used in this case.
With sample date (i.e. live.openbravo.com)
-Go to Sales Order
-Clean filters
-Open Business Parnter drop down in filter -> Check one remote query is executed to retrieve data. This query returns a small set of records
-Type whatever in the filter -> An extra remote query is performed. This one should not be necessary as the filter is more restrictive than previous one, it should be locally performed
Performance
related to defect 00251823.0PR14Q2 closed alostale Query in org drop down in the list field is having bad performance 
related to design defect 0025211 closed AugustoMauch Filter by selected value in FK uses identifier instead of ID 
Issue History
2013-11-25 12:51alostaleNew Issue
2013-11-25 12:51alostaleAssigned To => AugustoMauch
2013-11-25 12:51alostaleModules => Core
2013-11-25 12:51alostaleTriggers an Emergency Pack => No
2013-11-25 12:51alostaleRelationship addedrelated to 0025182
2013-11-25 12:52alostaleTag Attached: Performance
2013-11-25 12:57alostaleRelationship addedrelated to 0025211
2015-02-24 11:31alostaleNote Added: 0074839
2015-02-24 11:31alostaleTypedefect => design defect

Notes
(0074839)
alostale   
2015-02-24 11:31   
Moving to design defect due the risk to implement it