Reports : Filtering on CREATION_DATE in a Data Set?
I want to use a filter in a data set that only returns Work item rows that have a CREATION_DATE Greater than or Equal to 'yyyy-mm-ss 00:00:00.000'
The result is only on row but there should be hundreds? (like it is only doing the 'equal' part?)
fact LIVE_WORKITEM_CNT
parameterFields CREATION_DATE,WI_TYPE
selectedFields CREATION_DATE,CREATOR_NAME,WI_COUNT
I am not sure what other information to provide?
Is there a way to do this?
Thanks,
Steve
The result is only on row but there should be hundreds? (like it is only doing the 'equal' part?)
fact LIVE_WORKITEM_CNT
parameterFields CREATION_DATE,WI_TYPE
selectedFields CREATION_DATE,CREATOR_NAME,WI_COUNT
I am not sure what other information to provide?
Is there a way to do this?
Thanks,
Steve
5 answers
Rakik,
Maybe I don't understand your answer, but "...and use a BIRT data set filter to further filter out the workitems whose creation times do not match your criteria."
This is exactly what I am trying to do - use a BIRT data set filter but I only get ONE result row when there should be hundreds??
When I use the 'less than' I get many rows. When I use 'equal to or greater than' I get only ONE?
Is there a known issue with using BIRT data sets and filtering on CREATION_TIME
Thanks,
Steve
Maybe I don't understand your answer, but "...and use a BIRT data set filter to further filter out the workitems whose creation times do not match your criteria."
This is exactly what I am trying to do - use a BIRT data set filter but I only get ONE result row when there should be hundreds??
When I use the 'less than' I get many rows. When I use 'equal to or greater than' I get only ONE?
Is there a known issue with using BIRT data sets and filtering on CREATION_TIME
Thanks,
Steve
From:
act LIVE_WORKITEM_CNT
parameterFields CREATION_DATE,WI_TYPE
selectedFields CREATION_DATE,CREATOR_NAME,WI_COUNT
I see that you are using CREATION_DATE as a parameter. Don't use that.
Use the auto-added FROM_TIME data set parameter.
And set value of the parameter to the desired Time X.
Do a preview of the data set data.
Notice this will give you all workitems updated since X.
That is not good enough I guess because you want the workitems created since X. The list of workitems updated since X should be a super set of the list of updated work items since X.
So now you need to further filter out some work items. Use the data set filter page to create a filter. BIRT filter are used to remove rows from the data set.
act LIVE_WORKITEM_CNT
parameterFields CREATION_DATE,WI_TYPE
selectedFields CREATION_DATE,CREATOR_NAME,WI_COUNT
I see that you are using CREATION_DATE as a parameter. Don't use that.
Use the auto-added FROM_TIME data set parameter.
And set value of the parameter to the desired Time X.
Do a preview of the data set data.
Notice this will give you all workitems updated since X.
That is not good enough I guess because you want the workitems created since X. The list of workitems updated since X should be a super set of the list of updated work items since X.
So now you need to further filter out some work items. Use the data set filter page to create a filter. BIRT filter are used to remove rows from the data set.
Still struggling with this.
RE:'Use the auto-added FROM_TIME data set parameter.'
There is no auto-added parameter?
Only auto-added one is;
RESULT_SET_SIZE
Any additional help is appreciated.
I just need a count of defects created after a certain date with a certain severity.
Thanks,
Steve
RE:'Use the auto-added FROM_TIME data set parameter.'
There is no auto-added parameter?
Only auto-added one is;
RESULT_SET_SIZE
Any additional help is appreciated.
I just need a count of defects created after a certain date with a certain severity.
Thanks,
Steve
Correction:
the list of workitems updated since X should be a super set of the list of created work items since X.