Filtering using a combination of 2 or more Tags in widget reports
Officially AnsweredHello,
I've already read the article https://support.7pace.com/hc/en-us/articles/360037338891-7pace-Timetracker-s-Reporting-Widgets-Gallery#Work%20items%20filtered%20by%20tagsbut this article explains only how to use 1 tag to filter the reports in widget menu.
In my company we use a combination of 2 or more tags in work items to define what kind of project and system being tested, etc, but it's still blurry to me how do I need to write the $filter= segment of the ODATA in widget menu to use the combination of 2 or more tags, could you help me?
I was trying to use like this to filter the total amout of time spent on homologation (tag 'HMLG') of the project TOTEM 4.1.0 (tag "TOTEM 4.1.0'):
{
"id":"",
"query":"$apply=filter(contains(CustomStringField1, 'TOTEM 4.1.0'))/aggregate(TrackedItself with sum as PeriodLength)&contains(CustomStringField1, 'HMLG'))/aggregate(TrackedItself with sum as PeriodLength)&customFields=System.Tags\n",
"endpoint":"workItems",
"type":"Number",
"title":"Time spent on homologation of TOTEM 4.1.0",
"subTitle":null,
"fieldName":"PeriodLength",
"formatter":"TimeLength",
"w":2,
"h":1,
"timeframeFilter":null,
"autoSubtitle":false,
"y":2,
"x":0,
"odataVersion":"v3.0"
}
is it correct the syntax used here? if not, can you help me?
I'd appreciate!
Thanks
Please sign in to leave a comment.
Comments
3 comments