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 leishmaniasis that involves a chronic inflammatory process involving the nasal, pharyngeal, and laryngeal mucosa, which can lead to extensive tissue destruction, caused by protozoan parasites belonging to the genus Leishmania. The infection is characterized by granulomatous lesion which can destroy upper respiratory tract mucosa.",
"sort_ascending": "disease_tree?object=eq.\"A leishmaniasis that involves a chronic inflammatory process involving the nasal, pharyngeal, and laryngeal mucosa, which can lead to extensive tissue destruction, caused by protozoan parasites belonging to the genus Leishmania. The infection is characterized by granulomatous lesion which can destroy upper respiratory tract mucosa.\"\u0026order=object.asc\u0026limit=20",
"sort_descending": "disease_tree?object=eq.\"A leishmaniasis that involves a chronic inflammatory process involving the nasal, pharyngeal, and laryngeal mucosa, which can lead to extensive tissue destruction, caused by protozoan parasites belonging to the genus Leishmania. The infection is characterized by granulomatous lesion which can destroy upper respiratory tract mucosa.\"\u0026order=object.desc\u0026limit=20",
"sort_none": "disease_tree?object=eq.\"A leishmaniasis that involves a chronic inflammatory process involving the nasal, pharyngeal, and laryngeal mucosa, which can lead to extensive tissue destruction, caused by protozoan parasites belonging to the genus Leishmania. The infection is characterized by granulomatous lesion which can destroy upper respiratory tract mucosa.\"\u0026limit=20",
"reset": "disease_tree?limit=20"
}