I see SQL Editor (https://www.mediamonkey.com/addons/browse/item/sql-editor/) as a developer SQL test tool. It does not necessarily return ALL the hits (limited to about 1000) but it does give some feedback about the time taken - which is quite useful.

On the other hand, Custom Nodes 1.1.5 (https://www.mediamonkey.com/addons/browse/item/custom-nodes/) does save the SQL and can therefore be used to edit. It does return ALL hits and seems to me to be quicker.

Another thing you might want to do is use an Editor to keep your SQL. For example, EditPlus can be set-up to display the SQL colour coded the same as the Media Monkey 2024 SQL Editor add-on using a syntax file. The "syntax" file can be set up to apply to - for example - file with the extension .sql and .mcnc.

Hope this helps.

Thank you for your reply.

In my example, instead of a list with dates and corresponding times, only the main window with the specified MM fields such as composer, album artist, etc. is displayed.

I would like to see an output like in the addon SQL without having to [u]re-enter the entire query[/u]. In my example, you would only need to change album = ‘[b]Kristallen[/b]’ AND songtitle = ‘[b]The Wedding[/b]’.

[quote=rusty post_id=531123 time=1767121246 user_id=182]
fyi, the addon was updated awhile ago to include the ability to easily add/remove/same nodes from within the UI.

It's included in the MediaMonkey 2024 sample scripts directory but for convenience, is also available at: https://www.mediamonkey.com/addons/browse/item/custom-nodes/

Please share your favorite node queries!

-Rusty
[/quote]
https://www.dropbox.com/scl/fi/hvt42dp1gwx0ungpzbdo2/IansExportedNodes.mcnc?rlkey=15l07yb8wo96zupbfgrovykqs&dl=0

A selection a new nodes (and the original ones) that have been briefly checked in SQL Editor and then in Custom Nodes 1.1.5. Some are very specific to how I work with my library, but thanks to the new Custom Nodes you can easily edit the SQL.

My favorite at the moment is Missing NOT in Tag OR File. This refers to Artwork and my convention of only having a single front cover stored in both the tag AND stored (as folder.jpg or sometimes albumart.jpg).

How do I manage a SQL query in Custom Nodes (e.g., especially for recurring queries) to get output in a separate window?
Example
[quote][code]SELECT Strftime('%Y/%m/%d %H:%M:%S', ( Julianday(playdate) + 2415018.5 ),
'localtime')
AS plays
FROM played AS p
JOIN songs AS s
ON s.id = p.idsong
WHERE album = 'Kristallen'
AND songtitle = 'The Wedding';[/code][/quote]

[url=https://ibb.co/0jnmjK3c][img]https://i.ibb.co/C5wm56Fz/SQL-Result.png[/img][/url]

Carsten

fyi, the addon was updated awhile ago to include the ability to easily add/remove/same nodes from within the UI.

It's included in the MediaMonkey 2024 sample scripts directory but for convenience, is also available at: https://www.mediamonkey.com/addons/browse/item/custom-nodes/

Please share your favorite node queries!

-Rusty

Re the custom nodes addon, AFAIK currently there is only the customNodes sample script (copy it from sampleScripts to scripts folder) where you can define custom nodes like this: https://www.dropbox.com/s/zz72gh529883rxg/Screenshot%202022-07-25%2013.50.14.png?dl=0

MM 5.0.4.2657 Alpha

[quote] by RiffRaffAK » 23 Jul 2022, 02:08
How do you configure Custom Nodes in MMW5?[/quote]

One access: TOOLS> Options> Library>Collections and Views
Double click on your collection (Music)
Then on the Sub-Nodes tab - here you can select from the available nodes and also change the order in the view.

[url=https://ibb.co/RBX1bzp][img]https://i.ibb.co/8dyJs6D/Unbenannt.jpg[/img][/url]

[quote=RiffRaffAK post_id=499451 time=1658534896 user_id=54374]
How do you configure Custom Nodes in MMW5? The only options I have after installing are: Show Pop & Rock genres
or
Show 5 most played tracks.

None of these are what I need. Specifically, I am trying to configure a Music Subnode for Complete Albums. Can anyone help with this?
[/quote]
You mentioned both nodes and sub-nodes in your query. Which of these are you wanting to create?
Firstly let's agree on the definition of "subnode" .... is it #1 or #2 [url=https://www.dropbox.com/s/euoge8ud09o5lnf/nodes%20v%20subnodes.png?dl=0]in this diagram[/url] ?

FWIIW #1 is a node (aka Collection), and #2 is a sub-node.

If you asking about #2, there is no way to create a custom sub-node in MM5.
That would need to handled by a Add-on,. There was one in MM4 (MagicNodes), but I am not aware of any that could do that for you in MM5 atm

Creating a new node is simple to achieve, but it requires the Gold Version of MM5, ie. not the free version.
How it works is [url=https://www.mediamonkey.com/wiki/index.php/WebHelp:Playback_Rules/5.0]documented here[/url].
The instructions are sketchy. Ask again if you need more assistance.

How do you configure [url=https://www.mediamonkey.com/addons/browse/item/custom-nodes/]Custom Nodes in MMW5[/url]? The only options I have after installing are: Show Pop & Rock genres
or
Show 5 most played tracks.

None of these are what I need. Specifically, I am trying to configure a Music Subnode for Complete Albums. Can anyone help with this?