I have a process parameter listener which needs to execute a query based on the selected lines of an InfoWindow. Currently the query is
StringBuilder sql = new StringBuilder("SELECT SUM(currencyConvert(Amount, C_Currency_ID, ?, sysdate, 0, AD_Client_ID, 0)) FROM XXA_TpaMovementLine WHERE XXA_TpaMovementLine_ID IN (") .append(Env.getContext(Env.getCtx(), parameterPanel.getWindowNo(), "_IWInfoIDs_Selected")) // InfoPanel.ROW_ID_CTX_VARIABLE_NAME .append(")");
Would be better to use it directly and have StringBuilder sql = new StringBuilder("SELECT SUM(currencyConvert(Amount, C_Currency_ID, ?, sysdate, 0, AD_Client_ID, 0)) FROM XXA_TpaMovementLine WHERE XXA_TpaMovementLine_ID IN (") .append(Env.getContext(Env.getCtx(), parameterPanel.getWindowNo(), InfoPanel.ROW_ID_CTX_VARIABLE_NAME)) .append(")");
I have a process parameter listener which needs to execute a query based on the selected lines of an InfoWindow.
Currently the query is
StringBuilder sql = new StringBuilder("SELECT SUM(currencyConvert(Amount, C_Currency_ID, ?, sysdate, 0, AD_Client_ID, 0)) FROM XXA_TpaMovementLine WHERE XXA_TpaMovementLine_ID IN (")
.append(Env.getContext(Env.getCtx(), parameterPanel.getWindowNo(), "_IWInfoIDs_Selected")) // InfoPanel.ROW_ID_CTX_VARIABLE_NAME
.append(")");
Would be better to use it directly and have
StringBuilder sql = new StringBuilder("SELECT SUM(currencyConvert(Amount, C_Currency_ID, ?, sysdate, 0, AD_Client_ID, 0)) FROM XXA_TpaMovementLine WHERE XXA_TpaMovementLine_ID IN (")
.append(Env.getContext(Env.getCtx(), parameterPanel.getWindowNo(), InfoPanel.ROW_ID_CTX_VARIABLE_NAME))
.append(")");
but it requires to make it public.