Project and Portfolio Management Practitioners Forum
cancel

What is the use of filter fields in portlet

SOLVED
Go to solution
Highlighted
sam.greg
Honored Contributor.

What is the use of filter fields in portlet

Hi,

I am newbie on PPM usage. I have following question.

I know portlet has Datasource as its backend. Datasource is nothing bue some conditional SQL query (that actually fetches results and makes it available to portlet).

The issue is - We have one datasource attached to a portlet that fetches all requests for one user. I could actually see around 200 results of this query when executed from SQLPlus. But from dashboad, I could only see 20 requests.

Why there is this difference?

Thanks in advance.

Cheers,
.\Sam
19 REPLIES
sam.greg
Honored Contributor.

Re: What is the use of filter fields in portlet

But when I use Request List portlet, it shows me all 200 requests.
Sangiliraja_1
Honored Contributor.

Re: What is the use of filter fields in portlet

Hi Sam,

Send me your query and also snapshot of ur edit portlet page.

Whatever result set the Request List portlet is able to fetch, user should be able to do.

Thanks
Sangiliraja.P
sam.greg
Honored Contributor.

Re: What is the use of filter fields in portlet

Hi Sangiliraja,

Please have a look at attachment. Note that if I run the victim datasource directly using SQLPlus, I get around 2K result.

Thanks
.\Sam
Sangiliraja_1
Honored Contributor.

Re: What is the use of filter fields in portlet

hi Sam,

Sorry i am not able to open the attachment.

Thanks
Sangiliraja.P
sam.greg
Honored Contributor.

Re: What is the use of filter fields in portlet

attachment-1
sam.greg
Honored Contributor.

Re: What is the use of filter fields in portlet

attachment-2
sam.greg
Honored Contributor.

Re: What is the use of filter fields in portlet

attachment-3
sam.greg
Honored Contributor.

Re: What is the use of filter fields in portlet

attachment-4
sam.greg
Honored Contributor.

Re: What is the use of filter fields in portlet

attachment-5
sam.greg
Honored Contributor.

Re: What is the use of filter fields in portlet

attachment-6
sam.greg
Honored Contributor.

Re: What is the use of filter fields in portlet

Sorry, but I had to attach all of them individually. There is no provision to attach in group at once.

Cheers
.\Sam
Michael.Ebert
Super Contributor.

Re: What is the use of filter fields in portlet

Hi Sam,

there is a server.conf parameter which limits the maximum result rows in datasources

com.kintana.core.server.PORTLET_MAX_ROWS_RETURNED=200

If there is no grouping expression in the datasource PPM will automatically add the following where clause on execution of the database query

rownum <= 200

Change your Datasource to generate an error during execution of the query and you will see the additional where clause in portlet error message.

Kind Regards,
Michael
sam.greg
Honored Contributor.

Re: What is the use of filter fields in portlet

Thanks Mike.

Where can I find datasource for Request List? I want to see what query Request List is using?


Cheers,
\Sam.
Sangiliraja_1
Honored Contributor.

Re: What is the use of filter fields in portlet

Hi Sam,

Is there any specific reason for using the "KCRT_PORTLET_REQUEST_LIST_V" view in ur query.

try using the base tables of PPM.

Thanks
Sangiliraja.P
sam.greg
Honored Contributor.

Re: What is the use of filter fields in portlet

Hi Sangiliraja,

Not sure why we have used like that. Do you know where I can find list of all oftb portlets/datasources provided by HP?

Also, somebody told me 'My Requests' portlet is also oftb portlet but I could see the datasource its using from workbench. So now if 'Request List' is also oftb portlet, why am I not able to see which datasource it is using?


Please help, am getting confused.

Regards,
Sam

...\ I found this forum very helpful and quick responsive. Thanks to you all.
Nisha Kurien
Honored Contributor.
Solution

Re: What is the use of filter fields in portlet

I believe Request List is a jsp portlet (for the newer versions of PPM), so the code is pretty much hidden from the workbench. While My Request is a portlet whose code can be accessed from the workbench. They are essentially the same - all are reports/portlets just built differently.

Hope this helps.
Nisha Kurien
Honored Contributor.

Re: What is the use of filter fields in portlet

Also if you noticed the My Requests portlet is non-editable from the workbench - meaning you cannot add or delete anything - read only. Another indication that it is OOTB (out of the box).
Sangiliraja_1
Honored Contributor.

Re: What is the use of filter fields in portlet

Hi Sam,

Request List Porlte is a JAVA portlet. These are seeded data portlets and you will not be able to edit the portlet definition. Also JAVA portlets wont be available in Workbench in the datasource section.

Only thing you can do you can customize a portlet which can replicate the same functionality.

Thanks
Sangiliraja.P
sam.greg
Honored Contributor.

Re: What is the use of filter fields in portlet

Thanks a bunch Nisha - very crisp and clear answers.

Thanks Raja for the clarification.