Modifying canned Defect Backlog report in RI , need help with filter using two different data items
One answer
Brandy,
The Request Area under has both Creation Date and LastUpdated for the work items. Did you want to do more with these fields. We've had teams use LastUpdated to tell the last time a work item was modified.
The Request Area under has both Creation Date and LastUpdated for the work items. Did you want to do more with these fields. We've had teams use LastUpdated to tell the last time a work item was modified.
Comments
Hi Michael,
I need to use both of them in ONE filter:
I need the filter to have an OR and a BETWEEN, I just do not know the proper report studio syntax for the below example:
creation date or last updated date between start date,end date
When you're in the Detail Filter Expression popup screen the Functions tab under Available Components has an Operators folder that lists all the options including BETWEEN, AND, and OR with examples of how to use them.
Thanks, ill give that a shot!