SQL Tree - Query node dialog - Advanced



Refresh query on use: Refresh the query, whenever it is "used", i.e. expanding the node or clicking on the node, and the node is considered to be updated, i.e. metadata has changed.
Refresh query on load: Refresh the query after each start of foobar2000
Omit <null>: Don't create a node, if it has the value <null>. Children of such nodes will be added to the next available parent node.
Remove duplicates when sending to a playlist: While a simple query normally does not produce duplicate records this can easily occur for queries containing splitted multivalue fields or compound queries using for example the UNION ALL operator. Depending on the amount of tracks, unticking this option might result in a slightly faster sending of the tracks to the playlist.
Query node limit: Limit the node number for this query to avoid memory problems due to too many nodes and due to "infinitely" running SQL queries as well.