XML
<select id="selectIn1" resultType="map">
SELECT
<trim suffixOverrides=",">
fg_series,fg_desc,fg_create_by,fg_create_dt,fg_update_by,fg_update_dt,fg_form_factor,fg_status
</trim>
FROM public.tg_series
WHERE ${fieldName}=ANY(ARRAY<foreach collection="list" item="record" open="[" close="]" separator=",">
#{record}
</foreach>)
<if test="order != null">
ORDER BY ${order}</if>
</select>
List<Map> selectIn1(@Param("fieldName") String pvsFieldName,@Param("list") List<?> pvValues,@Param("order") String pvsOrderCaise );