Simple enough. The dates and limits are arbitrary and work for me. Once I play through all of my 5's or 4's, I'll reset the date that gets compared to last_played to start the list over. The "julianday" portions are for when I reset the date -- this keeps recently-played tracks (three weeks for 5's and six for 4's) from ending up in the playlist.

Lost all my queries!I have just updated from 1.1.9 beta to 1.1.9 release and lost all my SQL tree queries.

I'm using SQL Tree within Panel splitter but all other panels okay. The SQL Tree panel contains nothing. Clicking 'Create example nodees' does nothing. Trying to add new folder or query calls up dialog form but after clicking OK - nothing displayed in the panel.

The only way to be able to re-create any folders or queries is to remove the panel from the config and then add a new one.

Lost all my queries!I have just updated from 1.1.9 beta to 1.1.9 release and lost all my SQL tree queries.

There is no relation between the release update and the loss of your queries. The problem you described can only happen, if your foo_ui_columns.dll.cfg file gets corrupted somehow. I'm aware, that there is a weak point in the way, it is currently implemented in case of such failures, but I don't have a better idea at the moment for a safer implementation. You should always have a proper backup process to overcome such situations.

QUOTE (Black_Over_Bills_Mothers @ Nov 8 2011, 13:14)

The only way to be able to re-create any folders or queries is to remove the panel from the config and then add a new one.

Or you recover the following files from your backup (maybe you also use foo_jesus?): foo_ui_columns.dll.cfg, foo_uie_sql_tree.db, foo_uie_sql_tree.dll.cfg

QUOTE (Black_Over_Bills_Mothers @ Nov 8 2011, 13:14)

I could live with it if we could export\import queries!

This might be implemented later for exchanging queries, but it does not substitute a proper backup process.

Thanks for this component. I'm having fun playing with it right now! I have a question... Using SQL tree console, when I get a result from my queries that will consist of a short-list of tracks (Artist, Album, Title), is there a way to direct these track related results to the selection Playlist, a specified Playlist and/or the Playback Queue?

Just a small reminder. Any chance of a few common context menu items such as Properties?

The item for Properties is already on the todo list for the next release, but I won't add any other items.

QUOTE (Zarty @ Nov 9 2011, 13:19)

Using SQL tree console, when I get a result from my queries that will consist of a short-list of tracks (Artist, Album, Title), is there a way to direct these track related results to the selection Playlist, a specified Playlist and/or the Playback Queue?

No, this is not the purpose of the SQL tree console, that's what the panel is for, although sending to the playback queue is not supported and won't be in the future. The result rows in the console might match tracks one by one by coincidence, but generally they don't.

No, this is not the purpose of the SQL tree console, that's what the panel is for, although sending to the playback queue is not supported and won't be in the future. The result rows in the console might match tracks one by one by coincidence, but generally they don't.

Yes, now I see. I looked at the panel initially but didn't click on the library nodes to see the playlist that is created. This is even better than I thought.

Well it happened the very next startup after installing 1.1.10 beta 1.

That is strange. The relevant code was more or less implemetend from the beginning and I made several release updates during the development of the component and even after your first report on this without such a problem.

I don't mean to bother you (fbuser) and I know how reluctant you are to add additional features to this plug-in but if I don't ask I certainly won't get. So if you would be so kind as to consider the features below I would be greateful;

1) Won't implement2) Not decided yet3) Won't implement4) Won't implement5) Won't implement, because it is not possible to do it in a clean way. Either the double click action would always also perform the click action or a delay for the click action needed to be defined to distinguish a click from a double click.

QUOTE (Black_Over_Bills_Mothers @ Nov 20 2011, 09:05)

Bug: The status of Start playback option for the middle click action isn't saved. If I check this and then restart it is back unchecked. I've not tested same for Click action.

Thanks for reporting. Will be fixed with the next release. It only affects middle click action, not the click action.

QUOTE (gob @ Dec 7 2011, 07:14)

. A standard foobar2000 context menu for node children with the sql_tree context menu available via a modifier.

Won't implement

QUOTE (gob @ Dec 7 2011, 07:14)

. Double click, enter, space bar actions

Won't implement. The reason for double click, see above. Space is already bound to the click action, Enter to the edit command.

QUOTE (gob @ Dec 7 2011, 07:14)

. Hide node icons

Not decided yet, see above.

QUOTE (gob @ Dec 7 2011, 07:14)

. Hide horizontal/vertical scroll bar

Won't implement.

QUOTE (gob @ Dec 7 2011, 07:14)

. Option to hide +/- for the root node

Won't implement. Be aware that, you can have multiple root nodes, not only one.

QUOTE (gob @ Dec 7 2011, 07:14)

. Option to make the scroll bars stick to the very edge of the panel

I'm not sure, what you mean. I can see, that there is a glitch, which places the scrollbars two pixels next to the edges. This fill be fixed with the next release.

QUOTE (gob @ Dec 7 2011, 07:14)

Also, the undo options seem to be unusable after a playlist has been modified by foo_sql_tree.

Will be changed for the next release.

QUOTE (chiwou @ Dec 13 2011, 18:56)

Hi how can I display all albums that have the genre tag soundtrack

this is what I've have

CODE

SELECT genre "Genre" FROM MediaLibraryWHERE genre LIKE 'soundtrack'

works great but only for albums which have the 'Soundtrack' as their ONLY tag not for all with multiple values

First of all your query is wrong for your purpose. The correct query would look like this:

CODE

SELECT genre "Genre" FROM MediaLibraryWHERE genre LIKE '%soundtrack%'

But a better approach would be to define a new column for the MediaLibrary table in the preferences:1. Go to Preferences -> Media Library -> SQL tree -> MediaLibrary table2. Press Add3. Define the new column with the following values: Type: Tag Name: genre_mv (or any other name you like) Tag -> Name: genre Split multivalue tag: Checked