We’ve recently migrated our application from Strapi 4.25.11 to Strapi 5.5, and we’re experiencing an issue where published entries are not visible in our API responses, though they exist in the database.
Details:
Database verification shows we have 256 total entries:
153 published entries (published_at IS NOT NULL)
103 draft entries (published_at IS NULL)
In the API responses, we can only see the draft entries
We’ve verified the data integrity in PostgreSQL directly
The published entries are present in the database with valid published_at timestamps
We’ve tried modifying our controller to explicitly query for published entries using publishedAt: { $notNull: true }
I am experiencing the same issue. This is most likely because your 153 published entries don’t have a draft counterpart. I am not sure how you migrated your data, but I used the import / export method. I’ve created an issue on Github if you’re interested.