I have a JSONField which is an empty list ([]) by default. The data stored in the field is as follows: [{"operand":"key1", "value":"value1"},{"operand":"key2", "value":"value2"} and so on....] Now the value of the keys can be an array also like: [{"operand":"key1", "value":["value1","value2","value3"]}]
Now I want to search this JSONField and return the result if the search query is present in the values of either "operand" or "value".
So for example is search query comes as "value", "value1", "key", "key2", the above mentioned record should be returned.
So how to implement it in Django?