SQL Tree - Query node dialog - Query



SQL query: Define the query which creates the subtree beneath the query nodes. Each column of the select statement defines a level in the subtree hierarchie (from left to right). Basically, all possible select statements can be used with a few restrictions: For a proper parsing of the select list, expressions containing spaces must be enclosed in parentheses (e.g. case-when expressions). For playlist relevant click actions (see there) some additional restrictions exist. The order-by clause of the select statement will also be used as sort order, when sending the result to a playlist. Therefore it is a good idea to add for example the tracknumber to the order-by clause, although it is not recommended to add the single tracks to the query itself.
Apply: Apply all modifications and update the result node option list.
Revert: Discard all modifications.
Edit: Edit the result node options.