SQL Tree - Query result node dialog



Use parent node attributes: If checked, use the colors and the icon of the parent node.
Icon: Define the icon for the node. Can be overridden for in the query context dependent with $<Icon:Number>$.
Text foreground color: Define the text color for the node. Can be overridden for in the query context dependent with $<ColorText:R,G,B>$.
Text background color: Define the text background color for node. Can be overridden for in the query context dependent with $<ColorBack:R,G,B>$.
Selected text foreground color: Define the text color for the node, if it is selected and the tree is activated. Can be overridden for in the query context dependent with $<ColorTextSelected:R,G,B>$.
Selected text background color: Define the text background color for the node, if it is selected and the tree is activated. Can be overridden for in the query context dependent with $<ColorBackSelected:R,G,B>$.
Inactive selected text foreground color: Define the text color for the node, if it is selected and the tree is not activated. Can be overridden for in the query context dependent with $<ColorTextSelectedInactive:R,G,B>$.
Inactive selected text background color: Define the text background color for the node, if it is selected and the tree is not activated. Can be overridden for in the query context dependent with $<ColorBackSelectedInactive:R,G,B>$.
Show item count: Define, if the number of the subitems or of all leaves of the subtree beneath the node should be displayed.

Overriding certain attributes depending on the context can be done as shown for this example query:

SELECT (CASE WHEN artist='Michael Jackson' THEN '$<ColorText:255,0,0><Icon:10>$' ELSE '' END)||artist "artist node",
               album
FROM MediaLibrary
GROUP BY artist,album
ORDER BY artist,album

This query will draw the node text for "artist node" with red color and will use the icon no. 10 for the node, if the artist is Michael Jackson. For all other nodes, the attributes set by this dialog will be used.