Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

Next challenges

Recent achievements

  • Global
  • Personal

Recognition

  • Give kudos
  • Received
  • Given

Leaderboard

  • Global

Trophy case

Kudos (beta program)

Kudos logo

You've been invited into the Kudos (beta program) private group. Chat with others in the program, or give feedback to Atlassian.

View group

It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

Can you filter by X OR Y rather than X AND Y?

It seems like I can only filter by either color OR by due date attributes, not both. i.e. when I filter by the green colored cards that works, but then if I also check that I want to filter by cards that are due in the next day, then nothing shows up, which leads me to believe it's filtering for ALL criteria rather than ANY.

Is there any way to change this? What I want to do is show all the cards that are green, AND all the cards that are due in the next day, though none of those cards will be green.

2 answers

1 accepted

1 vote
Answer accepted
Iain Dooley Community Leader Jan 13, 2019

@Manon Soubies-Camy @Lindsey_Ross search modifiers don't work in filters, only the search.

The reason it looks as though it's working is because the card that's due actually has the word due in the title.

All board level filters are "AND" and not "OR", however the search is "OR" rather than "AND".

So what you can do to see a list of cards that match "due this month with label green" on a given board is:

board:"board name" is:open due:month label:green

will show you a list of cards on a given board that are not archived that are due within the next month OR have the green label.

You can save searches if you have a paid plan, you can also open the search results in a new tab and copy the URL which is what I do anyway even when I have Trello gold because there are no saved searches on the iOS app.

I just create a card called "Saved Searches" and link to each of my saved searches from there if I need them so that I can access them from iOS devices.

Hi @Iain Dooley,

The reason it looks as though it's working is because the card that's due actually has the word due in the title.

That explains a lot - thanks! :)

Like Iain Dooley likes this

Thanks for clarifying the difference between the filter and the search terms--and saving the search as a card does seem like a great workaround for iOS!

Hello @Lindsey_Ross,

Is the below query not working on your boards?

due:day OR label:green

I can successfully filter by due date or color on my boards:

trello.png

Hope this helps!

- Manon

No, I think that's the same thing I was doing. That only brings up cards that have BOTH criteria (due today, and green). I want to show all cards that have EITHER criteria. i.e. I made a test card that's due today, but with no color label. I want a query that will show this card, AND all the cards I've labeled green.

Hi @Lindsey_Ross,

Hm I think it is working, check the second column in my screenshot: you can see both a green card and a yellow (i.e., not green) card due today.

I see, I may have just been using the wrong syntax. If I say "due: this month or label: green" then it does seem to work for me.

 

Now what I'm wondering is, is there a way to save this filter combo so that I can easily shortcut to it? Say if at the beginning of each week I want to hit this filter without having to type that whole thing in?

Suggest an answer

Log in or Sign up to answer
TAGS
Community showcase
Published in Trello

📹 What is Trello?

Hello Community!  My name is Brittany Joiner and I am a Trello enthusiast and Atlassian Community Leader. I'll be sharing with you a series of videos with my top tips on how to best use Trello...

210 views 7 13
Read article

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you