Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
4,297,312
Community Members
 
Community Events
165
Community Groups

Trello Custom Fields Search

Hi There,

 

I have just added in the Custom Fields power-up for Trello and I need a way of searching by these custom fields. Is there a way of doing this?

8 answers

I agree, searching and/or filtering by custom fields is an absolute necessity. I am using custom fields for item priority and project associations, and because of the number of items I need to use I am unable to use labels for them. This power-up is almost useless without any search or filter capabilities.

you can search by custom field content...just use {{%fieldname}}=searchtext

Like # people like this

would be nice if that were documented somewhere. preferably on the details for the powerup

Like # people like this

Note that this only works in search cards. It doesn't work in the Go to search field where a lot of tagged searches can be done. I don't see a way to save this search either. 
This split search/filter functionality is kinda odd.

Like # people like this

Another thing to observe is that if the values in the custom fields are unique (doesn't show up anywhere else) then you can just use one of those values in Search Cards. If the values aren't unique @Lewis Melville's suggestion is very useful. 

The whole magic of the "Jump to" search for a user like myself who has 30 lists per board each with anywhere from 10-20 cards on a monthly basis, was the ability to jump right to the desired card. Filter/Search while useful, means lots of tedious horizontal scrolling which slaughters productivity...and I am guessing this doesn't search across multiple boards?  

So close but not quite. 

Like # people like this

Unfortunately, @Lewis Melville's {{%fieldname}}=searchtext seems not to limit search exclusively to the named field.

I have a custom field called CCI and, for example, {{%CCI}}=229 returns all the expected Cards plus spurious Cards that have 229 in their URLs.

Something like this, where the number is a Trello ID:

https://trello.com/c/bh6rF8O2/229-investigate-upgrade

Similarly, any card with the searchtext in its Title is also returned:

https://trello.com/c/OW6NTg9t/451-229-test

Anybody have any thoughts about how to exclude these?

Like Lee-on Pedahzur likes this

Custom Fields has been included in the Trello APi recently. Is there a plan to make them searchable now? It would be very great!

Use Filters instead of search 

Deleted user Jul 11, 2018

@Matthew N How do you filter by custom fields? Looks like you can only filter by "term or search for labels, members, or due times."

How can I do searches or filter cards for a custom field?

I vote for the feature of advanced search/filter functionality that allows addressing specific custom fields according to their types (number, date, dropbox, multi-value list, etc.) and attachment (file types, size, etc.).

Also, it would be great to use some search language that includes AND, OR, BETWEEN, <, <=, >, >=, ==, !=, ! (not) operators.

As Matthew N hinted, the Filter search will search custom fields. Show Menu > Filter Cards, then type the custom field value you want to search for. For example, a custom field called "Frobnosticator" that populates from a list. Typing the selected value ("Bob") from the list in the Filter search will filter the cards to show the ones where Frobnosticator is Bob. It will probably also match card names containing "Bob" .. so it would be nicer if the filter would let you do Frobnosticator: Bob ... but, it doesn't (I tried it and got the same results as just filtering on Bob).

Or, just take it from Trello:

  • Filtering: Board filtering now supports text, drop down list, and checkbox fields, and will surface cards that have fields that match filtered terms.

Seems to have disappeared. 

Like Lee-on Pedahzur likes this

They changed the name, now it's Show Menu > Search Cards

It doesn't seem the card search can properly find values with spaces in them. If the value is absent, like for instance there is no "Factor 9" in a board, but there is a "Factor 10", then a search for the former will display cards with the latter. 

If both values are present, both will display, no matter if you use quotes or not.

I'd say this is a broken search, albeit not unique to Custom fields.

Trello doesn't seem interested in advancing search. I might abandon it for it. On the other hand you can't export data in any fully usable way (missing data as far as I can see), so they got me trapped.

in 2021 there is no longer Show Menu > Search Cards. It's now called Filter: https://help.trello.com/article/972-filtering-vs-searching

Hey Alex

Currently, Custom Fields are not searchable.  They will, however, be included in export reports of the board.

You can let the team know of your interest in searching custom fields by sending a feature request to feature-ideas@trello.com

Appears that Trello Development Roadmap doesn't go beyond December '17. Is there a new development roadmap for Trello available somewhere in the Atlassian universe?

1 vote

How can this not have been fixed yet?

Create an Advanced search where you easily can search on custom fields (without having to write "{{%fieldname}}=searchtext").
It should be possible to add "AND and OR".
It must be possible to save your search.

It seems this still hasn't been fixed?

I was just getting excited about the possibilities of custom fields + butler reports solving some needs for us, and discovered the custom fields aren't searchable.  Seeing that this thread is over three years old, I'm assuming no one cares?

I just tested it with a custom field set to number. It is searchable if you use the search cards command in the menu. 

I think it still just searches for the value though eg search for any card that has the number 4 anywhere in the card, rather than a value specific to the field eg search for cards where value in {fieldname} = 4

After further testing, in fact you can search by custom field content...just use {{%fieldname}}=searchtext

Like # people like this

Thanks @Lewis Melville

I tried some variations of this and they also seem to be working:

  • {{%fieldname}}searchtext
  • %fieldname:searchtext

I guess the "%fieldname" part is the key. Without the "=" in the URL you can paste a link somewhere or save a bookmark and it will still work.

This works for searching, but it would be nice to be able to filter by two custom fields. If you put two in the box, you get every card containing either instead of only the cards containing both.

@Jennifer, a simple | means OR: 

%fieldname:searchtext | %fieldname:searchtext2

Like Jennifer likes this

I may be misunderstanding, but that’s producing the same results as just searching for both fields. What I want is something that only shows cards with both of the fields. 

@Jennifer. Yes, it looks like the "|" actually isn't operative and can be left out. So there's no "and" that would work in this case. Trello support next then. 

I'm sorry @Lewis Melville, but it seems your first insight "I think it still just searches for the value though eg search for any card that has the number 4 anywhere in the card, rather than a value specific to the field eg search for cards where value in {fieldname} = 4" would seem to be correct.

For example if I search for a value in a field which doesn't have this value, as it belongs to another, the same search results show up.

How can we save one of these searches?

Like Ungapped Support likes this
0 votes

The Screenful Power-Up allows grouping and filtering based on custom fields. You can learn more at https://screenful.com/trello/custom-fields/

Yeah great, however, I'm not going to pay $468 per year just to able to search on custom fields. I would if I needed his for a multi-million dollar operation. 

Suggest an answer

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

Taco Tuesday: New years' resolutions with Trello

Congratulations to @Laura Holton , our latest winner of Taco Tuesday! And thanks to @Kristján Geir Mathiesen for sharing the picture of Taco having fun with his new friend  B...

2,343 views 28 40
Join discussion

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