0036506: Auxiliary Input is not computed if the SQL code has "IN (@#...@)"

Anonymous | Login

Project:

News | My View | View Issues | Roadmap | Summary

View Revisions: Issue #36506		[ Back to Issue ]
Summary	0036506: Auxiliary Input is not computed if the SQL code has "IN (@#...@)"

Revision	2017-07-17 18:06 by ngarcia
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

Revision	2017-07-17 18:06 by ngarcia
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 this time

Revision	2017-07-17 18:04 by ngarcia
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)