[using $X in the query, Parameter type not supporte]

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}