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