| SQL type | column list | join cond. | where cond. | group by | order by | union |
|---|---|---|---|---|---|---|
| standard grid | C | J | W | G | O or O++ | U |
| detail grid | C | J | W+ | G | U | |
| advanced filter | C | J | W++ | G | O+ | U |
| lookup pull down | C+ | J | W | G | O | U |
| lookup relation | C++ | J | W | G | O | U |
C - instance definition column list
C+ - 2 columns only
C++ - 3 columns mandatory
J - instance definition join condition
W - instance definition where condition
W+ - master-detail linked columns
W++ - data-filter linked columns
O - instance definition order by clause
O+ - advanced filter order by ID
O++ - system configuration
G - instance definition group by clause
U - instance definition union clause
? - not available