Filtering a Json, the operator $in is not working

Questions and Answers
1
System Information
  • Strapi Version: 4.10.6
  • Operating System: windows 11
  • Database: Postgresql
  • Node Version: 14.21.1
  • NPM Version: 6.14.17

image
image1814×498 69.6 KB

image

I’m querying a json field with the $in operator and is not working, it only works with $containsi operator but it will return the data when I use the id 39 and 3 (when the id_account is 392 for example) because is “contained”, I have read that we are limited when the field type is json but I need an array field because my idea is to use multiples id_account for each entry, and filtering in the frontend sending the id_account in the request as a filter, any suggestion?