ForumsQuestionsHow would I form this search?


How would I form this search?
Author Message
M

Posted: Aug 30, 2012
Score: 0 Reference
I think I'm overthinking this. I have a saved search that returns tasks WHERE
(CHECKED = NO
AND STARRED = NO
AND (START DATE IN THE NEXT 9 OR DUE DATE IN THE NEXT 9)
AND FOLDER = NO FOLDER)

I want to add "OR (START DATE DOESN'T EXIST AND DUE DATE DOESN'T EXIST)"

But I can't figure out how to do that in a SEARCH.

Anyone? It's probably easy, but I'm thinking too hard and overwhelming myself!
Jake

Toodledo Founder
Posted: Aug 30, 2012
Score: 0 Reference
I think the best place to put this is in with the 3rd row.

(CHECKED = NO
AND STARRED = NO
AND (START DATE IN THE NEXT 9 OR DUE DATE IN THE NEXT 9 OR START DATE DOESN'T EXIST OR DUE DATE DOESN'T EXIST)
AND FOLDER = NO FOLDER)
Purveyor

Posted: Aug 30, 2012
Score: 0 Reference
At the top of the Search, choose "Match Any of the following criteria".
You'll then be able to create a Search that has two sets of "AND" statements with an "OR" in between.
M

Posted: Sep 08, 2012
Score: 0 Reference
Jake -- so simple. I think that's it.

Purveyor -- thanks. I do forget about the "Match any" "Match all" at the top, but I think I actually want the "Match all," in this case. I often have to think very very hard about how to form my searches. Any chance of - someday - adding the ability to just write simple SQL to form a search?
You cannot reply yet

U Back to topic home

R Post a reply

To participate in these forums, you must be signed in.