For like
and ilike
operators, use *
to match any character (instead
of %
).
annotation -- {
"table": "disease_tree",
"label": "",
"description": "",
"datatype": "line",
"structure": "",
"sql_type": "TEXT",
"numeric": false,
"sort_ascending": "disease_tree?order=annotation.asc\u0026limit=20\u0026offset=6660",
"sort_descending": "disease_tree?order=annotation.desc\u0026limit=20\u0026offset=6660",
"sort_none": "disease_tree?limit=20\u0026offset=6660",
"reset": "disease_tree?limit=20\u0026offset=6660"
}