Issues in query all records

Khan aqib

I have one column as JSON Array it contains multiple row value with 2 columns in it.

eg module_name and updated_time

I have to query all records and along with that I have to add two where condition one is on

module_name which is "equal" condition and another one is on updated_time which is "less then or equal (<=)" condition

"equal" condition is working I have created one array object and [{"module_name": "catalog_update"}] it fetch data properly according to condition

but 

"less then or equal (<=)" condition is not working can anyone help?

I have also attached screenshot Please have a look

Michael Udinski

Hi @Khan aqib since cron_updated_time is an object array, you will first need to bind the field in order to perform this expression correctly. (Take a look starting at 17:42 in the video below)

https://youtu.be/cUDdGudAMJ0?t=1062