It's all about the answers!

Ask a question

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

Rao Shines (15945062) | 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 (63.0k33645) | answered Jul 22 '16, 8:34 a.m.
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

permanent link
Bhagath P B (3887) | answered Feb 04 '20, 6:28 a.m.

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

  1. Select LQE as the data source.
  2. Select the project areas on which Change Set based report is to be generated
  3. Select SCM Change Set under Choose an artifact.
  4. Add relationship as : SCM Change Set --> (optional) --> workitem
  5. 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 (15945062) | answered Jul 25 '16, 4:38 a.m.
 Thank you Ralph,

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

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

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.

Thanks David! I was not aware of all that.

Your answer

Register or to post your answer.