Query with where statement

[AndyCa]

Hi all,

Forgive me for the simple question as its my first time using this graphql client for my quarkus app. How do I write a dynamic where statement on my query to filter results?

I can write a query simply as such after injecting the DynamicGraphQLClient:

                operation(
                        field("scan_instance",
                                field("scan_instance_id"),
                                field("name"),
                                field("scan_type_id")
                        )
                )
        );

However, I've searched your source code for where and _eq and they don't seem to exist. Is this feature available?

Thanks.
Andy

[phillip-kruger]

Does your server api allow that ?

[jmartisk]

Right this is something that needs to be supported by the server side, this is not SQL or MongoDB where you would find where and similar keywords built in out of the box.

For example, if your server side supported something like this

query {
  scan_instance(where:{name:"name2"}) {
    scan_instance_id 
    name 
    scan_type_id
  }
}

then you would write

operation(
  field("scan_instance", 
    args(arg("where", inputObject(prop("name", "name2")))),
    field("scan_instance_id"),
    field("name"),
    field("scan_type_id")
));

[AndyCa]

Thank you for your responses. I am using hasura as my graphql engine so where is supported. I've progressed with the following:

        Document query = document(
                operation(
                        field("scan_instance(where: {scan_type_id: {_eq: $x}})";,
                                field("name"),
                                field("scan_instance_id")
                        )
                )
        );

I'll give @jmartisk answer a go too - however it does not include the equality operation (_eq etc..)

[jmartisk]

Try something like this

Document d = document(
            operation(
                field("scan_instance",
                    args(arg("where",
                        inputObject(
                            prop("scan_type_id",
                                inputObject(prop("_eq",
                                    var("x", ScalarType.GQL_ID)))))
                        )),
                    field("name"),
                    field("scan_instance_id"),
                    field("scan_type_id")
                )
            )
        );
        Request request = new RequestImpl(d.build()).setVariable("x", "123456"); // include your desired value here
        client.executeSync(request);

[AndyCa]

Done:

        Document document = document(
                operation(
                    List.of(var(SCAN_TYPE_ID_VAR, ScalarType.GQL_INT)),
                    field("scan_instance",
                        args(arg("where",
                                inputObject(
                                        prop("scan_type_id",
                                                inputObject(prop("_eq",
                                                        var(SCAN_TYPE_ID_VAR, ScalarType.GQL_ID)))))
                        )),
                        field("name"),
                        field("scan_instance_id")
                    )
                )
        );

👍