freewebwithme
Hi!
I have a Category and Product relation.
Category has_many Products,
Products belongs_to Category.
I want to get all category and get 10 items for each category for my home screen.
in schema.ex
@desc "Get all categories"
field :categories, list_of(:category) do
resolve(&Resolvers.Category.get_categories/3)
end
object :category do
field :name, non_null(:string)
field :products, list_of(:product) do
arg :limit, type: :integer, default_value: 20
resolve dataloader(Products, :products, arg: %{scope: :category})
end
in products.ex
def datasource() do
Dataloader.Ecto.new(MyApp.Repo, query: &query/2)
end
def query(Product, %{scope: :category, limit: limit}) do
Product
|> where(active: true)
|> limit(^limit)
end
def query(queryable, _) do
queryable
end
in resolvers.category.ex
def get_categories(_, _, _) do
{:ok, Category.get_categories()}
end
in category.ex
def get_categories() do
Repo.all from c in Category
end
in graphiql query I tried
{
categories {
name
products(limit: 10) {
name
}
}
}
But it seems not working correctly.
it returns all categories but empty product and only one category returns 10 products
what am I doing wrong?
Trending in Questions
I’m working on a project that simulates the bumbl example in the programming phoenix book. It acts almost like an email client. We have a...
New
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
Documentation
While reading the Scoped Routes section, I noticed that the documentation currently refers to a problem without explainin...
New
I’m seeing that a list inside a Kino.DataTable will be interpreted as a charlist, even if the Kino.configure() is set to charlists: :as_l...
New
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
Hi, I’ve just set up an application with ash_authentication. There is only magic link strategy for now, so there is no confirmation add o...
New
If a change or preparation module uses Ash.Changeset.get_argument/2 or Ash.Query.get_argument/2 (or any of the other get_argument functio...
New
Other Trending Topics
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
I am happy to introduce the very α version of the new programming language compiled to BEAM.
Welcome Cure.
It has literally three kille...
New
Hi there! We created Gust: A task orchestrator inspired by Airflow.
For those who have never heard about Aiflow, it’s a Python-based wor...
New
Hi everyone!
The first release candidate for the Expert language server project is now available!
We’ve published a press release detai...
New
Beam Bots (or just BB for short) is a framework for building fault-tolerant robotics applications in Elixir using familiar OTP patterns. ...
New
Xamal is a deployment tool for Elixir apps that deploys native releases to bare metal servers over SSH. It’s a port of GitHub - basecamp/...
New
Categories:
Sub Categories:
Forums
Popular Tags
- #ecto
- #liveview
- #troubleshooting
- #learning-elixir
- #library
- #deployment
- #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
- #elixirconf-us
- #ai
- #blog-post
- #elixir-ls
- #phoenix_html
- #iex
- #graphql
- #genstage
- #websockets
- #supervisor
- #advent-of-code
- #distillery
- #processes
- #api
- #forms
- #metaprogramming
- #hex
- #security











Showing Posts 1 to 3- Show Best Posts
- Show All (oldest first)
- Show All (newest first)
joehua87
Maybe related to How to batch load with Absinthe Relay while supporting first: x and after_cursor? - #2 by benwilson512
freewebwithme
Yes I found this happens to me also
I am still looking for a solution, Do I have to raw query maybe?
joehua87
I don’t know,
But I think raw query is more effective & easier to maintain,
I’ve faced issue similar to you, my solution use use group by & json_aggr, like below.
The performance is very good for me (74 ms), YMMV
The other good news that you can easily write this query in Ecto with the little help of
fragment, so you can easily control the sort by, limit, selection fields of the subqueryTo make it works with absinthe, you should simply call this query when resolving the list of your categories
The query in text