ForumsQuestionsHow would I form this search?
How would I form this search?
| Author | Message |
|---|---|
|
M |
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 |
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 |
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 |
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.