ptolomej

Members

Everything posted by ptolomej

using $X in the query, Parameter type not supporte

ptolomej replied to alchavez's topic in Products

Hi, To make it work with your example, simply do it like: SELECT FISCAL_YEAR, ACCT_STRUCTURE, ACCT_REGION, ACCT_STATUS_CODE, ACCT_STRUCTURE_DESC FROM ACCOUNT_STRUCTURE A WHERE $X{IN, ACCT_REGION, REGION} AND LOCAL_STATUS = 'O' just remove the $P{}, as the $X already takes in account, that the third parameter will be a parameter. The definition for $X is like: $X{IN, dbColumnName, parameterName} $X{NOTIN, dbColumnName, parameterName}