The community will be in read-only from Tuesday 11:59pm (PST) to Wednesday 7:30am (PST)
The community will be in read-only from Tuesday 11:59pm (PST) to Wednesday 7:30am (PST)
Project and Portfolio Management Practitioners Forum
cancel
Showing results for 
Search instead for 
Did you mean: 

Request Status field in portlet filter

SOLVED
Go to solution
Highlighted
ramana.vkn
Collector

Request Status field in portlet filter

Hi,

Please help me in creating Request Status field in portlet filter.

Requirement is if I select Request Type, Request status filed should show only Status available for selected Request Type.

Thanks in advance
7 REPLIES
Sascha Mohr_1
Esteemed Contributor
Solution

Re: Request Status field in portlet filter

For the second field use a validation with this SQL:

SELECT STATUS_ID, STATUS_NAME
FROM kcrt_statuses_nls
WHERE STATUS_ID IN
(SELECT STATUS_ID FROM kcrt_request_type_statuses WHERE REQUEST_TYPE_ID = [NON-VISIBLE-TOKEN])
ORDER BY STATUS_NAME

Replace the NON-VISIBLE-TOKEN with the Token of the first field, like REQ.P.SOMETHING
ramana.vkn
Collector

Re: Request Status field in portlet filter

Hi Sascha,

Thanks for the query.
When I click on Status it is not showing Status Name (attached the screen shot of the error), if I click on Show All, only then all the status name is displayed.

Can we modify the query such that it displayes Status Name as soon as Status is clicked?
Mikia
Super Collector

Re: Request Status field in portlet filter

Try to add:

where UPPER(STATUS_NAME) like UPPER('?' || '%')
and (STATUS_NAME like upper(substr('?',1,1)) || '%'
or STATUS_NAME like lower(substr('?',1,1)) || '%')
order by 2

:)
ramana.vkn
Collector

Re: Request Status field in portlet filter

Hi Mikia,

Tried that no luck.
shygirl
Regular Collector

Re: Request Status field in portlet filter


In the validation, try to set the expected list of length to short and you should be able to see the status name with clicking 'show all'
shygirl
Regular Collector

Re: Request Status field in portlet filter

i mean WITHOUT clicking 'show all'
ramana.vkn
Collector

Re: Request Status field in portlet filter

Thanks a lot Sascha & shygirl
//Add this to "OnDomLoad" event