Openbravo Issue Tracking System - Openbravo ERP | |||||
| View Issue Details | |||||
| ID | Project | Category | View Status | Date Submitted | Last Update |
| 0036506 | Openbravo ERP | A. Platform | public | 2017-07-17 18:04 | 2022-02-01 08:05 |
| Reporter | ngarcia | ||||
| Assigned To | Triage Platform Base | ||||
| Priority | high | Severity | minor | Reproducibility | always |
| Status | acknowledged | 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 | 0036506: Auxiliary Input is not computed if the SQL code has "IN (@#...@)" | ||||
| Description | Auxiliary Input is not computed if the SQL code has "IN (@#...@)" The problem in the following piece of code of parseSQL function of UIDefinition class: if (strAux.length() > 3 && strAux.substring(strAux.length() - 3, strAux.length()).equals(" IN")) { strAux = " type=\"replace\" optional=\"true\" after=\"" + strAux1 + "\" text=\"'" + i + "'\""; | ||||
| Steps To Reproduce | As system admin role: Create an auxiliary input (it could be used for display logic): Tab: Header - Sales Order Validation Code: @SQL=SELECT 'Y' FROM ad_org org WHERE org.ad_orgtype_id = '1' AND org.ad_org_id IN (@#AD_Org_ID@) As group admin role: Open the Sales Order window Check the log shows: ERROR org.openbravo.client.application.window.FormInitializationComponent - Error while computing auxiliary input parameter: AUXINP from tab: Header of window: Sales Order org.postgresql.util.PSQLException: The column index is out of range: 1, number of columns: 0. at org.postgresql.core.v3.SimpleParameterList.bind(SimpleParameterList.java:56) at org.postgresql.core.v3.SimpleParameterList.setStringParameter(SimpleParameterList.java:118) at org.postgresql.jdbc.PgStatement.bindString(PgStatement.java:2144) at org.postgresql.jdbc.PgStatement.setString(PgStatement.java:1266) at org.postgresql.jdbc.PgStatement.setString(PgStatement.java:1248) at org.postgresql.jdbc.PgStatement.setObject(PgStatement.java:1831) at org.openbravo.client.application.window.FormInitializationComponent.computeAuxiliaryInput(FormInitializationComponent.java:1886) As system admin role: Change the code of the auxiliary input with: @SQL=SELECT 'Y' FROM ad_org org WHERE org.ad_orgtype_id = '1' AND org.ad_org_id = @#AD_Org_ID@ As group admin role: Open the Sales Order window Check the error is not shown in the log this time | ||||
| Proposed Solution | |||||
| Additional Information | |||||
| Tags | No tags attached. | ||||
| Relationships | |||||
| Attached Files | |||||
| Issue History | |||||
| Date Modified | Username | Field | Change | ||
| 2017-07-17 18:04 | ngarcia | New Issue | |||
| 2017-07-17 18:04 | ngarcia | Assigned To | => platform | ||
| 2017-07-17 18:04 | ngarcia | Modules | => Core | ||
| 2017-07-17 18:04 | ngarcia | Triggers an Emergency Pack | => No | ||
| 2017-07-17 18:04 | ngarcia | Issue Monitored: networkb | |||
| 2017-07-17 18:06 | ngarcia | Steps to Reproduce Updated | bug_revision_view_page.php?rev_id=15523#r15523 | ||
| 2017-07-17 18:06 | ngarcia | Steps to Reproduce Updated | bug_revision_view_page.php?rev_id=15524#r15524 | ||
| 2017-07-24 15:44 | alostale | Status | new => acknowledged | ||
| 2022-02-01 08:05 | alostale | Assigned To | platform => Triage Platform Base | ||
| There are no notes attached to this issue. |