jasperreports 使用Parameters对象实现SQL的IN查询

jasperreports 使用Parameters对象实现SQL的IN查询?

网上有回答是这样的$X{IN/NOTIN, FieldName, ParametersName}，我试了并没有实现，另想知道$X是代表什么意思。

http://www.oschina.net/question/2929910_2205846

我解决了

SELECT
    setl.FIXMEDINS_CODE,
    setl.FIXMEDINS_NAME,
    COUNT(fee.SETL_ID) counts,
    SUM(setl.MEDFEE_SUMAMT)
FROM
    fee_list_d fee
LEFT JOIN setl_d setl ON setl.SETL_ID = fee.SETL_ID
WHERE
    fee.INSU_ADMDVS = "339900"
    and $X{IN, setl.PAY_LOC, payLoc}
AND  $X{IN, fee.HILIST_CODE, hilistCode}
and setl.SETL_TIME BETWEEN $P{startTime} AND $P{endTime}
GROUP BY
    fee.FIXMEDINS_CODE
ORDER BY
    counts DESC

img