Hello everyone, I hope you are well. I have an order database table with a line_items field which is a list of objects. These objects contain the field product_id. I then want to query all order records where line_items has an item with product_id=xxx.
How can I do this? I haven't found any filters to help me (most seem to be restricted for query operations).