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