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

Questions
Tags
Users
Badges
Rao Shines
(159●4●51●62) 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

0 votes

3 answers
8,236 views
0 votes

Accepted answer

Permanent link
Ralph Schoon
FORUM ADMINISTRATOR / FORUM MODERATOR / JAZZ DEVELOPER (64.6k●3●36●49) 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

1 vote

2 other answers

Permanent link
Rao Shines
(159●4●51●62) Jul 25 '16, 4:38 a.m.
 Thank you Ralph,

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

0 votes

Comments
David Lafreniere
FORUM MODERATOR / JAZZ DEVELOPER 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).

2 votes

Rao Shines
Jul 28 '16, 7:56 a.m.
 Thank you David

Ralph Schoon
FORUM ADMINISTRATOR / FORUM MODERATOR / JAZZ DEVELOPER Jul 28 '16, 8:01 a.m.
Thanks David! I was not aware of all that.

Permanent link
Bhagath P B
(443●8) 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.

1 vote

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
× 11,106
× 1,210
× 202
× 152

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

Question was seen: 8,236 times

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

Confirmation Cancel Confirm