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

QueryBuilder: how can I specify the time along with the date in a query?

I and building a query (Eclipse client, 4.0.5) and I can set Creation Date after (including) and select the Specific Date from the calender picker.  I can also do the same for Creation Date before (including).

My query is ... how can I add the time?  For example, if I do after (including) April 22, 2014 and before (including) April 22,2014, if I look at the actual string in the Work Items view, it says:
Type is Task & Creation Date after (including) April 22, 2014 12:00 PM & Creation Date before (including) April 22, 2014 12:00 PM

In theory, that should be ONLY Task work items created EXACTLY @ 12:00 PM, right?  But it is not, because I get a list of them  with different times:
131217:Apr 22, 2014 11:56:24 AM
131220:Apr 22, 2014 3:23:52 PM
131221:Apr 22, 2014 4:01:51 PM

So how do I specify in the query builder the TIME to use?  Is there a way?  If not, then is the description in the Work Items view inaccurate?

Susan

0 votes


Accepted answer

Permanent link
Hi Susan,
The query on specific time function is not available in RTC yet.
However an enhancement request has been submitted https://jazz.net/jazz/web/projects/Rational%20Team%20Concert#action=com.ibm.team.workitem.viewWorkItem&id=243188. From the comment 1, a workaround is also provided to query the single hour by doing a before and after criteria on the same number of hours.

Susan Hanson selected this answer as the correct answer

0 votes

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.

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,019

Question asked: Apr 23 '14, 7:45 a.m.

Question was seen: 3,237 times

Last updated: Apr 23 '14, 8:31 a.m.

Confirmation Cancel Confirm