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 bone osteosarcoma that is characterized by the presence of osteoid extracellular matrix and that arises from the medullary portion of the bone. It affects the long bones and most commonly, the distal femur, proximal tibia, and proximal humerus. Pain with or without a palpable mass is the most common clinical presentation.",
"sort_ascending": "disease_tree?object=eq.\"A bone osteosarcoma that is characterized by the presence of osteoid extracellular matrix and that arises from the medullary portion of the bone. It affects the long bones and most commonly, the distal femur, proximal tibia, and proximal humerus. Pain with or without a palpable mass is the most common clinical presentation.\"\u0026order=object.asc\u0026limit=20",
"sort_descending": "disease_tree?object=eq.\"A bone osteosarcoma that is characterized by the presence of osteoid extracellular matrix and that arises from the medullary portion of the bone. It affects the long bones and most commonly, the distal femur, proximal tibia, and proximal humerus. Pain with or without a palpable mass is the most common clinical presentation.\"\u0026order=object.desc\u0026limit=20",
"sort_none": "disease_tree?object=eq.\"A bone osteosarcoma that is characterized by the presence of osteoid extracellular matrix and that arises from the medullary portion of the bone. It affects the long bones and most commonly, the distal femur, proximal tibia, and proximal humerus. Pain with or without a palpable mass is the most common clinical presentation.\"\u0026limit=20",
"reset": "disease_tree?limit=20"
}