How to use content picker field in where or order of GraphQL

[happygb21]

example：
{
case(where:{blogPost:{contentItemId:""}}){
displayText
}
}

[chinasqzl]

I don't know if that's what you want.

https://orchardcore.readthedocs.io/en/dev/OrchardCore/OrchardCore.Apis.GraphQL.Abstractions/#querying-related-content-items

{
person {
name
favoriteMovies {
contentItems {
... on Movie {
name
releaseYear
}
}
}
}
}

[happygb21]

@chinasqzl Thank you, but what I want is to include content picker field in Graphql's query condition and query it, which bothers me a lot.

[zl2fxy]

Field filtering does not seem to be supported，I am not found anything about field filtering at the graphql module.
if you find it,please tell me,thanks

[sebastienros]

It could be a separate query that targets the index that this field is generating. But I don't think we have that already.

Another option is to expose a custom SQL query in graphql, which is already support AFAIK.

[zl2fxy]

It could be a separate query that targets the index that this field is generating. But I don't think we have that already.

Another option is to expose a custom SQL query in graphql, which is already support AFAIK.

OK，I think it's good，i in the process of finding the achieving graphql query filter about the field，
can you give me a simple example？thanks！

[happygb21]

@sebastienros thanks~!