0

Current Day filter

Tommy Kiser

March 26, 2009 17:21

None

Follow

Right now the 'today' token resolves to the current date when you save it in a filter.  Would like a dynamic 'Current Day' option for filters so that any time you look at the page it will always filter for that particular day.

Would also be nice to have a 'yesterday' and 'tomorrow' that work this way, or to allow simple operations, such as 'current date + 5 days' or 'current date - 1 week'.

I think I've emailed about this feature before, but the priority for this kind of filter just got escalated - would be very useful in getting some of our important weekly production reports into SG.

Thanks,

-T

• Facebook
• Twitter
• LinkedIn

11 comments

• 0
  
  Rob Blau March 26, 2009 18:41

  bump.  :)
  
  We're trying to get some weekly views of data, and while we can get something like 'tasks due this week', we can't get something like 'tasks active this week', ie "Start is before end of current week" and "End is after start of current week".

  -r

• 0
  
  Don Parker March 27, 2009 06:35

  Hey guys, this is included in the 1.7 release.  We're calling them "floating days", and you can choose "yesterday", "today", and "tomorrow".  If you choose the current date from the calendar, we then insert the explicit date instead of "today".  Behold:

  

  You can check this out in the the 1.7 screencast.

• 0
  
  Rob Blau March 27, 2009 15:44

  Don, would that address the case I have, where I want a rolling weeklong window covering the current week?

• 0
  
  Mike Romey March 27, 2009 17:47

  You would probably want filter like these:

  - Most Current

  - Most Current Day

  - Most Current Week

  - Most Current Month

  This is an interesting subject and directly relates to my topic about a scheduling gap report.  I recenlty completed coding the gap report and in order to do so I had to do some weird stuff just like what Rob Blau had mentioned.  I had to do something like ["Start", "is before", date] and ["End", "is after", date] .  It became even more of a cluster in that I needed the ability to do a more specific condition.  It would be nice to also include the following conditions"

   - "is on or before"

   - "is on or after"

   

  -Romey

   

   

   

• 0
  
  Don Parker March 27, 2009 18:54

  Rob, good point.  You can filter [end] [is in calendar week] [current], but that doesn't really get you want you want.  Maybe we add floating days for each day of the current week?  See the enclosed screen.

  

  
  Mike, would this also address the scenarios you are thinking about?

  
  I know Tommy also want's the offset:  (today + 3d)

  
  Then what else would we be missing?

• 0
  
  Rob Blau March 27, 2009 21:06

  That would be enough for me to do the things I've wanted to do.  As an aside though, if you're familiar with perl's Time::ParseDate library (http://search.cpan.org/~muir/Time-modules-2003.0211/lib/Time/ParseDate.pm), something akin to that would blow me away (there aren't many things I miss about perl, but that library is one).  Using that kind of flexible time specifer with conditions akin to '=', '<', '<=', '>', '>=', '<>' would do anything I could think of.

  -r

• 0
  
  Mike Romey March 27, 2009 21:58

  Don,  the offset would be great, but does not necessarily simplify the issue.  Without '<=', '>=' it gets sticky trying to filter out a day.  Here is an example:

  ['start_date', 'is before + 1d', date] and ['due_date', 'is after - 1d', date]

  When all that is really needed is '<=' and '>='. or  "is on or before" and "is on or after"

  Rob, Looking over the Time::ParseDateLibrary.   They have some really good stuff.  The examples are great.  Personally I kinda prefer more traditional conditions like '=', '<', '<=', '>', '>=', '<>'

   

  -Romey

   

   

• 0
  
  Don Parker April 02, 2009 05:39

  Romey, can you give me some real world examples of the type of report you'd be trying to make with those queries?  I'm trying to get my head around what's missing...

  
  I suppose we could have a text field for conditions, though I'm just curious where the UI falls over (thinking about all those non-technical folks building queries).

• 0
  
  Don Parker April 02, 2009 05:44

  FYI, this is ticket 6913 on our end.

• 0
  
  Eli Rarey January 15, 2010 00:49

  I want to add my vote for a "today + 3d" feature...

• 0
  
  Gavin Greenwalt January 18, 2010 20:43

  Just bumped into this 2 days ago too.   +#d would be great.