MaxH Honored Contributor.
Honored Contributor.
149 views

Multi Select Filter on Portlet

We have been trying to create a filter for a portlet that provides a way to select multiple request types from the query view.  We receive the following whenever we attempt to filter on more than one record:

 

Cannot load this portlet's data because of a misconfigured SQL query. (KNTA-10836) Please contact your administrator with the following information:

-- The following error is thrown by the database:
ORA-01722: invalid number

-- The SQL query that's being executed:
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 (?)
) where record_index between ? and ?

 

 

The portlet works fine without a filter, but whenever a filter is applied, it breaks.  I have attached a pic of the filter validation.

 

Any suggestions would be helpful.  Thanks.

 

Max

0 Likes
2 Replies
Natalia_R_PPM Absent Member.
Absent Member.

Re: Multi Select Filter on Portlet

Hello Max

 

 

I found something similar in one case. 

 

" To resolve this issue, please add the following hint into data source query. ( anywhere, e.g. after when and before the first table name) 
 
/*NOPAGINATION*/
 
 
Thanks & Best Regards, 
Natalia 
HP Support
If you find that this or any post resolves your issue, please be sure to mark it as an accepted solution.
0 Likes
Absent Member.. AlexSavencu Absent Member..
Absent Member..

Re: Multi Select Filter on Portlet

Hi, Max,

 

can you upload the full SQL statement of the portlet as it shows in the Data Source -> View full query?

 

cheers

alex


--remember to kudos people who helped solve your problem
0 Likes
The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.