Upgrated from strapi 3 to 4, now filtering queries are not working

Questions and Answers
1
System Information
  • Strapi Version: 4.24.4
  • Operating System: mac
  • Database: mysql
  • Node Version: 16.20.2
  • NPM Version: 8.19.4
  • Yarn Version: 1.22.21

Hi i worked on this monorepo app, and had to migrate strapi 3 to strapi 4, everything is working fine, with the exception of REST queries with filters,
on strapi 3 we would do

https://xyz.com/api/calendar?active=true&startDate_gte=2024-07-01&endDate_lte=2024-07-31

now i tried to do
https://xyz.com/api/calendar?&filters[active][$eq]=true&filters[startDate][$lte]=2024-07-01

this is failing, and i get this error on console
[2024-07-26 08:26:16.104] http: GET /api/calendar?filters[active][$eq]=trued&filters[startDate][$lte]=2024-07-01 (28 ms) 500
[2024-07-26 08:34:35.472] error: select t0.* from calendar_items as t0 where (t0.filters[active][$eq] = ‘true’ and t0.filters[startDate][$lte] = ‘2024-07-01’) - ER_BAD_FIELD_ERROR: Unknown column ‘t0.filters[active][$eq]’ in ‘where clause’ Error: ER_BAD_FIELD_ERROR: Unknown column ‘t0.filters[active][$eq]’ in ‘where clause’

2

I don’t have the answer to your question. But have you gone through the migration guides?