devmarco
How to hide results when the child is null in a Graphql Query
Let’s suppose that I have
{
users {
...
review {
...
}
}
}
Users might have or not a Review, Is there a way to hide a user in the results that does not have a review? I’m fetching the review using Dataloader. I don’t want a return like
{
users: [
{..., review: {...}},
{..., review: {...}},
{..., review: null},
{..., review: null}
...
]
}
Marked As Solved
benwilson512
You need to left_join when with_review is false. In the :with_review, true clause you don’t need the here, a regular inner join will only include rows where the review is there anyway.
Also Liked
benwilson512
Hey @devmarco it sounds like you want to filter users by whether they have a review . If so, you should look at introducing an argument to the reviews field:
{
users(withReviews: true) {
...
}
}
If you never want to return users without reviews, then update your users resolver to always do the requisite join to filter out users without reviews.
Popular in Questions
Other popular topics
Latest on Elixir Forum
Sponsor Spotlight
Producing high quality Elixir screencasts since 2017.
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.
Error tracking for Elixir devs who love to ship. Start your free account.
Practical resources that improve the lives of professional developers.
Producing high quality Elixir screencasts since 2017.
Enabling companies to succeed by building software people love.
The team behind Membrane, Popcorn, LiveDebugger. Available for hire.
Courses that'll move you from confusion to "Aha, now I get it!"