Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
0031455Openbravo ERP07. Sales managementpublic2015-11-12 18:372017-04-24 11:12
maite 
Triage Omni OMS 
normalminoralways
newopen 
5
 
 
vmromanos
Core
No
0031455: Not possible to filter by Product in Return From Customer pick/edit when huge volume of data
Not possible to filter by Product in Return From Customer pick/edit when huge volume of data
1. Create new register in Return From Customer window for F&B España - Región Norte and Alimentos y Supermercados
2. Run pick/edit process and clear filtering criteria
3. Start typing product name and TAB to apply filtering criteria and realize that "loading data" message appears with no ending

NOTE: if execute "select * from pg_stat_activity;" in the database you can check that active query is running
No tags attached.
png fix_31455.png (85,864) 2016-01-12 18:10
https://issues.openbravo.com/file_download.php?file_id=8909&type=bug
png
Issue History
2015-11-12 18:37maiteNew Issue
2015-11-12 18:37maiteAssigned To => Triage Finance
2015-11-12 18:37maiteModules => Core
2015-11-12 18:37maiteResolution time => 1449702000
2015-11-12 18:37maiteTriggers an Emergency Pack => No
2015-11-12 18:37maiteIssue Monitored: networkb
2015-11-12 18:41maiteSteps to Reproduce Updatedbug_revision_view_page.php?rev_id=10192#r10192
2015-11-19 18:55egoitzNote Added: 0081997
2015-11-19 18:59egoitzResolution time1449702000 => 1448319600
2015-11-19 18:59egoitzPriorityurgent => immediate
2015-11-24 12:00egoitzIssue Monitored: egoitz
2015-12-21 16:16vmromanosTarget Version3.0PR16Q1 =>
2016-01-04 19:13AtulOpenbravoAssigned ToTriage Finance => AtulOpenbravo
2016-01-04 19:13AtulOpenbravoStatusnew => scheduled
2016-01-12 18:10gorka_gilFile Added: fix_31455.png
2016-01-12 18:11gorka_gilReview Assigned To => vmromanos
2016-01-12 18:11gorka_gilNote Added: 0083209
2016-01-12 18:11gorka_gilPriorityimmediate => normal
2016-01-12 18:11gorka_gilSeveritymajor => minor
2016-01-12 18:11gorka_gilStatusscheduled => acknowledged
2016-01-18 13:08VictorVillarResolution time1448319600 =>
2017-04-19 08:43AtulOpenbravoAssigned ToAtulOpenbravo => Triage Finance
2017-04-24 11:12aferrazStatusacknowledged => scheduled
2017-04-24 11:12aferrazStatusscheduled => feedback
2017-04-24 11:12aferrazStatusfeedback => new

Notes
(0081997)
egoitz   
2015-11-19 18:55   
The same happens filtering by documentno or date
(0083209)
gorka_gil   
2016-01-12 18:11   
This kind of issues can be directly resolved in the Grid Configuration at Window/Tab/Field window. See attached fix_31455.png screenshot with the proposed configuration.

When "Allow Filtering Foreign Keys by its Identifier" is disabled, then the only way to filter the foreign key columns will be by picking some value from the filter drop down. The query done to fetch data when the filter is set this way is much better than the query done when the column is filtered without using the filter drop down. Even if this flag is unchecked the user will be able to enter text to filter the data shown in the drop down list.



Bug set as minor and removed resolution time