Project:
| View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | ||||||||||
| ID | |||||||||||
| 0029919 | |||||||||||
| Type | Category | Severity | Reproducibility | Date Submitted | Last Update | ||||||
| design defect | [Openbravo ERP] A. Platform | major | have not tried | 2015-05-18 18:35 | 2022-02-01 08:09 | ||||||
| Reporter | AugustoMauch | View Status | public | ||||||||
| Assigned To | Triage Platform Base | ||||||||||
| Priority | urgent | Resolution | open | Fixed in Version | |||||||
| Status | acknowledged | 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 | |||||||||||
| Web browser | |||||||||||
| Modules | Core | ||||||||||
| Regression level | |||||||||||
| Regression date | |||||||||||
| Regression introduced in release | |||||||||||
| Regression introduced by commit | |||||||||||
| Triggers an Emergency Pack | No | ||||||||||
| Summary | 0029919: The query done to populate table/tabledir dropdowns in forms when the user enters text can be improved | ||||||||||
| Description | If the user enters text in the dropdown of a table/tabledir field, the query created to populate the combo will use the coalesce and to_char functions even if it is not needed. For instance, if the user enter 'u' in the field Organization of the header tab of the Sales Order window, the following query will be used to populate the dropdown: SELECT td0.AD_Org_ID AS ID, (COALESCE(TO_CHAR(COALESCE(TO_CHAR(td0.Name),'')),'')) AS NAME, '' AS DESCRIPTION FROM AD_Org td0 WHERE td0.AD_Client_ID IN ('0','23C59575B9CF467C9620760EB255B389') AND td0.AD_Org_ID IN ('2E60544D37534C0B89E765FE29BC0B43','7BABA5FF80494CAFA54DEBD22EC46F01','B843C30461EA4501935CB1D125C9C25A','BAE22373FEBE4CCCA24517E23F0C8A48','DC206C91AA6A4897B44DA897936E0EC3','E443A31992CB4635AFCAEABE7183CE85') AND (AD_ORG_ID <> '0') AND (td0.isActive = 'Y' OR td0.AD_Org_ID = (?) ) AND UPPER((COALESCE(TO_CHAR(COALESCE(TO_CHAR(td0.Name),'')),''))) like UPPER(?) ORDER BY 2 LIMIT 76 OFFSET 0 The name of the organization (td0.Name) is a mandatory textual column, so there is no need to surround it with coalesce and to_char functions. | ||||||||||
| Steps To Reproduce | As F&B Admin: - Open the Sales Order window - Create a new record in the header tab - Enter the character 'u' in the Organization field. The query generated will be the one pasted in the description. You can check it yourself by looking at what this line returns in the ComboTableData.select function: String strSql = getQuery(false, null, null, startRow, endRow, conn, !StringUtils.isEmpty(filterValue)); | ||||||||||
| Tags | Performance | ||||||||||
| Attached Files | |||||||||||
 Relationships [ Relation Graph ]
[ Dependency Graph ]
|
||||||||
|
||||||||
 Relationships |
|
Notes |
|
| There are no notes attached to this issue. |
|
Notes |
|
Issue History |
|||
| Date Modified | Username | Field | Change |
| 2015-05-18 18:35 | AugustoMauch | New Issue | |
| 2015-05-18 18:35 | AugustoMauch | Assigned To | => platform |
| 2015-05-18 18:35 | AugustoMauch | Modules | => Core |
| 2015-05-18 18:35 | AugustoMauch | Triggers an Emergency Pack | => No |
| 2015-05-18 18:36 | AugustoMauch | Relationship added | related to 0029732 |
| 2015-05-19 09:47 | alostale | Tag Attached: Performance | |
| 2015-05-19 09:48 | alostale | Status | new => acknowledged |
| 2015-07-03 10:56 | alostale | Priority | normal => urgent |
| 2022-02-01 08:09 | alostale | Assigned To | platform => Triage Platform Base |
|
Issue History |
| Copyright © 2000 - 2009 MantisBT Group |
 |