bluzky
I have just released a small library that help to build query from a map with structure similar to Mongo DB filter like this:
Filtery.apply(Post, %{name: {:like, "elixir"}, is_draft: false, tags: {:has, "ecto"} })
Here is the repo:
https://github.com/bluzky/filtery
It’s quite simple and supports filtering on a single table only.
It supports basic operators eq, :gt, :gte, :in, :lt, :lte, :ne, :nin, :and, :or and some other helpful operators. And you can define your own operators too.
Please try and leave your feedback. Thank you.
Update v0.2.0
I have added a special operator ref to join multiple table
query = Filtery.apply(Post, %{comments: {:ref, %{
approved: true,
content: {:like, "filtery"}
}}})
comments field must be the association name in your Post schema
Where Next?
Trending in Announcing
Other Trending Topics
Latest on Elixir Forum
Sponsor Spotlight
Catch errors, track performance, monitor hosts and more.
Categories:
Sub Categories:
Forums
Popular Tags
- #ecto
- #liveview
- #troubleshooting
- #learning-elixir
- #deployment
- #library
- #erlang
- #testing
- #genserver
- #mix
- #absinthe
- #remote-other
- #otp
- #plug
- #how-to-question
- #macros
- #postgres
- #elixirconf
- #channels
- #exunit
- #discussion
- #code-sync
- #podcasts
- #javascript
- #onsite
- #dialyzer
- #docker
- #authentication
- #umbrella
- #full-time-contract
- #podcasts-by-brainlid
- #ecto-query
- #blog-post
- #elixirconf-us
- #elixir-ls
- #ai
- #phoenix_html
- #iex
- #graphql
- #genstage
- #websockets
- #supervisor
- #advent-of-code
- #distillery
- #processes
- #api
- #forms
- #hex
- #security
- #metaprogramming
Our Sponsors
Build Elixir applications with speed and confidence.
We build reliable cloud platforms for business-critical systems.
Catch errors, track performance, monitor hosts and more.
Error tracking, logs, uptime, and Just Enough APM. Built for developers.
Elixir, Erlang & BEAM conferences from Code Sync - join us in 2026!
Master modern tools, write cleaner code, and tackle real-world challenges.
**Building the future of software with AI, trust, and human connection.**
The deployment platform built for Elixir: PaaS ease, VPS control.
The team behind Membrane, Popcorn, LiveDebugger. Available for hire.
Courses that'll move you from confusion to "Aha, now I get it!"
Showing Posts 1 to 7- Show Best Posts
- Show All (oldest first)
- Show All (newest first)
subbu
This is neat. It will work well for simple use cases. Its also good in way that you can build filters progressively as its a map. But its use will be limited as most production use-cases will involve multi-table filtering.
bluzky
Filtery.applyreturn a query so you can chain as many time as you want like thisI have been thinking of a simple specification to define a join filter but there is not good enough solution.
Do you have any suggestion?
bluzky
I have added new operator for querying join table. Please check update above.
subbu
That’s very nice!
mathieuprog
This looks similar to my library QueryBuilder
It’s possible to have joins.
Possible to make a query out of a keyword list with
QueryBuilder.from_list/2.bluzky
Thanks for your library, I didn’t know it before. It has lots of cool features.
This module is actually a part of my projects. I have to write lots of code to build query from request parameter so its goal is to help building query conditions. And I want to keep it simple so my colleges can learn to use it quickly.
marciol
It’s really nice to have ways of building queries using a more data-driven approach. It’s really awesome