User Tools
Sidebar
niota-docs:niota_system_config_sql
This is an old revision of the document!
| SQL type | column list | join cond. | where cond. | group by | order by | union |
|---|---|---|---|---|---|---|
| standard grid | C | J | W | G | A or X | A |
| detail grid | C | J | W+ | G | ||
| advanced filter | C | J | W++ | G | D | |
| lookup pull down | C+ | J | W | G | A | A |
| lookup relation | C++ | J | W | G | A | A |
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
W - advanced filter linked columns
D - advanced filter order by ID
G - instance definition group by clause
X - system configuration
? - not available
niota-docs/niota_system_config_sql.1662379000.txt.gz · Last modified: 2025/07/17 14:11 (external edit)