filtering by attributes com.ibm.team.workitem.runSavedQuery
I defined a named query in RTC to get all Work Items stored in RTC
After that I run this named query from RTC menu Shared queries to know the ID of this named query
With this ID I executed the named query in the same way, that is, copying the URL of the named query execution, something like the attached sample https://host:port/ccm/web/projects/PROJECT_AREA#action=com.ibm.team.workitem.runSavedQuery&id=_4NAtoHNrEeGQvf1t-ZPwiQ&filterAttribute=name&filterValue=David
Where
o id is the first parameter given to com.ibm.team.workitem.runSavedQuery handler and _4NAtoHNrEeGQvf1t-ZPwiQ the ID of the named query in the current Project Area
o filterAttribute is the second parameter that indicates the attribute to be filter
o filterValue is the third parameter that indicates the value of filterAttribute. Here is where Im finding the problems as follows:
It seems com.ibm.team.workitem.runSavedQuery handler is filtering the attribute indicated in filterAttribute parameter in LIKE way, that is:
If I had two Work Items with a common Attribute called name with a different value in each of them: David and David de Diego, when I execute the query http://#action=com.ibm.team.workitem.runSavedQuery&id=_4NAtoHNrEeGQvf1t-ZPwiQ&filterAttribute=name&filterValue=David the result thrown is a grid with two rows, because the both values start with the same pattern David
However if I execute the query http://#action=com.ibm.team.workitem.runSavedQuery&id=_4NAtoHNrEeGQvf1t-ZPwiQ&filterAttribute=name&filterValue=David de Diego the result thrown is a grid with only one row, because only one of them match with that pattern
The behaviour is similar to do a LIKE% in a query, but what I need is to find only the rows that match exactly with filter value indicated, one for the first query, and one for the second query
My concern is how I could do that? I need filter only with exact matching. I was trying adding quotes to the filter value parameter but it doesnt work http://#action=com.ibm.team.workitem.runSavedQuery&id=_4NAtoHNrEeGQvf1t-ZPwiQ&filterAttribute=name&filterValue=David
Any suggestion to solve that concern with wildcard characters for example. Thanks in advance
After that I run this named query from RTC menu Shared queries to know the ID of this named query
With this ID I executed the named query in the same way, that is, copying the URL of the named query execution, something like the attached sample https://host:port/ccm/web/projects/PROJECT_AREA#action=com.ibm.team.workitem.runSavedQuery&id=_4NAtoHNrEeGQvf1t-ZPwiQ&filterAttribute=name&filterValue=David
Where
o id is the first parameter given to com.ibm.team.workitem.runSavedQuery handler and _4NAtoHNrEeGQvf1t-ZPwiQ the ID of the named query in the current Project Area
o filterAttribute is the second parameter that indicates the attribute to be filter
o filterValue is the third parameter that indicates the value of filterAttribute. Here is where Im finding the problems as follows:
It seems com.ibm.team.workitem.runSavedQuery handler is filtering the attribute indicated in filterAttribute parameter in LIKE way, that is:
If I had two Work Items with a common Attribute called name with a different value in each of them: David and David de Diego, when I execute the query http://#action=com.ibm.team.workitem.runSavedQuery&id=_4NAtoHNrEeGQvf1t-ZPwiQ&filterAttribute=name&filterValue=David the result thrown is a grid with two rows, because the both values start with the same pattern David
However if I execute the query http://#action=com.ibm.team.workitem.runSavedQuery&id=_4NAtoHNrEeGQvf1t-ZPwiQ&filterAttribute=name&filterValue=David de Diego the result thrown is a grid with only one row, because only one of them match with that pattern
The behaviour is similar to do a LIKE% in a query, but what I need is to find only the rows that match exactly with filter value indicated, one for the first query, and one for the second query
My concern is how I could do that? I need filter only with exact matching. I was trying adding quotes to the filter value parameter but it doesnt work http://#action=com.ibm.team.workitem.runSavedQuery&id=_4NAtoHNrEeGQvf1t-ZPwiQ&filterAttribute=name&filterValue=David
Any suggestion to solve that concern with wildcard characters for example. Thanks in advance