This shows you the differences between two versions of the page.
| |
| docs:7000_glossary:query_sql_form [2022/09/01 06:20] – created - external edit 127.0.0.1 | docs:7000_glossary:query_sql_form [2022/09/02 05:41] (current) – ↷ Page moved from docs:7000_glossary:query_sql_form to 7000_glossary:query_sql_form administrator |
|---|
| ===== Query SQL form ===== | |
| |
| The SQL form is a section of the query editor in the [[docs:7000_glossary:configuration_tool|Configuration Tool]] where the [[docs:7000_glossary:configurator|configurator]] can specify a [[docs:7000_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 [[docs:7000_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 | |
| Member.* | |
| FROM | |
| Library_Member AS Member | |
| WHERE | |
| (Member.Age > 16) ORDER BY Member.LastName</code> | |
| |
| |
| |
| This particular example can also be specified using the [[docs:7000_glossary:query_simple_form|simple form]]. | |
| |
| |
| |