Thanks for your response, let me clarify my question further. I have already populated the necessary table, however instead of populating it your way in the sample json payload, I need to populate/update my database in the below format
{
"table":"products",
"id":1,
"doc":
{
"text" : {"text": some text"},
"price" : 19.85
}
}
In this case, the text field is stored as a JSON object instead of TEXT in the database. Now it comes back to my previous question which is asking if I can somehow conduct a full text search on this field. Right now when I try to do a search query with full text search syntax described in the api e.g. (Match: "_all": "some | text")
I would not get any result back. Hopefully I have clarified my question here.