Kinook Software Forum - Need help with search

Kinook Software Forum (https://www.kinook.com/Forum/index.php)

- [UR] General Discussion (https://www.kinook.com/Forum/forumdisplay.php?f=23)

- - Need help with search (https://www.kinook.com/Forum/showthread.php?t=1558)

PureMoxie

02-16-2006 12:12 AM

Need help with search

I'm having trouble figuring out the indenting for the following "Due Soon" search. I'll write it as I would in SQL.

(Due Date <= 2 weeks from today AND Due Date > today) OR (Begin Date <= 2 weeks from today AND Begin Date > today) AND Flag != Completed

Also, perhaps in a future version we could have an Advanced-Advanced search where we can just enter queries directly?

kevina

02-16-2006 07:52 AM

I assume you really intend this:

((Due Date <= 2 weeks from today AND Due Date > today) OR (Begin Date <= 2 weeks from today AND Begin Date > today)) AND Flag != Completed

This is slightly different than what you specified (the extra parentheses make the Flag criteria always required and only on of the other expressions). If so, below is how you would define the Advanced Search:

Code:

Flag != Completed

    AND DueDate <= #2 weeks from today#

    AND DueDate > #today#

        OR BeginDate <= #2 weeks from today#

        AND Begin Date > #today#

dasymington

02-16-2006 05:39 PM

Re: Need help with search

Quote:

Originally posted by PureMoxie
Also, perhaps in a future version we could have an Advanced-Advanced search where we can just enter queries directly?

Yes, I'd like that. I can quickly think of how I'd write a query but it takes a bit of time working out the indents needed in Ultra Recall. This is one area where UR is not easy to use.

All times are GMT -5. The time now is 07:59 AM.