Forums > Questions

How would I form this search?

Author	Message
M	Posted: Aug 30, 2012 Score: 0 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 Admin	Posted: Aug 30, 2012 Score: 0 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 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 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?

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

Toodledo Forums > Questions