Hello, I’m trying to dynamically pass a schema name into a function for use in a query. Can’t quite figure out in which format to pass in the schema name. Pseudo code (not working): def test(schema_name) do Test.Repo.all(from a in schema_name, where: a.name == "ACME") end Have tried various wa…

What’s the error? Works for me, but used like you did gives you a error that says “queries that do not have a schema need to explicitly pass a :select clause in query”. Also you might need the ^ operator in front of that constant "ACME" string. Try this: schema_name = "some_table" Test.Repo.all(f…

Yes, setting the variable inside the function works (for table names as well as for schema names). It’s also no problem to pass in a table name via the function head parameters. My problem is passing in an Ecto schema name (not a table name) via the function head. This works (inside the function): …

Btw, this is the error I get, when trying to pass the schema name in via function head parameter. My schema is called Account: ** (Protocol.UndefinedError) protocol Ecto.Queryable not implemented for Account of type Atom, the given module does not exist. This protocol is implemented for the followi…

Ah, gotcha. The use Ecto.Schema macro creates a __schema__ function that exposes some introspection details about your schema, and you can use that to find the actual table name as string ( Ecto.Schema — Ecto v3.14.0 ) def test(schema_name) when is_atom(schema_name) do # Get the table name as stri…

Sorry for the double post, but using the schema module actually works! Your problem is using the Account atom, which isn’t probably aliased to its fully qualified name. You’ll see that if you alias it, or use the fully qualified module name, such as YourApp.Data.Account, it will work. alias YourA…