how to include quote within LIKE keyword in Dbxquery?
For example: There are 10k people in the DB and I would like to query only those who contains number:123
The problem is the content has quote ". Note I cannot filter only 123 because it will also match another record.
name = person1
content = {"description:"test",number":123,"status":"good"}
| dbxquery connection = visibility query = "select name, content from TestDB where content like '%number":123%'
Thanks
Have you tried escaping the quotation mark? Just a guess.
| dbxquery connection = visibility query = "select name, content from TestDB where content like '%number\":123%'"