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: 

SQL code for out-the box portlets

Highlighted
Ryan Grobler
Regular Collector

SQL code for out-the box portlets

Hi All

I am wanting to copy/amend the functionality of a standard dashboard - but can't see where the code is stored.

Wanting to take a copy of the 'Project List' portlet - looked under 'Dashboard' - 'Data Source' but only have a few portlets there.

We has PPM as a SAAS product - not sure if that makes a difference.

Thanks!

Ryan
10 REPLIES
Mahen M
Honored Contributor

Re: SQL code for out-the box portlets

Ryan,
OOTB Portlets are Java Portlets.

You can 'Enable JDBC Logging' under WF Menu -> Edit and as you run the portlet with some parameters, The Java code and SQL Query can be found in the log files.

Remember to turn off the 'JDBC Logging'

You can take the query which is fired in this way. Thank you.

Regards,
Mahendran M
Ryan Grobler
Regular Collector

Re: SQL code for out-the box portlets

Hi Mahendran

I've turned on the JDBC logging

How do I see what gets fired off though?
I know when I create a report I can see this - but how do I see it for the portlets?

Thanks!

Ryan
Mahen M
Honored Contributor

Re: SQL code for out-the box portlets

Edit the portlet, Change the input parameters.

Regards,
Mahendran M
Ryan Grobler
Regular Collector

Re: SQL code for out-the box portlets

I can't see the portlet in the workbench though?
Mahen M
Honored Contributor

Re: SQL code for out-the box portlets

You cannot see this OOTB Portlet in Workbench, What is your Question?

Regards,
Mahendran M
Ryan Grobler
Regular Collector

Re: SQL code for out-the box portlets

I want to see the script behind the portlet so we can take a copy and edit it with additional fields.

But don't see it under the 'Dashboard' - 'Data Sources'. (Only have 22 items in this page, but have many more portlets avaliable) - so wanting to know how I can see the back end code the portlet.

I don't see OOTB anywhere in the WB.
Mahen M
Honored Contributor

Re: SQL code for out-the box portlets

That's what I told, You cannot see code directly in DashBoard or Workbench.

Enable JDBC Logging as shown in the snap and edit the portlet in the Dashboard, After that if you find the jdbc log in your Application Server, It will contain the Java codes with SQL Query.

Thank you.

Regards,
Mahendran M
Mahen M
Honored Contributor

Re: SQL code for out-the box portlets

I hope you are telling about the log which appears after creating the PPM Report. But actually I am mentioning about the Application Server log, Sorry for the confusion.

Regards,
Mahendran M
Ryan Grobler
Regular Collector

Re: SQL code for out-the box portlets

Ah - right, so sorry, I though you meant the report log.

PPM is hosted for us, so not sure we can get the server logs.

May have to live with portlets as it then :)

Thanks!

Ryan
Mahen M
Honored Contributor

Re: SQL code for out-the box portlets

You can do this in your development environment and I see no reason for the AS Administrators not to give you the log file to you.

If you want some join conditions, you can use the attached Query.

Regards,
Mahendran M
//Add this to "OnDomLoad" event