For like
and ilike
operators, use *
to match any character (instead
of %
).
object -- {
"table": "disease_tree",
"label": "",
"description": "",
"datatype": "line",
"structure": "",
"sql_type": "TEXT",
"numeric": false,
"filtered_operator": "eq",
"filtered_constraint": "A bacterial pneumonia that is caused by the bacterial species Mycoplasma pneumoniae. The symptoms include chest pain, chills, dry cough which is not bloody, excessive sweating, fever, headache and sore throat.",
"sort_ascending": "disease_tree?object=eq.\"A bacterial pneumonia that is caused by the bacterial species Mycoplasma pneumoniae. The symptoms include chest pain, chills, dry cough which is not bloody, excessive sweating, fever, headache and sore throat.\"\u0026order=object.asc\u0026limit=20",
"sort_descending": "disease_tree?object=eq.\"A bacterial pneumonia that is caused by the bacterial species Mycoplasma pneumoniae. The symptoms include chest pain, chills, dry cough which is not bloody, excessive sweating, fever, headache and sore throat.\"\u0026order=object.desc\u0026limit=20",
"sort_none": "disease_tree?object=eq.\"A bacterial pneumonia that is caused by the bacterial species Mycoplasma pneumoniae. The symptoms include chest pain, chills, dry cough which is not bloody, excessive sweating, fever, headache and sore throat.\"\u0026limit=20",
"reset": "disease_tree?limit=20"
}