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.
|