niota

fascinating. logical.

User Tools

Site Tools


niota-docs:niota_system_config_sql

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

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        | or   |     | +| standard grid      | C            | J          | W           | G        | or O++   |     | 
-| 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        ​    | +| lookup pull down   | C+           | J          | W           | G        | O          ​    | 
-| lookup relation ​   | C++          | J          | W           | G        | A        ​    |+| lookup relation ​   | C++          | J          | W           | G        | O          ​    |
  
  
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\\
 \\ \\
-system configuration\\+instance definition union clause\\
 ? - not available\\ ? - not available\\
  
  
niota-docs/niota_system_config_sql.1662379066.txt.gz · Last modified: 2025/07/17 14:11 (external edit)