Looking for assistance with a portlet query that is breaking. The query is:
select * from ( SELECT request_id REQUEST_ID, last_update_date LAST_UPDATE, description DESCRIPTION, request_type_name REQUEST_TYPE, status_name STATUS, workflow_name WORKFLOW , row_number() over ( ORDER BY request_id ASC ) as record_index FROM KCRT_PORTLET_REQUEST_LIST_V WHERE request_id in (select request_id from kcrt_requests kr where (status_code NOT LIKE 'CLOSED%' AND status_code NOT LIKE 'CANCEL%') AND ((assigned_to_user_id = ? AND exists (select 'Is eligible' from knta_eligibility_check_v where request_id = parent_id and user_id = ? and instance_source_type_code = 'IR')) OR created_by = ?)) and request_type_id in '[REQ.TYPE]' ) where record_index between ? and ?
The query is supposed to take list of request types (taken from the CRT - Request Types - Enabled validation) and allow the user to be able to filter on them so he/she can choose one or multiples of the request types for thier own dashboard. My filter is calling this from the query: