Rational Insight Report filter and parameter usage
Hi,
How fetch workitems created in between certain date. suppose we are having two parameters for report like START_DATE and END_DATE and we want to have all workitems created in between those specified START and END parameters dates. We have specified parameters as shown below: [Start Date]in?Creation date? [End Date]in ?Resolved Date? 
but this does not provide us expected data result, it is not providing us the workitems created in between specified date range of START and END date parameters. Also, we having two TimeStamp values columns which shows the Date and time of One state (suppose at NEW state) and date and time of changed state (Suppose at In progress state) we want have the diffrence between these Timestamp values in Hours, for eg. if workitem changed from NEW to In Progress state from 16 Mar, 2015 1:00 PM to 16 Mar, 2015 5:00 PM so we want result as 4 hours in display coulmn. Thanks and regards, Suyash |
Accepted answer
Your filter needs to look like this:
[Start Date] >= ?Creation date? AND [End Date] <= ?Resolved Date? However, if a workitem does not have a Resolved Date, I expect the Resolved Date will be NULL, so it will not be displayed. If you want to handle that then you can use: [Start Date] >= ?Creation date? AND ([End Date] <= ?Resolved Date? OR [End Date] IS NULL) Suyash adsul selected this answer as the correct answer
|
One other answer
|
For DB2 you can use the timestampdiff function to create a new query calculation. For example:
timestampdiff (8, char([END_DATE] - [START_DATE]) ) You may have to cast the dates: timestampdiff (8, char(timestamp([END_DATE]) - timestamp([START_DATE])) ) |
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.