Re: Having two rows corresponding to one result in a portlet?
Something like this should be your data source:
SELECT utable.i ID_COLUMN, utable.a COLUMN_A, utable.b COLUMN_B, utable.c COLUMN_C FROM (select p.PFM_REQUEST_ID i, p.PROJECT_NAME a, to_char(p.PROJECT_ID) b, p.DISPLAY_STATUS c from pm_projects p union select p.PFM_REQUEST_ID i, p.DESCRIPTION a, '' b, '' c from pm_projects p order by i) utable WHERE 1=1
Make sure that you disable sorting for columns other than the ID. See the attached pdf for my example.