Legend

Forum

Unread topics or posts

Topic

Unread posts

Locked

Announcement

Forums > Questions

How would I form this search?



AuthorMessage
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?
You cannot reply yet


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



Toodledo Forums > Questions

Contact Us | Blog | API | Jobs | Press | Documentation | Forums Privacy | Terms | Copyright © 2004-2014