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

View Issue DetailsJump to Notes ] Issue History ] Print ]
ID
0029310
TypeCategorySeverityReproducibilityDate SubmittedLast Update
design defect[Openbravo ERP] A. Platformminoralways2015-03-17 10:292015-03-17 10:31
ReportercaristuView Statuspublic 
Assigned ToAugustoMauch 
PrioritynormalResolutionopenFixed in Version
StatusnewFix 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

0029310: Ordering the grid by a field with multiple identifiers can be confusing sometimes

DescriptionOrdering 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 Reproduce1) 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 [^]
TagsNo tags attached.
Attached Files? file icon order_query.sql [^] (630 bytes) 2015-03-17 10:29

- Relationships Relation Graph ] Dependency Graph ]

-  Notes
There are no notes attached to this issue.

- 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 View Revisions
2015-03-17 10:31 caristu Issue Monitored: networkb


Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker