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

Tags

No tags attached.

Attached Files

Relationships [ Relation Graph ] [ Dependency Graph ]

Notes
There are no notes attached to this issue.

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	OBNetwork customer	=> Yes
2017-07-17 18:04	ngarcia	Modules	=> Core
2017-07-17 18:04	ngarcia	Support ticket	=> 47622
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	View Revisions
2017-07-17 18:06	ngarcia	Steps to Reproduce Updated	View Revisions
2017-07-24 15:44	alostale	Status	new => acknowledged
2022-02-01 08:05	alostale	Assigned To	platform => Triage Platform Base