User Tools
niota-docs:niota_system_config_sql
Differences
This shows you the differences between two versions of the page.
| Both sides previous revision Previous revision Next revision | Previous revision | ||
|
niota-docs:niota_system_config_sql [2022/09/05 12:56] admin |
niota-docs:niota_system_config_sql [2025/07/17 14:11] (current) |
||
|---|---|---|---|
| Line 1: | Line 1: | ||
| - | ^ SQL type ^ column list ^ where cond. ^ group by ^ order by ^ union ^ | + | ^ SQL type ^ column list ^ join cond. ^ where cond. ^ group by ^ order by ^ union ^ |
| - | | standard grid SQL | A | A | A | A or X | A | | + | | standard grid | C | J | W | G | O or O++ | U | |
| - | | detail grid SQL | A | A + B | ? | | + | | detail grid | C | J | W+ | G | | U | |
| - | | advanced filter | data instance | filter-data link + instance | n/a | | + | | 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 | | ||
| - | A - instance definition / master instance definition// | + | |
| - | B - master detail linked columns// | + | |
| - | X - system configuration// | + | C - instance definition column list\\ |
| - | ? - not available// | + | 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\\ | ||
niota-docs/niota_system_config_sql.1662375401.txt.gz · Last modified: 2025/07/17 14:11 (external edit)