RPE 6.0.1 How do I query Work Items type without get all WI and without scripted filter?
Hello,
I would like to know if there is an easy to make a query from the REST url in order of not bring all WI, and produce the report faster?
I need to filter by work item type and by date and if is possible by a custom attribute?
Thank you.
|
One answer
RPE supports native filter and scripted filter. If you are using native filter, RPE will automatically include the filters in the request URL and hence the performance will be better.
Please note that not all the properties in RTC are allowed in filtering. That means you cannot use all properties in native filter, but you can use them in scripted filter. You cannot filter work items by the type name, but you can filter on the type id (type/id). I would suggest using scripted filter for dates as you should be careful about date format, if it is part of the request URL.
Here is an URL that uses filter:
https://sppserver:9443/ccm/rpt/repository/workitem?fields=workitem/workItem[projectArea/name='JKE Banking (Change Management)' and target/name='Sprint1' and type/id='defect']/(creationDate|dayModified|summary|owner/(emailAddress|name)|state/(name)|target/(name)|type/(name))
For your reference, I am also attaching a simple example template. You can set the data source URL as https://sppserver:9443/ccm/rpt/repository/workitem and you see that RPE will construct the request url with filters.
|
Your answer
Dashboards and work items are no longer publicly available, so some links may be invalid. We now provide similar information through other means. Learn more here.