InfoQube IM - Community

Submitted by jan_rifkinson on 2009/12/02 13:25

Situation:

I have a lot of items that have duedates attached to them

Many duedates are way past bu tnot marked done

I'm trying to filter grid to show items w duedate range, i.e. between Jan 1 09 to present day

Is there any way to do this or do I have to go into my db & mark done on all past due dates & then filter 'donedates"?

thanks.

Jan Rifkinson

Ridgefield CT USA

Comments

So... to summarize :

- You'd like to see all items with due dates in a certain date range, but not marked done ?

You could use filter toolbar ...

something like :

And have the deactivated so that it'll hide "done" items.

Or you could use the filter text box and enter all parameters manually (and more precisely as you could determine the lower end limit for dates)

Something like : Duedate < #2009-12-01# and Duedate > #2009-01-01# and done is null

Tks Armando. The filter text box looks like the way to go. I was also thinking of

duedate = date for # of days in the filter toolbar but I don't know if IQ would continue advancing automatically as the current date changes, i.e. if I say I only want to see the next 14 days that as current day moves ahead, the end date moves ahead also so there's always a 2 week window. Hmmmm

Jan Rifkinson

Ridgefield CT USA

HP Blackbird Vista Ultimate SP-2

You can click the last range button on the DateFilter toolbar (the one with an x :) and enter 14 in the text box next to it. It will show 14 days. Click on Today to see the next 14 days.

More things already mentioned :

- The range button is not really "clickable" (no UI feedback -- except for focus going into textbox) which feels weird.

- Why 0 and Negative values in the range text box ? I don't see any effect on displayed items. Negative values could have a use though, if "enabled".

I think this may be FINALLY dawning on me & it was pretty simple to use.

Just to make sure I didn't miss any left over DateDue's,

in the Date toolbar, I filtered on "DateDue" < today

Clicked "1" as in days

clicked "x" which doesn't do give kind of feedback (weird) as Armando pointed out

added 14 days & voila I could see see all my items w DateDue for the next 14 days

This should give me the 'moving' range I wanted to see based on Today's date

It's logical if you want to use # of days to click on "1" as per day

week, month, etc + # of days doesn't make sense

Thanks Pierre & Armando

Jan Rifkinson

Ridgefield CT USA

HP Blackbird Vista Ultimate SP-2

The text filter was definitely the way to go.

And I think there is a problem w the date toolbar

For example, I asked it to show me all duedates < Jan 01, 2010 & it allowed items with duedates beyond 2010 into the grid

Jan Rifkinson

Ridgefield CT USA

HP Blackbird Vista Ultimate SP-2

This probably because you have something else than "Day" view enabled (like work week, week, month or year...) in the toolbar.

Pierre : we talked about this before -- there's something confusing about the day, month, year view in relation to the displayed data. This might not be easily improved though.

But there is one things we said should probably be changed (and maybe help understand these different date views):

- the today button could change depending on the view (today --> This week --> this month --> This year

Also :

- refresh should either be automatic or not. So that one should either click on refresh button to activate settings or, if not, get rid of that button if refresh is automatic.

One more thing ...

Jan : Pierre is right about the toolbar : you could achieve exactly the same thing I described (using the filter) but using the toolbar.

Set you first date as the lower end, and then set the duration from there in the duration "text box". I generally don't use that (because of the issues I just mentioned, I got the feeling that it didn't work properly) ... that's why it didn't came to my mind.