Adding and using a field on a request to one of HP-supplied java portlets
There is an HP-supplied java portlet definition called Request Activity in PPM. It displays general activity information about ITGRequests. Is there a way to add a field such as Severity into this portlet definition and have the requests listed according to severity? Is there anyone who has already implemented this or a similar one?
One can use for example Priority as one of the fields to define the portlet.
Re: Adding and using a field on a request to one of HP-supplied java portlets
Some portlets like Request Activity , Analyze assignment load portlet etc are java portlets whose queries are built from with the java code using hibernate and you may not be able to able to capture the full SQL. The only option I currently see to view the full SQL would be to enable the logging of the database queries and thus write the SQL to the logserver.txt when the portlet is opened (and consequently the query executed), then create a new portlet by using the query in a custom datasource in Workbench -> Dashboard -> Data Sources. You can then configure the portlet according to your needs, including the columns you need and the sort order.
To be quite and utterly honest however, I have never done this before and don’t know if it IS possible.