Dynamic select fields
Lookup tables can be queried dynamically by adding a JSONQuery to the field and setting some parameters with #fieldname
, the system will substitute the #fieldname
parameter with the current value and update the lookup values.
Example:
{
"filter": [
{
"column": "enddate",
"operator": "<=",
"value": #date
},
{
"column": "startdate",
"operator": ">=",
"value": #date
}
],
"sort": [],
"paging": {
"pageLength": 500,
"currentPage": 1
}
}