I have a Task Report, where I am trying to use a Table Filter Macro, with filters that allow me to refine the list of tasks based on a variety of filter combinations.
The Task Report includes the following columns to display: description,duedate,assignee,location,labels.
When configuring the Table Filter Macro, I have the option to select which filters I want to be driven by a dropdown list. I have set the filters to use dropdowns for "Task appears on" and for "Label(s)". The dropdown for "Label(s)" is not working as I expected.
Here's a hypothetical example to explain what I've encountered.
If I have pages with the following labels:
- Page A: on_hold; tasklist; team123
- Page B: tasklist; team123; on_hold
- Page C: tasklist; team456; in_progress
- Page
team456; on_hold - Page E: draft
Actual Result:
For some reason the "Label(s)" filter dropdown does not provide a list of each label in use. Instead, I get a list of grouped labels. Using the hypothetical example above, this is the list of options I get in the "Label(s)" dropdown:
- on_holdtasklistteam123
- tasklistteam123on_hold
- tasklistteam456in_progress
- team456on_hold
- draft
The dropdown options are a "mashup" of the labels from each page. Even though Page A and Page B are using the same labels, the filter does not recognize them as the same. Instead, the dropdown includes a separate selection for each (#1 and #2 above). It seems to take into account the order in which the labels are displayed on the page.
What I'm trying to achieve:
Using the example above, I would expect the "Label(s)" filter to give the following dropdown options:
- on_hold
- tasklist
- team123
- team456
- in_progress
- draft
I want to be able to choose a single label. For example, if I were to choose "on_hold", I would then expect to see Page A, Page B, and Page D in the filtered results.
Currently, I do not have that option. I can only filter by the entire grouping of labels from a page.
Am I missing something? Am I overlooking a setting in the Table Filter Macro?
