v3.x mAirListDB: See which virtual folders an item is a member of?

The more I work in mAirListDB, the more I would appreciate an easy way (a context menu item perhaps?) to know which virtual folders a file is in.

Maybe it would be enough for the menu item (or keypress?) to simply show a message box like this:

Message Box Caption: Folder Membership
Message Box Text:
[b]Title
Artist

is in virtual folder(s):

Music
1960s
Number Ones
Classic Gold[/b]

What do you think? Would that be relatively easy to do? It would be VERY useful.

BFN
Cad

Hi Cad,
did you check the database of version 4?
There you can see this information. This is a great new feature.
There is a tree-view with checkboxes.
But I’m still wondering, how I can find a song which is located in two or more folders.
For example: How can I find a song which is located in 1960s AND Number Ones?

Martin

[quote=“calypso60, post:2, topic:7421”]But I’m still wondering, how I can find a song which is located in two or more folders.
For example: How can I find a song which is located in 1960s AND Number Ones?[/quote]

Not possible at the momen. But you could learn SQL and create a custom report :wink:

Regarding the original question: This is a new feature in v4, and there are no plans to backport it to v3.1.

Well, I would like to do that. But where should I start?
Where can I find a tutorial for the first steps or a simlpe example for a search statement?

If it’s a local mAirListDB, you need sqlite3.exe in order to access the database file: http://www.sqlite.org/download.html

Scroll down to “Precompiled Binaries for Windows”, and download the command line shell, sqlite3.exe.

It must be started from the Windows command line, with the database file name as parameter. I copied sqlite3.exe into the same folder as the database.db file and created a batch file like this:

sqlite3 database.db

The table structure can be retrieved using the command “.schema” (without the quotes).

There might be graphical frontends available, I’m pretty sure there are, but I haven’t used any myself.

For a networked mAirListDB, PostgreSQL’s psql or pgAdmin III can be used.

An SQL tutorial can e.g. be found here: http://www.w3schools.com/sql/default.asp

Here’s the statement that returns the IDs of all items that are assigned to more than one folder:

SELECT item, COUNT(folder) FROM item_folders GROUP BY item HAVING COUNT(folder)>1;

Thanks a lot!