Define a parameter p_split_param which is of type java.lang.String[], and 'isForPrompting="false" ' In this p_split_param parameter, put either an empty array (new String[0]) if your real input parameter is empty, $P{your_input_param}.split(",") otherwise: "".equals($P{P_REAL_INPUT_PARAM}) ? new String[0] : $P{P_REAL_INPUT_PARAM}.split(",") In a dummy P_WHERE_CLAUSE parameter (= isForPrompting="false" ), put: $P{p_split_param}.length == 0 ? " " : " WHERE $X{IN, table_id_column, p_split_param} In your queryString put: select ... from ... $P!{P_WHERE_CLAUSE}