+ Add Suggestion

Allow boolean operators (AND, OR, NOT) in custom queries

JW

I would really like to set my home page to search for
Overdue, Today OR @mylabel

and to be able to search for @label1 OR @label2

and to be able to exclude certain criteria from my search, e.g. Today NOT @work

Currently, the logic seems to be to OR criteria of the same time (i.e. Overdue OR Today), and to AND criteria of different types Today AND @mylabel.

Greater flexibility in searches would make ToDoist much more powerful.

All responses

JW
Julie Wills
Replied on Jun 24, 2011 - 20:59

That was supposed to be "criteria of the same TYPE"

DG
Dmitry Glazunov premium
Replied on Aug 01, 2011 - 22:20

I'm absolutely agree with Julie Wills, I realy need these features too. Especially to be able to search for @label1 OR @label2

Thomas Stumpp premium
Replied on Sep 01, 2011 - 00:48

I want that, too.

D
DM
Replied on Sep 28, 2011 - 15:08

+1

BM
Billy Meyers
Replied on Oct 08, 2011 - 04:04

Yes! The current implementation of AND vs OR seems quite random. For example, if I do a query for 'today, p1' it returns 'today' and 'p1' in two different sections. But if I search 'today, @label' it returns one section of 'today AND @label'. Would love greater flexibility in this.

BF
Ben Floyd
Replied on Oct 31, 2011 - 11:32

+1

A reverse operator would be nice:

!@home

Exclude anything with that label, in cases where they overlap

NB
Nick Bell premium
Replied on Nov 18, 2011 - 21:44

