Query SQL form AwareIM Documentation

This page is read only. You can view the source, but not change it. Ask your administrator if you think this is wrong.

{{tag>Index Glossary Query_SQL_Form Query}}
===== 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:

<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 [[glossary:query_simple_form|simple form]].