Kinook Software Forum

Go Back   Kinook Software Forum > Ultra Recall > [UR] Suggestions
FAQ Community Calendar Today's Posts Search

Reply
 
Thread Tools Rate Thread Display Modes
  #1  
Old 10-16-2012, 08:48 AM
JGM22 JGM22 is online now
Registered User
 
Join Date: 06-24-2010
Posts: 130
Advanced Search

Is there a way to create an advanced search where the results would be tasks completed starting with Saturday and ending with Sunday.

Example, today is Tuesday, I would like the results to automatically provide the results starting with this past Sunday ( 2 days ago ) and to continue till this Saturday.

When next week arrives, the report will start over on Sunday automatically so the previous weeks results will no longer show up and only show next weeks results ( next Sunday thru next Saturday ).

Thank you for your time, most appreciated.

JGM
Reply With Quote
  #2  
Old 10-16-2012, 09:21 AM
kinook kinook is online now
Administrator
 
Join Date: 03-06-2001
Location: Colorado
Posts: 6,034
No, there isn't a way to search based on day of week.
Reply With Quote
  #3  
Old 10-16-2012, 09:34 AM
JGM22 JGM22 is online now
Registered User
 
Join Date: 06-24-2010
Posts: 130
Thx, I have hard coded the start/end dates and will change those every week.

Maybe this could be an item for future versions.
Reply With Quote
  #4  
Old 10-16-2012, 03:10 PM
quant's Avatar
quant quant is online now
Registered User
 
Join Date: 11-30-2006
Posts: 967
alternative

UR is full of workarounds.

The alternative, instead of having hardcoded dates which you need to change, create 7 searches, called monday, tuesday, ... where each search will have relative dates 1,2,3,... days from today. So if it's Tuesday today for example, you'll click on "Tuesday" search, which will do what you want ...
Reply With Quote
  #5  
Old 10-17-2012, 01:40 AM
JGM22 JGM22 is online now
Registered User
 
Join Date: 06-24-2010
Posts: 130
Quant - Thx for the suggestion.

I have been playing around trying to create the relative date searches without success. Here is my current setup:

Item is child of Completed (folder)
and Date Closed greater than or equal to 10/14/2012
and Date Closed less than or equal to 10/20/2012

I created a Wednesday Search. Since Sunday is always my day 1, then the Wednesday search would include Sun, Mon, Tue and Wed ( or go 4 days back ).

I cannot find a way to tell UR to show me 4 days from today ( Wednesday ).

If you have a moment, any assistance would be most appreciated.

Thank you in advance.

Joshua
Reply With Quote
  #6  
Old 10-17-2012, 04:39 AM
quant's Avatar
quant quant is online now
Registered User
 
Join Date: 11-30-2006
Posts: 967
"and Date Closed greater than or equal to 10/14/2012
and Date Closed less than or equal to 10/20/2012"

This is correct for today, name this search Wednesday and click on
"Store dates relative to current date". UR will encode the 10/14/2012 and 10/20/2012 as relative dates with respect to todays date. You will see that tomorrow this search will change automatically to

"and Date Closed greater than or equal to 10/15/2012
and Date Closed less than or equal to 10/21/2012"

Is that clear? If you hit this search next Wednesday, it will correctly search for the dates you need.
Reply With Quote
  #7  
Old 10-17-2012, 07:52 AM
JGM22 JGM22 is online now
Registered User
 
Join Date: 06-24-2010
Posts: 130
Thx, unfortunately I need the Sunday day to never change as the start date. Changing the dates is not a deal break. Much appreciated.
Reply With Quote
  #8  
Old 10-17-2012, 08:23 AM
quant's Avatar
quant quant is online now
Registered User
 
Join Date: 11-30-2006
Posts: 967
Maybe I don't understand.

Sunday day would never change, it would be the same for exactly one of your created searches that matches todays day.

If you create "Wednesday" search, it will be correct each wednesday. Creating 7 searches, and you are done, no need to mess up and manually update dates ever ;-)
Reply With Quote
  #9  
Old 10-17-2012, 01:30 PM
JGM22 JGM22 is online now
Registered User
 
Join Date: 06-24-2010
Posts: 130
Quant -

In one of your replies I noticed the start date changed from 10/14 to 10/15. Would that not make the start date now a Monday?

I am needing the starting date ( Sunday ) to always be a Sunday and the ending date to always be a Saturday.

Basically whatever items I report on that the current week ( Sunday thru Saturday ) is what I am looking for. Then when next week begins it will reset to next Sunday thru next Saturday automatically.

I created the search like you suggested and clicked Store dates relative to current date. Problem is I do not want a rolling 4 days, it needs to be fixed.

Sunday search shows Sunday results
Mondays search shows Sunday and Monday results
Tuesday search shows Sunday, Monday and Tuesday results.
...
Saturday search shows Sun, Mon, Tue, Wed, Thu, Fri, Sat results.

Then the next week begins with Sunday and only things I close starting the next Sunday will show up on the search.
Reply With Quote
  #10  
Old 10-17-2012, 02:48 PM
quant's Avatar
quant quant is online now
Registered User
 
Join Date: 11-30-2006
Posts: 967
"In one of your replies I noticed the start date changed from 10/14 to 10/15. Would that not make the start date now a Monday?"

- yes it would change tomorrow (it will be Thursday tomorrow), but you don't care because the search item is called "Wednesday", so you use it for your purposes only on wednesdays, on any other day it wouldn't do what you want. So when next wednesday comes and you click on this item it will do exactly what you want, because the start date will be 10/21, exactly what you need.

So all that's necessary is to create such search item for each day of the week and you are done for good. You canno't achieve what you want with a single search item, you need 7 of them, and use the correct one on a given day!
Reply With Quote
  #11  
Old 10-17-2012, 03:16 PM
JGM22 JGM22 is online now
Registered User
 
Join Date: 06-24-2010
Posts: 130
Quant - Thx for the time and explanation, most appreciated. I have created the 7 days of searches and will try them out, thank you again.

It would be a whole lot easier if there were variables we could use such as @today, @tomorrow, @yesterday, etc.
Reply With Quote
Reply


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off



All times are GMT -5. The time now is 06:43 PM.


Copyright © 1999-2023 Kinook Software, Inc.