This for me is a `killer missing feature', and one I am surprised at.

Need consistency across search types (priority, labels, due date, and combinations of these) and full AND/OR (perhaps & and | ?) and NOT (!) with parentheses indicating precedence.

NOT is a key feature for me actually - the ability to exclude @home tasks from when at work (perhaps !@home), and @work tasks when at home (perhaps !@work).

Then would like smart searches or the ability to retrieve old searches.

AS
Aristoteles Soares Benicio
Replied on Nov 20, 2011 - 15:55

Since many tasks has more than one label and others just one, the option "only" or "exclusive" in queries would be a good idea too.

U
Unknown
Replied on Dec 07, 2011 - 22:08

I also would like an exclusion and logic (And, OR)... I have a shortcut to Tasks for @work, then @home and more... but sometimes I forget to add a label, so when I go to my @work list it does not show the ones I have not added a label for so I forget them!!

So I need to list tasks for @work but also show tasks without labels

So something like "@work OR -label" or "@work OR -@*"

BZ
Björn Zinkler
Replied on Dec 18, 2011 - 22:02

+1

This is a very important feature, e.g. for GTD implementations like

overdue OR today OR @na

Кирилл Моисеев premium
Replied on Jan 16, 2012 - 23:08

I would also be greate to save filter rules in sets.

PM
Paul Masri premium
Replied on Jan 24, 2012 - 00:24

I like the 'minus' notation for excluding.
e.g. "today, overdue, -@waiting"
so I can see all today's & overdue tasks except those that I'd labelled as "waiting on someone".
This fits with Google's notation for excluding things from searches.

JC
Joel Cohen premium
Replied on Mar 06, 2012 - 05:35

Hi,

This is a great idea. Emulating popular search systems like google would also make the queries more intuitive.

Joel cohen

J
Jennifer
Replied on Mar 13, 2012 - 12:42

Please! Me too.

E
eskey premium
Replied on Mar 15, 2012 - 23:58

I vote for it as well.
My priority is to filter out not only some labels but also particular projects, so query like

today, overdue, NOT specific-project

But any kind of OR/AND/NOT operators would be very useful.

SD
Shiri Dori-Hacohen
Replied on May 23, 2012 - 03:12

OR is really critical for proper evaluation of my GTD contexts. I'm in my home office - means I have the context of phone OR email OR home, etc.

NOT would certainly be useful as well!

J
j.o premium
Replied on Jun 28, 2012 - 13:14

One thing that has not been mentioned is that these operators would be handy when printing.

Todoist produces nice printouts but in order for these to be truly useful we need to be able to do some filtering. Many times I have great Work lists that I can't print from Todoist because it may be showing some Home items and viceversa. Simple operators to hide or show by date, priority, category and labels would go a very long way, and it truly seemed that these would be a given when I first signed up because Todoist has that smart query box.

P
Pansy
Replied on Oct 19, 2012 - 09:02

Agree! I really need the AND operator, I always need to see today's task of high priority

SD
Shiri Dori-Hacohen
Replied on Oct 19, 2012 - 15:21

Actually, Pansy (and everyone), the AND operator is the default on the search bar so you can use it simply by putting two labels. It's the OR/NOT that are really missing.

SD
Shiri Dori-Hacohen
Replied on Oct 19, 2012 - 15:21

Sorry, at least that's my impression. Best to check for yourself as the OP states something slightly different.

P
Pansy
Replied on Oct 19, 2012 - 15:30

Thanks Shiri but I I've just retried it. When I write "Monday !p2" it shows all the tasks on Monday in addition to all the tasks with priority 2, but I need it to display only the tasks on Monday that have priority of 2.

David Trey staff
Replied on Oct 20, 2012 - 01:18

Hello,

the default operators are currently:

AND - if you include any label in your search, for example - "tomorrow, @label" will query for items due tomorrow which have this particular label

OR - for non-label-related queries, for example - "tomorrow, !p1" will return two results - a list of tasks due tomorrow and a list of priority 1 tasks

Adding a label to any query will only display results that contain this label so a "tomorrow, !p1, @label" query will display two lists:
- tasks due tomorrow with the @label
- tasks with priority 1 and the @label.

Of course we will consider adding more operators in the future or at least enable a choice of what operator to use in any situation.


Best regards,
David

JW
Julie Wills
Replied on Oct 20, 2012 - 03:27

Hi David

Thanks for the clarification.

Could you please give us a bit of an insight into the development cycle, and how decisions are made about how enhancement requests get prioritised?

The reason I ask is that I see that this request is in the top 5 as far as votes are concerned, and was requested 16 months ago. In fact, all of the top 5 were requested within about a month of each other.

Do you have a place where you publish planned future features?

David Trey staff
Replied on Oct 20, 2012 - 03:37

Julie,

there is no specific rule on how we decide what feature to add next. Of course, the amount of votes is an important factor, but there are other things to consider such as what order would be most efficient to implement these features without having to make many changes once the next feature will be added.

We've already implemented some of the most requested features (you can click on the "Completed" link at the top of the Votebox) and will continue to add further features in the future.

You can follow us on out Facebook, Google+ or Twitter channels where we announce all new features once they're implemented.


Best regards,
David

W
Wmarques premium
Replied on Dec 03, 2012 - 11:40

Please also consider the comments posted on the support-page.
(i.e. http://todoist.com/Support/showQuestion/3164/ )

Rather than adding query complexity, just turn it into a fool-proof 'find-tool" , in the style as we know from the blockbuster-progams of MS and alikes

NJ
Nick JH premium
Replied on Dec 09, 2012 - 15:01

I agree more complex queries are really needed. Including the ability to search by project.
For example:
Find everything in my WORK project and all sub projects (or maybe excluding my HOME project and all sub projects) which is either [priority 1 and is due in the next 6 days] or [has no due date].

Jake Love premium
Replied on Dec 14, 2012 - 01:36

I would LOVE this feature!!! Please!

SZ
Sabeer Zaman
Replied on Jan 06, 2013 - 11:00

I'm migrating from another web-based task management system to Todoist, and Todoist completely wins out in terms of a great UI... but literally the ONLY thing holding me back from signing for a Premium account right now is the lack of a flexible query system. The moment boolean operators are implemented, I'm all in!

Another related query operator that I would find helpful is to be able to filter by multiple projects.

SD
Shiri Dori-Hacohen
Replied on Feb 21, 2013 - 18:30

At the risk of spamming everyone who ever commented on this item, please please PLEASE get those OR/NOT operators working on labels... it's so critical and (I believe) shouldn't be all that hard to implement... and yet so highly valuable.

C
cardiffdevil premium
Replied on Feb 22, 2013 - 21:31

I feel compelled to weigh in here. Several hundred people have voted / commented on the inadequacies of the currently implemented label / filter / project queries.

1. Ability to save named queries
2. Boolean operators
3. Queries on main project group folder should include all items from all subgroups unless explicitly excluded.
4. These features should be consistent across all platforms. (at the moment, I can save queries on Android, but not on Chrome!!)

As an example, I want to be able to query my to do list and:
- Include only tasks which relate to work (For me, I have a master project named after the company I work for- I want to include all the subproject tasks under this master project)
- sort these tasks in order of priority from P1 to P4
- filter according to what sort of action is necessary (I do this according to label e.g @to_buy, @phone, @email, @research, @plan, etc.)

The result is a list of all the people I need to phone, in a work context, sorted according to priority.

I can (mostly) get the results I want by using a rather cumbersome query string, but I don't want to have to type it in every single time I need to flit between phoning people and drafting emails.

This is a simple fix, which has quite a lot of demonstrated demand. Let's make it happen.

RC
Reid Curry premium
Replied on Mar 03, 2013 - 18:28

saved queries would be wonderful.

karen t
Replied on Mar 18, 2013 - 05:46

+1 for logical operators in queries

I need to implement 'hotlist' type filters, which operate across dates, priorities and labels - as per my current task manager - such as

(Overdue OR Today OR (This Week AND (p1 OR p2)) OR (Next Week AND p1)) AND NOT @outsourced

A
Andrey
Replied on Mar 21, 2013 - 00:21

Logical operators are really needed. Hope this function will be realised.

W
will premium
Replied on Mar 26, 2013 - 21:43

+1 for showing tasks that aren't labeled.

-@ or !@ or <>@

TS
Thomas Serio premium
Replied on Mar 27, 2013 - 13:23

This really is a killer missing piece. It's the main reason I don't sign up for premium.

Every once in a while I'll get an email from Todoist and come back to play around with the site, thinking "Why aren't I using this for my tasks? This UI is great!"

Then I try search and remember, "Oh yeah, that's why..."

AK
Alex Kopyov premium
Replied on Apr 06, 2013 - 09:37

Adding my vote to the above. I payed for Premium before realizing the limitations of search. My most desired features in equal order of importance:
- Ability to save searches.
- Ability to specify all task parameters (such as Project) in the query
- Search subprojects (that goes for the standard project view as well)

Amir Salihefendic staff
Replied on Apr 10, 2013 - 18:23

We have made a proposal for extending our filters and make them much more powerful. We plan to implement this across all of our supported platforms (including mobile) - - and we will also make it possible to save and update your filters (so it can fit your workflow).

Some example filters
=================
Things that are due today and tomorrow and that are labeled with work label:
(today, tomorrow) & @work

Today's tasks that are not work related:
today & !@work

Please read our full specification here:
http://cl.ly/text/2d0P3i0k2V11

We would love to hear your feedback!

Best regards,
Amir

AK
Alex Kopyov premium
Replied on Apr 10, 2013 - 18:36

Awesome news! That would really extend the capabilities of Todoist leaps and bounds. Custom saved searches allow such powerful adaptation to one's work habits.
Couple of concerns - I understand that manual ordering is impossible in a dynamic list, but please make sure you keep the manual order functionality in regular lists.
Ability to search by List would be great, although if the feature where new tasks inherit the properties of the list will be implemented, it would work just as well.

W
will premium
Replied on Apr 10, 2013 - 19:33

Awesome news, for sure! Agreed with Alex on all accounts. Search by list is next on my wish list.

RC
Rune Christensen
Replied on Apr 11, 2013 - 01:30

Great news! Now I'm curious about how fast your development cycle is for such a change....

Amir Salihefendic staff
Replied on Apr 11, 2013 - 10:47

We are doing a lot of things right now so it's very hard to estimate when we will be finished with this. But hopefully soon.

Regards,
Amir

C
ComInf&Pro premium
Replied on Apr 17, 2013 - 08:55

Hi,
A simple text search in the task AND the note with words that are not keywords
Regards

Andreas N. premium
Replied on May 12, 2013 - 10:41

Very good news!

Aaron Barbosa premium
Replied on May 12, 2013 - 17:02

Yeah! Great Idea and good news!
I think this feature will help mainly the visualization in cell apps.
Waiting...

Brendon Wadey staff
Replied on May 21, 2013 - 15:09

This has now been rolled out!

Thanks,
Brendon.

Jake Love premium
Replied on May 21, 2013 - 23:38

Only one issue that I see: you cannot rearrange items through the week if you're using a combo such as " (overdue, 7 days) & !@work " as you would have to go back to " overdue, 7 days ".

I absolutely love this new feature, but it sorta takes the bang out some if I cannot rearrange my schedule in that view.

Any chance this could be rolled out?

David Trey staff
Replied on May 22, 2013 - 06:46

Hello Jake,

Thank you for your feedback, we'll consider enabling such option.


Best regards,
David

PB
Patrick Bode premium
Replied on Jun 07, 2013 - 16:25

Love the new boolean operators, however, it would be nice to be able to exclude certain projects.

For instance:
@label & !#project

(Excuse me if this is possible and I'm just not formatting it correctly)

David Trey staff
Replied on Jun 07, 2013 - 16:48

Hello Patrick,

This is not possible right now, but we'll consider adding it in the future.


Best regards,
David

KM
Kevin Murray premium
Replied on Jun 08, 2013 - 00:17

One combination that I haven't found is adding label and project, as in "@work or #current". Is this possible or something for the future?

David Trey staff
Replied on Jun 08, 2013 - 06:07

Hello Kevin,

It's currently not possible to use projects as search criteria, but we'll add such option in the future.


Best regards,
David

JW
Jamie Williams premium
Replied on Jul 10, 2013 - 12:11

Projects as criteria, and excluding criteria are the biggest missing things for me. Glad to see it's being worked on - the proposal document looks good!

chrisonline1205 premium
Replied on Nov 13, 2013 - 12:35

Any news about using projects as search criteria ?

Brendon Wadey staff
Replied on Nov 13, 2013 - 13:29

Hi,

Unfortunately we do not have any updates at this time.

Regards,
Brendon.