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(1) | A | A | A | A or X | A |
| detail grid | A | A | A AND B | ? | ||
| advanced filter | A | A | C | ? | D | |
| lookup pull down | A+ | A | A | A | A | A |
| lookup relation | A++ | A | A | A | A | A |
A - instance definition / master instance definition
A+ - 2 columns only
A++ - 3 columns mandatory
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.1662378284.txt.gz · Last modified: 2025/07/17 14:11 (external edit)