shahryarjb
How to convert String.split to fragment in ecto
hello, I want to create the code like this:
query = from u in BlogSchema,
where: String.split(u.tags, ", ") in ^tag_name,
but it doesn’t work and I know we can’t use elixir macro between ecto query, I saw the fragment doc but couldn’t use it , I think it needs psql Knowledge that I don’t have it
how can I fix it?
Thanks
Most Liked
kip
I think this should do it, assuming you are using Postgres:
from u in BlogSchema,
where: fragment("? = any(string_to_array(tags, ','))", ^tag_name)
Note that in practical terms, it would be better to store the tags already split and either save them as an array in Postgres or use a join table.
Popular in Questions
Other popular topics
Latest on Elixir Forum
Sponsor Spotlight
Practical resources that improve the lives of professional developers.
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
- #channels
- #elixirconf
- #exunit
- #discussion
- #code-sync
- #javascript
- #podcasts
- #onsite
- #dialyzer
- #docker
- #authentication
- #umbrella
- #full-time-contract
- #podcasts-by-brainlid
- #ecto-query
- #elixir-ls
- #phoenix_html
- #iex
- #blog-post
- #graphql
- #genstage
- #ai
- #websockets
- #supervisor
- #advent-of-code
- #elixirconf-us
- #distillery
- #processes
- #forms
- #api
- #metaprogramming
- #security
- #performance
Our Sponsors
Build Elixir applications with speed and confidence.
Supporting innovation across the BEAM ecosystem.
We build reliable cloud platforms for business-critical systems.
Catch errors, track performance, monitor hosts and more.
Real-time error tracking, performance insights, and observability for devs.
Practical resources that improve the lives of professional developers.
Develop your skills with books, videos, and courses.
Producing high quality Elixir screencasts since 2017.
Courses that'll move you from confusion to "Aha, now I get it!"