Jazz Forum Welcome to the Jazz Community Forum Connect and collaborate with IBM Engineering experts and users

RTC Queries for Count Function

Questions
Tags
Users
Badges
shruthi srinivas
(11●1) Oct 27 '16, 12:56 a.m.

Hi Team,

We are using RTC Webclient 5.0.2 and RTC Client for Ecplise 4.0.7.

I want to create the query using Count function and Pivot table function(Similar to excel) in RTC , let me know how to create the expressions, currently only AND & OR conditions customization is available on RTC query for display of column to doenload report in CSV format

Regards,

Shruthi Srinivas

0 votes

2 answers
2,157 views
0 votes

2 answers

Permanent link
Lily Wang
(4.9k●7●14) Oct 27 '16, 2:14 a.m.
You can not use aggregate function in RTC workitem queries directly. You can install JRS component in CLM 5.0.2 and create JRS report which support aggregation.
Please see document https://jazz.net/library/article/1470 (section Column aggregation and totals) for JRS report creation.

0 votes

Permanent link
Ralph Schoon
FORUM ADMINISTRATOR / FORUM MODERATOR / JAZZ DEVELOPER (63.9k●3●36●48) Oct 27 '16, 7:22 a.m.
There is no way to create queries like that. You can try exporting the data and then do whatever you can do with it there. The Jazz Reporting Service gets more and more capabilities e.g. for counting in RTC 6.0.x.

0 votes

Your answer

Register or log in to post 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.

Ask a question
Guidelines
FAQ
Search context
Follow this question

By Email: 

Once you sign in you will be able to subscribe for any updates here.

By RSS:

Answers
Answers and Comments
Question details

Question asked: Oct 27 '16, 12:56 a.m.

Question was seen: 2,157 times

Last updated: Oct 27 '16, 7:22 a.m.

Confirmation Cancel Confirm