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

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

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

0 votes


Accepted answer

Permanent link
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

1 vote


2 other answers

Permanent link

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.

1 vote


Permanent link
 Thank you Ralph,

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

0 votes

Comments

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).

2 votes

 Thank you David

Thanks David! I was not aware of all that.

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.

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
× 10,936
× 1,202
× 201
× 149

Question asked: Jul 22 '16, 7:21 a.m.

Question was seen: 5,062 times

Last updated: Feb 04 '20, 6:28 a.m.

Confirmation Cancel Confirm