It's all about the answers!

Ask a question

Automate Reports or Work Item Queries


R Z (1273453) | asked Oct 27 '14, 2:18 a.m.

Team,

I have a requirement where i need to automate reports or Work Item Queries, I meant it should automatically run and send that as email to different stakeholders.

Is it possible?

Any clue would be highly appreciated.

Thank You in advance

Accepted answer


permanent link
Ralph Schoon (63.5k33646) | answered Oct 27 '14, 3:52 a.m.
FORUM ADMINISTRATOR / FORUM MODERATOR / JAZZ DEVELOPER
You can run queries in automation e.g. use the JBE for it. See https://rsjazz.wordpress.com/2012/10/29/using-work-item-queris-for-automation/

You can also run scheduled tasks on the server see: http://jorgediazblog.wordpress.com/2013/06/28/rtc-custom-scheduled-async-task-example-explained/

On the server there is the mailer service that you can use to send mails.
R Z selected this answer as the correct answer

One other answer



permanent link
Susan Hanson (1.6k2201194) | answered Oct 27 '14, 6:23 a.m.
We do this using the Java APIs on a scheduled task on a separate Windows-based server (since running them on the RTC server itself is problematic for us since we have our CLM hosted by another team).  In some cases, it sends email (using just javamail and an smtp server) and others generate HTML reports that can then be viewed by others. 

Your answer


Register or 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.