For like
and ilike
operators, use *
to match any character (instead
of %
).
object -- {
"table": "disease_tree",
"label": "",
"description": "",
"datatype": "line",
"structure": "",
"sql_type": "TEXT",
"numeric": false,
"filtered_operator": "eq",
"filtered_constraint": "A breast secretory carcinoma that is characterized by numerous cysts of varying sizes containing gelatinous material on gross examination, microscopically dilated ducts containing eosinophilic secretion and the absence of micropapillary pattern and cytological atypia in the lining epithelium.",
"sort_ascending": "disease_tree?object=eq.\"A breast secretory carcinoma that is characterized by numerous cysts of varying sizes containing gelatinous material on gross examination, microscopically dilated ducts containing eosinophilic secretion and the absence of micropapillary pattern and cytological atypia in the lining epithelium.\"\u0026order=object.asc\u0026limit=20",
"sort_descending": "disease_tree?object=eq.\"A breast secretory carcinoma that is characterized by numerous cysts of varying sizes containing gelatinous material on gross examination, microscopically dilated ducts containing eosinophilic secretion and the absence of micropapillary pattern and cytological atypia in the lining epithelium.\"\u0026order=object.desc\u0026limit=20",
"sort_none": "disease_tree?object=eq.\"A breast secretory carcinoma that is characterized by numerous cysts of varying sizes containing gelatinous material on gross examination, microscopically dilated ducts containing eosinophilic secretion and the absence of micropapillary pattern and cytological atypia in the lining epithelium.\"\u0026limit=20",
"reset": "disease_tree?limit=20"
}