Project and Portfolio Management Practitioners Forum
cancel
Showing results for 
Search instead for 
Did you mean: 

Maximun numbers of rows in porlet

SOLVED
Go to solution
Highlighted
Daniel Galvez
Collector

Maximun numbers of rows in porlet

Hi all!!!!

I have two kind of portlets, one is a list and the other is bar chart, and both gave as maximum value 200 and the query result of the data source shows more than 300. Does the porlets has a maximum numbers of rows???


Kind regards,
Daniel
3 REPLIES
Erik Cole
Honored Contributor
Solution

Re: Maximun numbers of rows in porlet

Hi Daniel,

You can set

com.kintana.core.server.PORTLET_MAX_ROWS_RETURNED

in the server.conf file. Default is 200.
Daniel Galvez
Collector

Re: Maximun numbers of rows in porlet

Thank you very much!!!!!!!! Erick it works
Niraj Prabhu
Frequent Visitor

Re: Maximun numbers of rows in porlet

Daniel,

If you have a custom query which returns more rows than the PORTLET_MAX_ROWS_RETURNED limit, then you can use the GROUP BY clause in your query, as it overrides this limit and shows all rows from your query.

Let me know if you have any question implementing this.

Regards,
Niraj

Niraj P.
//Add this to "OnDomLoad" event