How do we enter different Operators such as “Like” or “Is Null” in the screen data base query, as in the example below?
We have tried adding the operators into the XML query directly but these are removed as they are not detailed in the section shown below which appears just before the XML query in the screen metadata.
See highlighted bits below.
"primary_table": {
"name": "product",
"key_attrs":
{
"key_attr": "product_id"
}
],
"constraints": <
{
"name": "product.place_id",
"operator": "EQ",
"variable": "portal_places"
},
{
"name": "product.part_id",
"operator": "<LIKE>",
"value": "ABC"
}
]
},
Or,
"name": "product.service_id",
"operator": "EQ",
"variable": "" (or NULL)