HotChocolate GraphQL query for objects with null child object

Question

Is there a way I can query for all objects where a child object is null?

I am trying to do something like this:

{
GetAllAccounts (  where: { accountManager: { eq: null} })  {
    accountManagerFid,
      accountManager {
        userLastName 
      }
  }
}

That doesn't work because accountManager is an object with it's own filter so it's expecting me to filter on some field on the accountManager object once I open that nested curly bracket after "accountManager:".

I am looking for the right way to query for "All Accounts where accountManager child object does not exist at all"

I never found what I thought was the perfect solution, but I posted a work-around below. — DotNetAndAngular Developer
– DotNetAndAngular Developer, Commented May 27, 2022 at 20:28

DotNetAndAngular Developer · Accepted Answer · 2022-05-27 20:26:27Z

1

I never found the perfect solution, but here are the notes I took that describe a work-around I used:

So far this is the closest I have figured out (I have to look at the foreign key and not for the child object itself):

{
GetAllAccounts(  where: {  accountManagerFid: {eq: null} }) {
    accountManagerFid,
      accountManager {
        userLastName 
      }
  }
}

answered May 27, 2022 at 20:26

DotNetAndAngular Developer

861 silver badge5 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

HotChocolate GraphQL query for objects with null child object

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related