New Participant

AEM CLoud GraphQL Filter using string array

Forum|Forum|1 year ago
February 18, 2025
4 replies
1816 views

Hi Team,

Could you please help me on GraphQL persistent queries.

The use case is I want to pass some group names in query paramaters and I want to filter the CF's matching with any group name.

I am using query like this

query ($userGroups: [String]!) {
  sNewFragmentList(filter: {
    deliveryGroup: {
      _expressions: [
        {
          values: $userGroups
          _operator: CONTAINS
        }
      ]
    }
  }) {
    items {
      _path
      title
      description
      deliveryGroup 
    }
  }
}

And I am passing parameters as

{
  "userGroups": "group1,group2,group3"
}

This query is not working at all, could anyone pls help me to check every group from the parameters list and filter only those fragments.

Thanks.

P

punithshetty123

New Participant

Did you finally figure out filtering string array

S

SDusaneAuthor

New Participant

No all the solutions given above didn't work for string array so I read all the data from graphQL and filter the results on frontend.

Uppari_Ramesh

New Participant

Hi @sdusane , could you please try below filter? Ensure you have name as VALUE instead of VALUEs

filter: {deliveryGroup: {_expressions: [{value: $userGroups, _operator: CONTAINS}]}}

Thanks,

Ramesh.

AmitVishwakarma

New Participant

Hi @sdusane ,

Change _operator: CONTAINS to _operator: IN for matching arrays.
Query: Checks if any value in the userGroups array matches values in the deliveryGroup array.

query ($userGroups: [String]) {
  sNewFragmentList(
    filter: {
      deliveryGroup: {
        _logOp: OR,
        _expressions: [{
          values: $userGroups,
          _operator: IN
        }]
      }
    }
  ) {
    items {
      title
      description
      deliveryGroup
    }
  }
}

{
  "userGroups": ["group1", "group2"]
}

S

SDusaneAuthor

New Participant

Thanks @amitvishwakarma

I could see this error

IN is not the value we can use.

Thanks.

kautuk_sahni

Employee

@sdusane Did you find the suggestions helpful? Please let us know if you need more information. If a response worked, kindly mark it as correct for posterity; alternatively, if you found a solution yourself, we’d appreciate it if you could share it with the community. Thank you!

Kautuk Sahni

PRATHYUSHA_VP

New Participant

Hi @sdusane

Firstly, the type of param you're trying to filter should be of type string array [String]. Refer to example like below :

If it's not string array parameter, try something like below :

You can update, operator parameter (_operator) as per your requirement

Here's the similar example in experience league docs --

https://experienceleague.adobe.com/en/docs/experience-manager-cloud-service/content/headless/graphql-api/sample-queries#sample-all-persons-jobs-smith

Hope this helps

Thanks

S

SDusaneAuthor

New Participant

Hi @prathyusha_vp

Thanks for the help!

I am trying below query

query ($userGroups: [String]) {
  sNewFragmentList(
    filter: {
      deliveryGroup: {
        _logOp: OR,
        _expressions: [{
          values: $userGroups,
          _operator: CONTAINS
        }]
      }
    }
  ) {
    items {
      title
      description
      deliveryGroup
    }
  }
}

With the query parameter

{
  "userGroups": ["group1","group2"]
}

It is still not working. If I give only 1 parameter the query is working but not with array values.

Can you pls suggest me some fix.

Thanks.

PRATHYUSHA_VP

New Participant

@sdusane

Can you send the type of parameter for deliveryGroup in CF field ?

Thanks

Sign up

Login with SSO

Login to the community

Login with SSO

Scanning file for viruses.

This file cannot be downloaded