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 | A | A | A | A | A or X | A |
| detail grid | A | A | A + B | ? | ||
| advanced filter | A | A | C | ? | D | |
| lookup pull down | A | A | A | A | A | A |
A - instance definition / master instance definition
B - master detail linked columns
C - advanced filter linked columns
D - advanced filter order by ID
X - system configuration
? - not available
niota-docs/niota_system_config_sql.1662375876.txt.gz · Last modified: 2025/07/17 14:11 (external edit)