graphql-platform icon indicating copy to clipboard operation
graphql-platform copied to clipboard

Get all where sub-item is null

Open sturlath opened this issue 3 years ago • 2 comments

Is your feature request related to a problem?

Sorry if this is basic! But I just can´t filter/select by null values. I have looked everywhere. I have tried all kinds of syntax without any luck. I gave this here a go https://chillicream.com/docs/hotchocolate/fetching-data/filtering.

So here I´m getting everything, and you see a Site == null. I would like to get all where Site == null

image

The solution you'd like

But I would like something like this this

{
devices(where: { site: { any: false} }) {
    nodes{
        id
        machineCode
        site {
                id
                customer {
                    id
                }
                address {
                    city
                }
            }
        hardwareInformation {
            systemVendor
        }
    }
}

Is this possible to day?

Product

Hot Chocolate

sturlath avatar May 26 '22 10:05 sturlath

So I´m guessing this isn´t possible at the moment, right?

sturlath avatar Jun 08 '22 15:06 sturlath

Checking for null would run into #5316

hdkesting avatar Apr 09 '24 15:04 hdkesting