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

Due Date is off by one day when filtering

Questions
Tags
Users
Badges
Robert Myers
(19●11●16) Sep 18 '14, 11:26 a.m.
Today is Sept 18, 2014 at 4 pm GMT. JTS is based in GMT -5. Due Date on WI is set to Sept. 19, 2014 12:00 PM (noon) (tomorrow).  RTC 5.0.1 Query filter is 'Today' and Work Item is displayed with Due Date = Sept. 19, 2014
If I set Query filter to tomorrow, WI is not found
Why?

0 votes

1 answer
6,416 views
0 votes

One answer

Permanent link
Eric Jodet
JAZZ DEVELOPER (6.3k●5●111●120) Sep 24 '14, 8:53 a.m.
 Hello Robert,
it makes a long time I wanted to answer this one - but due to workload...
So, sorry for the delay.

Though I can not answer our question, I debugged the code and tried to query on due date "today" and "tomorrow".

Today: we create a time span from - date today - from 00:00:00.0 to 23:59:59.999
with a calendar created in Client's time zone (in your case, your time zone, in my case, Europe / Paris)

Tomorrow: same but with date set to tomorrow - but same time span

Now - when you - as  a WebClient - sets the due date to tomorrow 12PM - noon - we store this values based on your Client / context time zone and convert to zulu time.
Ex: for me, Europe / Paris, my context time zone is GMT + 2
So if I set due date to tomorrow 12PM, it will be stored to tomorrow 10 AM GMT - zulu

Now I don't know what is your time zone - but you may check what is the value of due date that you set using Firefox and Firebug.
1 - set a due date to to tomorrow 12PM - noon
2 - save
3 - open Firebug - net tab
4 - re-load the work item
5 - expand the answer for the getWorkItemDTO2 call

Not sure it helps right now, but we'll find an explanation.

Eric

0 votes

Comments
Robert Myers
Sep 26 '14, 11:44 a.m.
Not able to find JSON Tab.  How do I do that? I found one reference to getWorkItemDTO2 in Script but that is probably not helpful. var _50=new _2(_4c,"success","failure"); this._invokeWorkItemService(_50,"getWorkItemDTO2",_4b); },postWorkItem:function(_51,_52){ if(!_52.stateId&&!_52.projectAreaItemId){ this._setAppArgsProjectAreaItemId(_52); }

Eric Jodet
JAZZ DEVELOPER Sep 29 '14, 1:43 a.m.
 Hello, JSON tab is available from Firebug window. Please ping me on ST if needed. Eric

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

Question asked: Sep 18 '14, 11:26 a.m.

Question was seen: 6,416 times

Last updated: Sep 29 '14, 1:43 a.m.

Confirmation Cancel Confirm