List based filtering

[ascii1010]

Hi,
is list based filtering supported in DAB?

e.g. filter: { id:{ in:[1,2,3,4] }} or filter: { id:{ nin:[1,2,3,4] }}

If not, is there an alternative approach that generates the same outcome?

[severussundar]

Hi @ascii1010, this can be achieved using the or operator.

For example: Let's say you have an entity titled book and items with ids :1, 2 and 3 needs to be selected.

Using the following filter clause will select only the items with ids equal to 1,2 or 3.

{
  books(filter: { or: [{ id: { eq: 1 } }, { id: { eq: 2 } }, { id: { eq: 3 } }] }) {
    items {
      id
      ...
    }
  }
}

For reference, here is the list of operators that are supported along with filter

[ascii1010]

@severussundar, thanks for your suggestion, it worked.

[alawal98]

Hi severussundar, is this currently possible for multiple fields? e.g. I want to get all the books that have ID 1-3 but I also want these books to be in the "Horror" or "Thriller" Genre.

Thanks.

[severussundar]

Hey @alawal98, yes, it is possible to filter based on multiple fields.

For the example, you have mentioned, you could do something like this.

{
  books(
    filter: {
      and: [
        { or: [{ id: { eq: 1 } }, { id: { eq: 2 } }, { id: { eq: 3 } }] }
        {
          or: [{ genre: { eq: "Horror" } }, { genre: { eq: "Thriller" } }]
        }
      ]
    }
  ) {
    items {
      ...
    }
  }
}

For reference, here is the link to the filter operator in DAB docs: GraphQL Filter operation docs

[jaykar2020]

Hi @severussundar, how does one filter on nested objects that contain string arrays? Below does not return any data (doesn't error either).

and: [
{ locale: { eq: "en" } }
{ contentMetadata: { values: { contains: "foo" } } }
]

[severussundar]

Hey @jaykar2020 , the syntax you have mentioned in the comment is correct.

Only those contents (assuming contents as the top level entity here) items
a) Having locale as en and
b) values (field of the contentMetadata entity) containing foo in them. Here, my understanding, is that contentMetadata is of array type (essentially, a list of contentMetadata items can be associated with a single content item). For a given content item, if none of the none of the associated contentMetadata items have values items with foo in them, then, that particular content item will not come up in the response.

It might be the case that none of the rows present in the table satisfy the conditions.

[jaykar2020]

@severussundar, thanks for the response. I've verified data is accurate. ContentMetadata is a nested object [array in the root object] and includes a string array, values. I've added the schema and sample data. The sample document should be returned as response but does not. Any idea why?

Schema

type ContentEntity @model{
locale: String
contentMetadata: [ContentMetadata]
}

type ContentMetadata {
values: [String]
...removed for brevity
}

Data in Azure Cosmos DB

{
    "locale": "en",
    "contentMetadata": [
        {
            "values": [ "foo" ]
        }
    ]
}

Edited to add: replacing string array with an array of another object (see updated schema below), works. Would really like to see the string array work though...

type ContentMetadata {
someObject: [SomeObject]
}

type SomeObject {
val: String
}

query

and: [
        { locale: { eq: "en" } }
        {
          contentMetadata: {
            someObject: { val: { eq: "foo" } }
          }
        }
      ]

Data in Azure Cosmos DB

{
    "locale": "en",
    "contentMetadata": [
        {
            "someObject": [ { "val": "foo" } ]
        }
    ]
}

[severussundar]

Hey @jaykar2020,

For Cosmos DB database type, the support for filtering on nested objects is introduced in the recent 0.11.* version.
0.11.12-rc is the latest rc version in which this feature should be available. Please give it a try with this version if you were previously trying with an older version of DAB.

[jaykar2020]

@severussundar, updated to 0.11.12-rc but still see the same issue. If this case works for you, do you mind sharing the Cosmos DB document, query, and response? I'd like to compare with mine to see if it's user error.

And the data is accurate

Thanks for looking into this! It's much appreciated!

[jaykar2020]

@severussundar, any update on this? Can you confirm it's fixed in 0.11.12-rc? Thanks!