Need help with Group Filters: Acting like wildcards
I am using group filters in a query widget. They work great until I get to including a string that is common with most of the other string. When I add that, it acts like a wildcard instead of a string comparison and groups everything else under it.
Example :
Create a query that lists work items with a tag and a foundIn value of the various 4.0 milestones and candidates.
Create two group filters
FourPointOhThree 4.0.3|4.0.3 M3
FourPointOh 4.0 RC5|4.0 RC1|4.0 RC3|4.0 M8|4.0 RC0|4.0.0.1|4.0
Results: Everything that does not have a value of 4.0.3 or 4.0.3 M3 gets put in the FourPointOh group. If I take the 4.0 off the end of the filter lists, then I get the expected results EXCEPT the 4.0 are on their own.
To work around it I created two more groups (FourPointOhTwo and FourPointOhOne) however, this is not a great solution because if other 4.0.x are there they are going to get folded into the FourPointOh group.
Is this a bug? Is there some crazy syntax that is not described here https://jazz.net/downloads/rational-team-concert/releases/2.0.0.1?p=news ?
Example :
Create a query that lists work items with a tag and a foundIn value of the various 4.0 milestones and candidates.
Create two group filters
FourPointOhThree 4.0.3|4.0.3 M3
FourPointOh 4.0 RC5|4.0 RC1|4.0 RC3|4.0 M8|4.0 RC0|4.0.0.1|4.0
Results: Everything that does not have a value of 4.0.3 or 4.0.3 M3 gets put in the FourPointOh group. If I take the 4.0 off the end of the filter lists, then I get the expected results EXCEPT the 4.0 are on their own.
To work around it I created two more groups (FourPointOhTwo and FourPointOhOne) however, this is not a great solution because if other 4.0.x are there they are going to get folded into the FourPointOh group.
Is this a bug? Is there some crazy syntax that is not described here https://jazz.net/downloads/rational-team-concert/releases/2.0.0.1?p=news ?
Accepted answer
Hi Ginny
I was randomly trying different options and one of them seems to works.
Not sure if this is the right value, but you could try with ending the filter string with "$"
Example : FourPointOh 4.0 RC5|4.0 RC1|4.0 RC3|4.0 M8|4.0 RC0|4.0.0.1|4.0$
Let me know if this works for you
Comments
I am thrilled Shubjit! This is is perfect . What was your approach to trying different options? Did you find any other cool characters that make group filters fun and useful?
Thanks again!!!
Ginny
1 vote
Great that this worked for you too :)
I was trying the switches that I remember for Wild Cards, \, &, *, $ and "$" worked.
Might be a hidden feature.
Found that, if we use any other character, it ignores the entire filter string.
Comments
sam detweiler
Aug 30 '13, 7:24 a.m.sorry. I don't see the problem.
>Everything that does not have a value of 4.0.3 or 4.0.3 M3 gets put in the FourPointOh group
where else were they supposed to go? you only made two groups.. so everything has to fit into that model. you list everything specifically.
what if you had one catch all group.. (last is the 'not one of the other specific groups, but still a 4.0 based)
FourPointOhThree 4.0.3|4.0.3 M3
FourPointOhx 4.0 RC5|4.0 RC1|4.0 RC3|4.0 M8|4.0 RC0|4.0.0.1
FourPointOh 4.0
Ginny Ghezzo
JAZZ DEVELOPER Aug 30 '13, 7:53 a.m.Sam,
Sorry I did not clarify. I want to let some things, especially unexpected things, to fall out of groups. ie if it is not in the list then I don't want it in these groups
Right now 4.0.4, 4.0.2, etc were getting rolled into 4.0. But putting a $ they no longer did.
Thanks,
ginny
sam detweiler
Aug 30 '13, 7:57 a.m.got it.. Looks like Shubjit's approach means the group filter is using some form of regular expression ($ means 'at the end', ^ means at the beginning)
1 vote