How do I filter for entries who's field abc is an empty string?

Discord Q&A strapi-questions
1

Not inquiring about null rather empty string.

This topic has been created from a Discord post (1260264206779813949) to give it more visibility.
It will be on Read-Only mode here.
Join the conversation on Discord

2

Hello Aron :wave:

While Strapi provides several built-in filters, there isn’t a default filter specifically for empty strings :confused:

3

Is there a work around other then the untenable solution of retrieving all entries and filtering on the client side? Does Strapi intend to develop this functionality in the near immediate future? It is extremely disappointing that Strapi lacks such essential functionality.

4

Not sure if this is going to be implemented in the near future :thinking:

5

It is just possible to filter entry with empty fields on the API, but not on the UI.

6

I apologize for being unclear, I would like to filter using the API.

7

how do I do so?

8

http://localhost:1337/api/categories?filters[name][$eq]=

// 20240711153136
// http://localhost:1337/api/categories?filters[name][$eq]=

{
  "data": [
    {
      "id": 1,
      "attributes": {
        "name": "",
        "datetime": null,
        "date": null,
        "createdAt": "2024-07-11T11:50:06.109Z",
        "updatedAt": "2024-07-11T11:57:27.635Z",
        "publishedAt": "2024-07-11T11:50:08.700Z",
        "locale": "en"
      }
    }
  ],
  "meta": {
    "pagination": {
      "page": 1,
      "pageSize": 25,
      "pageCount": 1,
      "total": 1
    }
  }
}
9

Thank you!