We need to write a portlet, where the rows become the columns, and the count is diplayed per column.
So If 'select in query' returns -
A B A C
We need it to be written as
A B C 2 1 1
where AB,C are values in a Drop Down List.
One way is to Hardcode the values and then calculate counts by writing functions for each, however this makes the portlet heavy and would have to be re-written/modified if any value is added and has to be diaplayed. And moreover we have 10 columns.
I was hoping if someone has a dynamic way of doing this.
You could write some dynamic SQL to calculate the correct columns based on the data and build your query formatted that way (as in if you added a 'D' row in the data then add a 'D' column to the query), but since you have to reconfigure the portlet's data source & definition for each new column you wish to add anyway, I don't think that is viable on the PPM side.