How to execute a conjunction of OR and AND in AEM GraphQL?

Question

I want to have a filter like this:
const value = 
{
	AND: [
		{
			OR: [
				{ productVisibility_contains_none: ['authenticated', 'eap'] },
				{
					AND: [
						{ productVisibility_contains_all: ['authenticated'] },
						{ productVisibility_contains_none: ['eap'] },
					],
				},
			],
		},
		{ title_exists: true },
		{
			OR: [
				{ title_contains: $arg1 },
				{ author_contains: $arg1 },
				{ articleSource_contains: $arg1 },
				{ articleByline_contains: $arg1 },
				{ articleSubtitle_contains: $arg1 },
				{ primaryCategoryTag_contains_some: [$arg1, $arg1_cap, $arg1_low] },
				{ categoryTags_contains_some: [$arg1, $arg1_cap, $arg1_low] },
			],
		},
		{ primaryCategoryTag_contains: $categoryTitles },
	],
};

as you can see there's conjunction of OR and AND operations, however in AEM GQL you only get either OR or AND for all the high level filters. I wanted to know if it would be possible to perform the above in AEM or not?

aanchal-sikka · Accepted Answer

You would need to restructure your query. The samples for OR and And are as follows:

For an OR condition refer to: https://experienceleague.adobe.com/docs/experience-manager-cloud-service/content/headless/graphql-api/sample-queries.html?lang=en#sample-all-cities-d-ch-population

    country: {
      _logOp: OR
      _expressions: [
        {
          value: "Germany"
        }, {
          value: "Switzerland"
        }
      ]
    }

For and condition omit the "_logOp". Two adjacent conditions are tried via AND.

Example:
Multiple values in population is AND. And So is 'population' + 'country'

query {
  cityList(filter: {
    population: {
      _expressions: [
        {
          value: 400000
          _operator: GREATER_EQUAL
        }, {
          value: 1000000
          _operator: LOWER
        }
      ]
    },
    country: {
      _logOp: OR
      _expressions: [
        {
          value: "Germany"
        }, {
          value: "Switzerland"
        }
      ]
    }
  }) {
    items {
      name
      population
      country
    }
  }
}

krati_garg · Answer

@spidey1405

Please see the link below, the highlighted line says, that in AEM, for a GQL filter AND is implicit while OR needs to be mentioned explicitly. Can you try your query with this format:
https://experienceleague.adobe.com/docs/experience-manager-cloud-service/content/headless/graphql-api/sample-queries.html?lang=en#:~:text=Here%20a%20combination%20of%20fields%20are%20filtered%20on.%20An%20AND%20(implicit)%20is%20used%20to%20select%20the%20populationrange%2C%20while%20an%20OR%20(explicit)%20is%20used%20to%20select%20the%20required%20cities

Sign up

Login with SSO

Login to the community

Login with SSO