Using "capitalize" filter in Function stack

Gavril Loghin

Sorry in advance if this question is a bit redundant. I try to build a search bar and in my endpoint, I have created a condition WHERE input: text "search" = db "projects.item" and so far so good - the results are returned if I type the exact wording, but I would like to let my end-users to search no matter if they type lowercase or uppercase.

How or what is the best practice for adding the capitalize filter in my function stack? 

Thanks a lot.

Michael Udinski

Use the LIKE operator instead of = for more flexible search

Sean Montgomery

The includes operator is even easier. It always does a case insensitive partial match search.