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