How to create a filter by status using GraphQL

Legacy Knowledge Base

Published Jun. 30, 2025

How to create a filter by status using GraphQL

Written By

María Picado

Legacy Article

You are viewing an article from our legacy "FastTrack" publication program, made available for informational purposes. Articles in this program were published without a requirement for independent editing or verification and are provided"as is" without guarantee.

Before using any information from this article, independently verify its suitability for your situation and project.

Issue

If you need to filter by status and execute this query:

query{
   c {
      countrieses (filter:"status eq pending"){
         items {
            status
            id
            selected
         }
      }
   }
}

You'll get this error:

{
  "errors": [
    {
      "message": "Exception while fetching data (/c/countrieses) : A property used in the filter criteria is not supported: status eq pending",
      "locations": [],
      "extensions": {
        "exception": {
          "errno": 500
        },
        "code": "Internal Server Error",
        "classification": "DataFetchingException"
      }
    }
  ],
  "data": {
    "c": {
      "countrieses": null
    }
  }
}

Environment

Liferay 7.4, 2023.Q3

Resolution

The status field is set as a collection and is managed as integer.
You need to pass a lambda expression:

(status/any(x:(x eq [statusValue])))

The following query is an example for filtering by pending status

query{
   c {
      countrieses (filter:"(status/any(x:(x eq 1)))"){
         items {
            status
            id
            selected
         }
      }
   }
}