Using wildcards in search for tags in report?
I'm building a BIRT report to retrieve the work items that have a particular tag. It seems that when I use the tag as a parameter, I get the work items that have only that tag and no other tags. Is there a way to search with wildcards or otherwise use an IN condition so I can retrieve all of the work items that have that particular tag, regardless of their other tags?
For example, suppose I have these three work items:
Item 1 tagged with "tag_alpha"
Item 2 tagged with "tag_beta"
Item 3 tagged with "tag_alpha" and "tag_beta"
When I create a data set for work items, I set the TAGS parameter to "tag_alpha". However, this retrieves only item #1, and I would like to retrieve items 1 and 3. I have tried "*tag_alpha*" with asterisks as wild cards, but that doesn't retrieve any work items.
I'm using RTC 1.0.1.1M1.
Thank you,
Tim McMackin
For example, suppose I have these three work items:
Item 1 tagged with "tag_alpha"
Item 2 tagged with "tag_beta"
Item 3 tagged with "tag_alpha" and "tag_beta"
When I create a data set for work items, I set the TAGS parameter to "tag_alpha". However, this retrieves only item #1, and I would like to retrieve items 1 and 3. I have tried "*tag_alpha*" with asterisks as wild cards, but that doesn't retrieve any work items.
I'm using RTC 1.0.1.1M1.
Thank you,
Tim McMackin
Accepted answer
One other answer
Correct, I am using the live_workitem_cnt table.
I created work item 70480 for this (but I could not assign it to the 2.0 release).
As a workaround, I can set up a filter in the BIRT date source for a "match" condition based on the value of the tag. However, this means retrieving all of the work items and then filtering them by tag -- I think this would cause a serious performance hit.
I created work item 70480 for this (but I could not assign it to the 2.0 release).
As a workaround, I can set up a filter in the BIRT date source for a "match" condition based on the value of the tag. However, this means retrieving all of the work items and then filtering them by tag -- I think this would cause a serious performance hit.