matt1

matt1

This may be a newbie question, sorry about that, but i can’t figure it out.

Im trying to make a simple thing

import Ecto.Query
...

filter = %{key: "tags", value: "aaa"}
value = filter[:value]
fragment(" '?' =ANY (tags)", value)

But I get every time undefined function fragment/2

I tried importing or using API Builder etc but without result.

Anyone has a full example? (I’m using ":ecto, "3.0.6"

thanks in advance

Showing Posts 1 to 6

jdj_dk

jdj_dk

:wave:

This may be a newbie question, sorry about that, but i can’t figure it out.

No need for apologies. I assume it is because you need to use the fragment inside a Query. Can you show the entire function?

Here is an example

from p in Post,
 where: is_nil(p.published_at) and
        fragment("lower(?)", p.title) == ^title

from Ecto.Query — Ecto v3.14.0

jegaxd26

jegaxd26

You can also use dynamic if you need to use fragment outside Query

matt1

matt1 OP

I use dynamic, but i need a query like

SELECT * from services where 'xxxx' =ANY(tags)

jegaxd26

jegaxd26

If you want to use fragment outside Query you need to wrap it inside dynamic, I don’t see you doing that in your gist. What I mean is something like this dynamic([d], fragment("?=ANY (tags)", d.some_field))

matt1

matt1 OP

perfect! that was the solution! thank you so much!

— All posts loaded —

Where Next? Top

Trending in Questions Top

katta
I having some trouble figuring out if I have set myself too strict of standards for my production server. Currently I can handle 75% of r...
New
nseaSeb
Hello, I know there is an approach for handling lists that allows for optimized traversal, but I can’t recall the specific method (somet...
New
brecabral
Documentation While reading the Scoped Routes section, I noticed that the documentation currently refers to a problem without explainin...
New
kpanic
Hi everyone, I am toying with the idea of building a “match maker” for giving personal help to people that wants to start coding. I sta...
New
velrest
So my question is quite simple and i have found no conclusive answer on forum, google or AI. Should we use :erlang.float for Integer to ...
New
asweet-confluent
I recently noticed that Elixir’s Logger defaults its primary log level to :debug when no :logger, :level application configuration is pre...
New
apz
I’m new to elixir and just tried to install the elixirLS extension for VScode(ium) and it is throwing some errors that I would like help ...
New

Other Trending Topics Top

GenericJam
Edit: 2026 May 15 - This post is archived. Mob is alive!! Main docs: mob v0.7.11 — Documentation A bit of explanation for the slightly c...
New
JesseHerrick
Hey, I’m Jesse and I’m the main contributor behind Dexter, a full-featured, lightning-fast Elixir LSP optimized for large codebases. It s...
New
mudasobwa
I am happy to introduce the very α version of the new programming language compiled to BEAM. Welcome Cure. It has literally three kille...
New
garrison
Hobbes is a low-level distributed database for the Elixir programming language. Hobbes provides a simple, safe, and scalable storage lay...
New
mhanberg
Hi everyone! The first release candidate for the Expert language server project is now available! We’ve published a press release detai...
New
budgie
A little off-topic, but I feel like people here have a good head on their shoulders. I used to be quite good at making software. Was luc...
New

We're in Beta

About us Mission Statement

Options

Thread Display Mode




Thread Preview

Skip Thread Previews