How to query json field in strapi

Questions and Answers Strapi Backend
1

Hi, i would like to know if it is possible to make a query to a json field

I have something like this

jsonField: {
questions: [1,2,3,4]
}

and want to get all registers what jsonField.questions contains some param, like 2.

I have something like this
await strapi.db
.query(“api::sensor.sensor”)
.findMany({
where: { “relatedQuestions.questions”: { $in: id } },
});
but doesnt work

some example? of documentation to do this?

Thanks

2

Maybe you need to create a custom controller for this