Community Advisor

AEM GraphQL nested AND and OR expression

Forum|Forum|2 years ago
May 8, 2023
2 replies
1835 views

Hello People,

Is there a way to apply two _logOp in single GraphQL query?

we have a query, where we want to filter result in a folder AND it should match the variable value between two CF model fields, so It should be OR operation.

Is there a way, we can do it in AEM GraphQL syntax?

Thanks.

@arunpatidar

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

krati_garg

Adobe Employee

@iamnjain I believe CF Model fields and Folder structure would really help in constructing the query. Also, please share any sample query that you must have tried

iamnjain

Author

Community Advisor

Sure @krati_garg

Here is sample query

query SearchInFolder ($searchString:String!) {
questionandanswerList(filter:{
_path:{
_expressions: [
{
value:"/content/dam/testproject/contentfragments/qanda"
_operator:STARTS_WITH
}
]
}
_logOp: AND
question:{
_expressions: [
{
value: $search
_operator: CONTAINS
_ignoreCase: true
}
]
}
answer:{
_expressions: [
{
value: $search
_operator: CONTAINS
_ignoreCase: true
}
]
}
}
)
{
items {
question
answer
}
}
}

Here, the requirement is, It should search inside that folder AND should match the keyword either with question OR answer field. So It's an OR operation.

How to nest AND and OR operator in one single query?