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 disease of anatomical entity which occurs in the blood, heart, blood vessels or the lymphatic system that passes nutrients (such as amino acids and electrolytes), gases, hormones, blood cells or lymph to and from cells in the body to help fight diseases and help stabilize body temperature and pH to maintain homeostasis.",
"sort_ascending": "disease_tree?object=eq.\"A disease of anatomical entity which occurs in the blood, heart, blood vessels or the lymphatic system that passes nutrients (such as amino acids and electrolytes), gases, hormones, blood cells or lymph to and from cells in the body to help fight diseases and help stabilize body temperature and pH to maintain homeostasis.\"\u0026order=object.asc\u0026limit=20",
"sort_descending": "disease_tree?object=eq.\"A disease of anatomical entity which occurs in the blood, heart, blood vessels or the lymphatic system that passes nutrients (such as amino acids and electrolytes), gases, hormones, blood cells or lymph to and from cells in the body to help fight diseases and help stabilize body temperature and pH to maintain homeostasis.\"\u0026order=object.desc\u0026limit=20",
"sort_none": "disease_tree?object=eq.\"A disease of anatomical entity which occurs in the blood, heart, blood vessels or the lymphatic system that passes nutrients (such as amino acids and electrolytes), gases, hormones, blood cells or lymph to and from cells in the body to help fight diseases and help stabilize body temperature and pH to maintain homeostasis.\"\u0026limit=20",
"reset": "disease_tree?limit=20"
}