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:57] 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 23: | Line 23: | ||
| O - instance definition order by clause\\ | O - instance definition order by clause\\ | ||
| O+ - 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\\ | ||