Can we query and export Change sets in RTC with in a specified date range

0	Rao Shines (157●4●41●55) \| asked Jul 22 '16, 7:21 a.m. Is there a way in RTC where I can query and export all change sets within a date range? RTC version is 5.0.0 installed on windows

Accepted answer

permanent link

Ralph Schoon (56.8k●2●36●42) | answered Jul 22 '16, 8:34 a.m.
FORUM ADMINISTRATOR / FORUM MODERATOR / JAZZ DEVELOPER

You can search for work items Search->Jazz Source Control->Change Sets

I don't think you can export the results though.

Rao Shines selected this answer as the correct answer

2 other answers

Most liked answers ↑|Newest answers|Oldest answers

permanent link

Bhagath P B (123●6) | answered Feb 04, 6:28 a.m.

You can export change sets with date range using JRS. Below are the steps:

Select LQE as the data source.
Select the project areas on which Change Set based report is to be generated
Select SCM Change Set under Choose an artifact.
Add relationship as : SCM Change Set --> (optional) --> workitem
Under set conditions add condition provide before and after by selecting last Update Date.

Under set conditions, add 2 conditions to provide specific date range

Ex: Last update Date after 01/01/2020

Last update Date before 21/01/2020

6. Under Format results add required attributes and run report.

7. Review the report and also you can export the generated report.

permanent link

Rao Shines (157●4●41●55) | answered Jul 25 '16, 4:38 a.m.

Thank you Ralph,

Is there a way to export using any API or any custom code?

Comments

David Lafreniere commented Jul 25 '16, 4:19 p.m.

FORUM MODERATOR / JAZZ DEVELOPER

In the Search view (just after searching for change sets as Ralph has showed) you can select all the rows and invoke the context menu action of "Copy Text". You can also open these change sets in the Change Explorer view, and use the "Save Change Log" action, which allows you to customize what information you want to display in the output report. (note: as of 6.0.3, the change log can be exported in CSV format, which makes it easy for importing into Excel for example).

Rao Shines commented Jul 28 '16, 7:56 a.m.

Thank you David

Ralph Schoon commented Jul 28 '16, 8:01 a.m.

FORUM ADMINISTRATOR / FORUM MODERATOR / JAZZ DEVELOPER

Thanks David! I was not aware of all that.

It's all about the answers!

Related questions

Can we query and export Change sets in RTC with in a specified date range

Accepted answer

2 other answers

Your answer