mybatis 中 使用 查询条件为数组 入参是集合查询方式 若是SQL脚本的话 条件=any(数组)

<if test="shopManageUserIds != null and shopManageUserIds.size > 0">
    AND rpd.manage_user_id @> ARRAY
    <foreach collection="shopManageUserIds" item="id" open="[" separator="," close="]">
        #{id}
    </foreach>::bigint[]
</if>

and lm."manageUserId" <![CDATA[&&]]>  ARRAY[
<foreach collection="creatorIds" item="item" separator=",">
  #{item}
</foreach>]::bigint[]

and (marketplace_id, seller_id, asin, to_char(rpt_date, 'yyyy-mm-dd')) in
    (
<foreach collection="inputs" item="input" separator=",">
    (#{input.marketplaceId}, #{input.sellerId}, #{input.asin}, #{input.rptDateText})
</foreach>
)