using $X in the query, Parameter type not supporte in Products Posted October 21, 2007 Hi,To make it work with your example, simply do it like:SELECT FISCAL_YEAR,ACCT_STRUCTURE,ACCT_REGION,ACCT_STATUS_CODE,ACCT_STRUCTURE_DESCFROM ACCOUNT_STRUCTURE AWHERE $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}
using $X in the query, Parameter type not supporte
in Products
Posted
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}