You're on your way to the next level! Join the Kudos program to earn points and save your progress.
Level 1: Seed
25 / 150 points
1 badge earned
Challenges come and go, but your rewards stay with you. Do more to earn more!
What goes around comes around! Share the love by gifting kudos to your peers.
Keep earning points to reach the top of the leaderboard. It resets every quarter so you always have a chance!
Join now to unlock these features and more
In a quest to migrate from static spreadsheets to dynamic dashboards, I've been seeing how far I can push the Qotilabs Rich Filters Plugin. I have a specific issuetype that uses a series of subtasks assigned to different individuals that need to be completed in a specific sequence. We use Google Sheets to alternatively display Status, Assignee, and Due Date per subtask, arranged in an easy to reference matrix.
I've got the first view I need working, the status view, with Smart Filter columns using the issueFunction in parentsOf() scriptrunner line, and three colour coded labels to return To Do/In Progress/Done statuses. This produces a matrix with my ~30 parent issues in a list in the Y axis, and the 9 subtasks per parent, each in their own column, in the X axis. The end result looks like this (issuekeys and column headings cropped out):
I'd like to use the Views functionality for Rich Filters to also have an Assignee view and a Due Date view arranged in the same way, but with this basic setup I would need to use Smart Filter labels to display hard-coded assignees and dates. This is obviously not an ideal solution, since assignees and dates might change, and since my stock list for each exceeds the 10 label maximum.
What I effectively need is to be able to populate the smart filter label field with a variable, i.e., issueFunction in parentsOf() will return one ticket per parent and subtask column, and if I could display the actual value of the assignee or due date of that ticket in the label space, that would be ideal. However, it seems that functionality doesn't exist, so I need some other way to return the values for these issue fields in a matrix like this. Maybe that's a different rich filtering gadget, or another plugin, but I'm stuck. Any thoughts?