I'm creating a portlet that has 3 dimensions:
- Task Type
The aim of the portlet is to show task finish date and status across multiple projects for a specific subset of tasks. These tasks have 1 of 2 possible task type values. Task group one is Type = RACM, and the 4 tasks in this group are" Draft, Review, Upload, Validate. Task group two is Type = Access, and the 4 tasks in this group are "Analyze, Build, Test, Assign.
I would like the portlet to look like the attachment called portlet1 but it looks like portlet2 (I just edited the original screenshot to show the desired outcome in portlet1, fyi). I want to limit the 3rd dimension options to those that align with the value in the subtype. IE: Where Dim2 = RACM, only columns for tasks where type = RACM should appear under that dimension header. Where it = Access, only the access tasks should appear. Here is my query:
FROM prtask t
JOIN odf_ca_task ot on ot.id = t.prid
JOIN inv_investments i on i.id = t.prprojectid
LEFT JOIN cmn_lookups_v lc on lc.lookup_type = 'bb_task_sub' and lc.lookup_code = ot.bb_task_sub and lc.language_code = 'en'
AND ot.bb_task_sub in (1,2)
AND i.is_active = 1
Is there something I can do in the query to divide this up this way? I don't think it's possible to do on the portlet side. I am also not seeing the Dim2 headers but I believe this is probably related.