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

Modifying canned Defect Backlog report in RI , need help with filter using two different data items

Questions
Tags
Users
Badges
Brandy Guillory
(53●1●19●25) May 21 '14, 4:19 p.m.
Hi I need a filter that is something like : creation date or last updated date between start date,end date. I have searched for more filtering tutorials for this to no avail. If anyone has any ideas, that would be great.

0 votes

1 answer
8,305 views
0 votes

One answer

Permanent link
Michael Walker
(992●15●202●157) May 21 '14, 4:24 p.m.
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.

0 votes

Comments
Brandy Guillory
May 21 '14, 4:28 p.m.
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

Michael Walker
May 21 '14, 4:38 p.m.
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.

Brandy Guillory
May 21 '14, 8:35 p.m.
Thanks, ill give that a shot!

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
× 12,145
× 51

Question asked: May 21 '14, 4:19 p.m.

Question was seen: 8,305 times

Last updated: May 21 '14, 8:35 p.m.

Confirmation Cancel Confirm