For like
and ilike
operators, use *
to match any character (instead
of %
).
subject -- {
"table": "disease_tree",
"label": "",
"description": "",
"datatype": "ID",
"structure": "",
"sql_type": "TEXT",
"numeric": false,
"sorted": "desc",
"sort_ascending": "disease_tree?retraction=eq.\"0\"\u0026order=subject.asc\u0026limit=20\u0026offset=0",
"sort_descending": "disease_tree?retraction=eq.\"0\"\u0026order=subject.desc\u0026limit=20\u0026offset=0",
"sort_none": "disease_tree?retraction=eq.\"0\"\u0026limit=20\u0026offset=0",
"reset": "disease_tree?retraction=eq.\"0\"\u0026limit=20\u0026offset=0"
}