Openbravo Issue Tracking System - Openbravo ERP |
| View Issue Details |
|
| ID | Project | Category | View Status | Date Submitted | Last Update |
| 0029310 | Openbravo ERP | A. Platform | public | 2015-03-17 10:29 | 2015-03-17 10:31 |
|
| Reporter | caristu | |
| Assigned To | AugustoMauch | |
| Priority | normal | Severity | minor | Reproducibility | always |
| Status | new | Resolution | open | |
| Platform | | OS | 5 | OS Version | |
| Product Version | | |
| Target Version | | Fixed in Version | | |
| Merge Request Status | |
| Review Assigned To | |
| OBNetwork customer | |
| Web browser | |
| Modules | Core |
| Support ticket | |
| Regression level | |
| Regression date | |
| Regression introduced in release | |
| Regression introduced by commit | |
| Triggers an Emergency Pack | No |
|
| Summary | 0029310: Ordering the grid by a field with multiple identifiers can be confusing sometimes |
| Description | Ordering the grid by a field with multiple identifiers can be confusing sometimes. If the table has as identifier a reference for another table that also has several identifiers, and one of these identifiers is also a foreign key the sorting is done by this column, which is confusing for the users as the ordering criteria is not using any of the displayed values for the record.
An example can be, having a view with two identifiers:
- quantity
- ma_wrphase_id
At the same time, ma_wrphase table has these identifiers:
- ma_work_requirement_id
- ma_process_id
- seqno
In this case, the application takes the ma_work_requirement_id as the column used for the ordering (see the attached query). |
| Steps To Reproduce | 1) Install the following module[1]
2) Go to Outsourcing Goods Shipment
3) Select a record in Delivered status
4) Click on button Create Workeffort
5) Check the ordering of the first column
[1] http://centralrepository.openbravo.com/openbravo/org.openbravo.forge.ui/ForgeModuleDetail/External-Workshops-Management [^] |
| Proposed Solution | |
| Additional Information | |
| Tags | No tags attached. |
| Relationships | |
| Attached Files |  order_query.sql (630) 2015-03-17 10:29
https://issues.openbravo.com/file_download.php?file_id=7898&type=bug |
|
| Issue History |
| Date Modified | Username | Field | Change |
| 2015-03-17 10:29 | caristu | New Issue | |
| 2015-03-17 10:29 | caristu | Assigned To | => AugustoMauch |
| 2015-03-17 10:29 | caristu | File Added: order_query.sql | |
| 2015-03-17 10:29 | caristu | Modules | => Core |
| 2015-03-17 10:29 | caristu | Triggers an Emergency Pack | => No |
| 2015-03-17 10:31 | caristu | Description Updated | bug_revision_view_page.php?rev_id=8006#r8006 |
| 2015-03-17 10:31 | caristu | Issue Monitored: networkb | |