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 13:56] admin |
niota-docs:niota_system_config_sql [2025/07/17 14:11] (current) |
||
|---|---|---|---|
| Line 1: | Line 1: | ||
| ^ SQL type ^ column list ^ join cond. ^ where cond. ^ group by ^ order by ^ union ^ | ^ SQL type ^ column list ^ join cond. ^ where cond. ^ group by ^ order by ^ union ^ | ||
| - | | standard grid | C | J | W | G | A or X | A | | + | | standard grid | C | J | W | G | O or O++ | U | |
| - | | detail grid | C | J | W+ | G | | | | + | | detail grid | C | J | W+ | G | | U | |
| - | | advanced filter | C | J | W++ | G | D | | | + | | advanced filter | C | J | W++ | G | O+ | U | |
| - | | lookup pull down | C+ | J | W | G | A | A | | + | | lookup pull down | C+ | J | W | G | O | U | |
| - | | lookup relation | C++ | J | W | G | A | A | | + | | lookup relation | C++ | J | W | G | O | U | |
| Line 16: | Line 16: | ||
| J - instance definition join condition | J - instance definition join condition | ||
| \\ | \\ | ||
| - | W - instance definition where condition | + | W - instance definition where condition\\ |
| W+ - master-detail linked columns\\ | W+ - master-detail linked columns\\ | ||
| W++ - data-filter linked columns\\ | W++ - data-filter linked columns\\ | ||
| \\ | \\ | ||
| - | W - advanced filter linked columns\\ | + | O - instance definition order by clause\\ |
| - | D - advanced filter order by ID\\ | + | O+ - advanced filter order by ID\\ |
| + | O++ - system configuration\\ | ||
| \\ | \\ | ||
| G - instance definition group by clause\\ | G - instance definition group by clause\\ | ||
| \\ | \\ | ||
| - | X - system configuration\\ | + | U - instance definition union clause\\ |
| ? - not available\\ | ? - not available\\ | ||
niota-docs/niota_system_config_sql.1662379000.txt.gz · Last modified: 2025/07/17 14:11 (external edit)