This shows you the differences between two versions of the page.
| Both sides previous revision Previous revision | |
| ref:glossary:query_sql_form [2026/08/13 00:43] – ↷ Page moved from glossary:query_sql_form to ref:glossary:query_sql_form localdev | ref:glossary:query_sql_form [2026/08/13 00:43] (current) – ↷ Links adapted because of a move operation localdev |
|---|
| ===== Query SQL form ===== | ===== Query SQL form ===== |
| |
| The SQL form is a section of the query editor in the [[glossary:configuration_tool|Configuration Tool]] where the [[glossary:configurator|configurator]] can specify a [[glossary:query|query]] using the SQL, a language that database management systems understand. It can be used by SQL experts for queries that are too complex to be defined in the [[glossary:query_simple_form|simple form]] and, for some reasons, cannot be specified using the rule form. For example, a query in the SQL form that finds all members over 16 years old and lists them in the alphabetical order may look like this: | The SQL form is a section of the query editor in the [[ref:glossary:configuration_tool|Configuration Tool]] where the [[ref:glossary:configurator|configurator]] can specify a [[ref:glossary:query|query]] using the SQL, a language that database management systems understand. It can be used by SQL experts for queries that are too complex to be defined in the [[ref:glossary:query_simple_form|simple form]] and, for some reasons, cannot be specified using the rule form. For example, a query in the SQL form that finds all members over 16 years old and lists them in the alphabetical order may look like this: |
| |
| <code sql>SELECT | <code sql>SELECT |
| |
| |
| This particular example can also be specified using the [[glossary:query_simple_form|simple form]]. | This particular example can also be specified using the [[ref:glossary:query_simple_form|simple form]]. |
| |
| |
| |