Azure / data-api-builder

Data API builder provides modern REST and GraphQL endpoints to your Azure Databases and on-prem stores.
https://aka.ms/dab/docs
MIT License
787 stars 142 forks source link

[Bug]: caseInsensitive not working on GraphQL query #2280

Open tim-tmp opened 4 days ago

tim-tmp commented 4 days ago

What happened?

We are developing an Azure Static Web App with a CosmosDB accessed via GraphQL queries using the feature outlined here: https://learn.microsoft.com/en-us/azure/static-web-apps/database-overview

When including caseInsensitive on a GraphQL query we get the following error:

"Operation caseInsensitive on int type not supported."

The caseInsensitive input field exists in the schema which Postman validates also.

` StringFilterInput

      {
        "name": "caseInsensitive",
        "description": "Case Insensitive",
        "type": {
          "kind": "SCALAR",
          "name": "Boolean",
          "ofType": null
        },
        "defaultValue": "false"
      },

`

The query we are using is: { records: assets( filter: { Title: { contains: "hello world", caseInsensitive: true } }, first: 10 ) { items { id, Title } endCursor hasNextPage __typename } }

Version

0.10

What database are you using?

CosmosDB NoSQL

What hosting model are you using?

Static Web Apps (SWA)

Which API approach are you accessing DAB through?

GraphQL

Relevant log output

Operation caseInsensitive on int type not supported.

Code of Conduct