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