Project:
| View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||||||
| ID | ||||||||||||
| 0031455 | ||||||||||||
| Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||||||
| defect | [Openbravo ERP] 07. Sales management | minor | always | 2015-11-12 18:37 | 2017-04-24 11:12 | |||||||
| Reporter | maite | View Status | public | |||||||||
| Assigned To | Triage Omni OMS | |||||||||||
| Priority | normal | Resolution | open | Fixed in Version | ||||||||
| Status | new | Fix in branch | Fixed in SCM revision | |||||||||
| Projection | none | ETA | none | Target Version | ||||||||
| OS | Any | Database | Any | Java version | ||||||||
| OS Version | Database version | Ant version | ||||||||||
| Product Version | SCM revision | |||||||||||
| Review Assigned To | vmromanos | |||||||||||
| Web browser | ||||||||||||
| Modules | Core | |||||||||||
| Regression level | ||||||||||||
| Regression date | ||||||||||||
| Regression introduced in release | ||||||||||||
| Regression introduced by commit | ||||||||||||
| Triggers an Emergency Pack | No | |||||||||||
| Summary | 0031455: Not possible to filter by Product in Return From Customer pick/edit when huge volume of data | |||||||||||
| Description | Not possible to filter by Product in Return From Customer pick/edit when huge volume of data | |||||||||||
| Steps To Reproduce | 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 | |||||||||||
| Tags | No tags attached. | |||||||||||
| Attached Files |  fix_31455.png [^] (85,864 bytes) 2016-01-12 18:10
| |||||||||||
 Relationships [ Relation Graph ]
[ Dependency Graph ]
|
|
 Relationships |
|
Notes |
|
|
(0081997) egoitz (developer) 2015-11-19 18:55 |
The same happens filtering by documentno or date |
|
(0083209) gorka_gil (administrator) 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 |
|
Notes |
|
Issue History |
|||
| Date Modified | Username | Field | Change |
| 2015-11-12 18:37 | maite | New Issue | |
| 2015-11-12 18:37 | maite | Assigned To | => Triage Finance |
| 2015-11-12 18:37 | maite | Modules | => Core |
| 2015-11-12 18:37 | maite | Resolution time | => 1449702000 |
| 2015-11-12 18:37 | maite | Triggers an Emergency Pack | => No |
| 2015-11-12 18:37 | maite | Issue Monitored: networkb | |
| 2015-11-12 18:41 | maite | Steps to Reproduce Updated | View Revisions |
| 2015-11-19 18:55 | egoitz | Note Added: 0081997 | |
| 2015-11-19 18:59 | egoitz | Resolution time | 1449702000 => 1448319600 |
| 2015-11-19 18:59 | egoitz | Priority | urgent => immediate |
| 2015-11-24 12:00 | egoitz | Issue Monitored: egoitz | |
| 2015-12-21 16:16 | vmromanos | Target Version | 3.0PR16Q1 => |
| 2016-01-04 19:13 | AtulOpenbravo | Assigned To | Triage Finance => AtulOpenbravo |
| 2016-01-04 19:13 | AtulOpenbravo | Status | new => scheduled |
| 2016-01-12 18:10 | gorka_gil | File Added: fix_31455.png | |
| 2016-01-12 18:11 | gorka_gil | Review Assigned To | => vmromanos |
| 2016-01-12 18:11 | gorka_gil | Note Added: 0083209 | |
| 2016-01-12 18:11 | gorka_gil | Priority | immediate => normal |
| 2016-01-12 18:11 | gorka_gil | Severity | major => minor |
| 2016-01-12 18:11 | gorka_gil | Status | scheduled => acknowledged |
| 2016-01-18 13:08 | VictorVillar | Resolution time | 1448319600 => |
| 2017-04-19 08:43 | AtulOpenbravo | Assigned To | AtulOpenbravo => Triage Finance |
| 2017-04-24 11:12 | aferraz | Status | acknowledged => scheduled |
| 2017-04-24 11:12 | aferraz | Status | scheduled => feedback |
| 2017-04-24 11:12 | aferraz | Status | feedback => new |
|
Issue History |
| Copyright © 2000 - 2009 MantisBT Group |
 |