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

How to apply filter on creation date while creating report in rational insight

Questions
Tags
Users
Badges
Suyash adsul
(9●12●18) edited
May 26 '14, 8:41 a.m.
We have created WI query (All defects closed Today, All defects raised Today) and based on that we want to create report in rational insight with same query result and want to daily send mail to project manager.

We have created report by using report studio however stuck where we have to apply filter on creation date.

Please suggest us how do we can proceed with this.

Thanks and regards,


0 votes

2 answers
10,861 views
0 votes

Accepted answer

Permanent link
Francesco Chiossi
(5.7k●1●11●19) May 26 '14, 8:07 a.m.
Hello Suyash,

to filter the query on the current date you can do the following:
  1. In report studio open the query that populates your report
  2. From the Toolbox drag and drop a Filter item to the Detail Filters section
  3. Use this expression for the filter: cast ([Creation Date], date) = current_date

Basically you transform the Creation Date from Timestamp to date format (using cast) and compare it with current_date that returns the date of Today.

Here a screenshot for reference:


Best Regards,

Francesco Chiossi

Suyash adsul selected this answer as the correct answer

3 votes

Comments
Suyash adsul
May 27 '14, 3:43 a.m.
Thank you so much Francesco.... it works fine now :)

1 vote

Brandy Guillory
May 27 '14, 4:46 p.m.
Hi Francesco , this was a great help to me also as I needed the same filter for my report. Also will an OR  filter have to be added along with cast([Resolution Date],date) = current_date to pick up work items closed or open on the current date? Also in your above example can you explain what the "creation date" and "creation date only" attributes are for , why do you have two?

1 vote

One other answer

Permanent link
Francesco Chiossi
(5.7k●1●11●19) edited
May 28 '14, 5:35 a.m.
Hello Brandy,

I'm glad you found it useful.

Yes, my was just a conceptual example, if you want to list both open and closed work items on the same query you would need an or condition.

Concerning my example:
  • [Creation Date] = [Business View].[Request].[Creation Date]
  • [Creation Date only] = cast ([Creation Date], date)
  • [Today] = current_date

I found it useful to build my filters from pieces I create in separate data items, so I can see the values of the expressions that I want to compare, for debugging purpose. Of course [Creation Date only] and [Today] can be safely removed from the production report.

Best Regards,

Francesco Chiossi

0 votes

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
× 485

Question asked: May 26 '14, 6:32 a.m.

Question was seen: 10,861 times

Last updated: May 28 '14, 5:35 a.m.

Confirmation Cancel Confirm