Clementine: dynamic playlists don't allow mixing AND and OR arguments

[Clementine-Issue-Importer]

_From gobnuts on December 05, 2010 21:53:21_

I cannot create a new smart playlist in which I have the following settings (for example):

One of the following is true:
genre contains: Genre A
OR
genre contains: Genre B

AND
the following is true:
Rating is greater than: 3

To sum it up: I can use the three arguments connected by AND or by OR, but not mix the arguments.
I guess a dynamic playlist with the parameters
"genre a OR b OR c" AND "rating>2 OR rating<5"
is rather common.

This could be done by basically duplicating what's there already.

One set is for AND, the other is for OR arguments, both are (automatically connected by AND

basically, the way it was in amarok
have to sections, one were all terms have to match (AND), and another were one has to match (OR)
Example Image: http://www.freeimagehosting.net/image.php?71f5c45084.png (the first checkbox has the OR arguments, the second one the AND arguments

_Original issue: http://code.google.com/p/clementine-player/issues/detail?id=1026_

[Clementine-Issue-Importer]

_From [email protected] on December 26, 2010 17:58:38_

This would be really good indeed!

[Clementine-Issue-Importer]

_From keirangtp on December 27, 2010 08:19:12_

Well, you can't do this:

"genre a OR b OR c" AND "rating>2 OR rating<5"

... using this:

One set is for AND, the other is for OR arguments, both are (automatically connected by AND)

... right?

[Clementine-Issue-Importer]

_From [email protected] on December 27, 2010 15:03:15_

If I'm reading his proposal right it means that there could be groups of evaluations where all groups are linked with AND while all elements within each group are linked with OR.

eg:

(a OR b OR c) AND (d OR e) AND (f)

This would actually make a lot of sense, the user would never define AND/OR evaluations but just create groups.

[Clementine-Issue-Importer]

_From [email protected] on December 27, 2010 15:48:41_

The following quick'n'dirty mockup is a result of (lack of time AND subpar gimp skills) OR (lazyness):

With the aforementioned evaluation logic this example would be

(genre contains "Lounge" OR genre contains "Downtempo") AND (year equals 2001 OR year equals 2002) AND (rating is greater than 1.5)

I think such a system would cover almost all use cases while still easy to understand and relatively easy to present in the gui.

Attachment: DynamicEvaluations.png

[Clementine-Issue-Importer]

_From keirangtp on December 28, 2010 00:33:13_

Mockup misses the ability to choose operators (I mean AND and OR, both: inside a group and between them) but other than that - looks pretty clean to me. Still, it's David's decision whether we do this.

PS. If we do this, since it introduces more criteria rows than typical usage we expected, this is blocked on issue #1065 .

Blockedon: 1065

[Clementine-Issue-Importer]

_From davidsansome on April 15, 2011 02:31:43_

Issue 1760 has been merged into this issue.

[Clementine-Issue-Importer]

_From andreas.k.h.von.rueden on May 01, 2011 11:58:42_

There sould be a NOT operator, too. See issue #1836

[Clementine-Issue-Importer]

_From matthias.mendler on November 16, 2011 01:46:37_

I’d love the option to type your query, to make it more flexible. I don’t know, how this could be solved well by a GUI.

I made a smart playlist in Banshee by manually editing the query in its db.

I am usually trying to make something like this:
genre = Metal AND (comment has speed OR comment has trash OR comment has death)

If there be a way to type that yourself, that’d be great.

[Clementine-Issue-Importer]

_From eddward on December 02, 2011 18:36:39_

I'm a bit new to Clementine, but my use case is I think a bit different. I would need something like

(a1 AND a2 AND a3) OR (b1 AND b2 AND b3) AND ...

for something like

((rating > 4) AND (lastplayed > 1 month ago)) OR ((rating > 3) AND (rating <= 4) AND (lastplayed > 1 month ago)) OR ...

[Clementine-Issue-Importer]

_From eddward on December 02, 2011 18:42:37_

I just saw 1968. I guess my use case could also be solved if I could make a bunch of 'AND'-type smart play lists and then have one special play list that was the union of the AND play lists.

[Clementine-Issue-Importer]

_From sledge.sulaweyo on April 13, 2012 00:52:27_

+1 for that one
an easy way to solve this would be to enter a query and not build a big GUI - just one line where you can enter all you want with the standard logic parameters.

[Clementine-Issue-Importer]

_From davidsansome on April 19, 2012 01:06:49_

Issue 2883 has been merged into this issue.

[Clementine-Issue-Importer]

_From jasvanhorn on June 11, 2012 22:25:24_

I would also love this function. Winamp's got it, and it's very useful. The problem I run into is for example, creating a jazz playlist to include the genres JAZZ, BEBOP, STANDARDS, etc, where the setting would be to include ANY of those. However, since I've started using Ubuntu (on the same machine I've got my Windows 7 OS on), I'm accessing my W7 library while in Ubuntu. I then access all my owned music and my Zune DRM subscription music. That then loads into Clementine. I'd like to have the above ANY option (aka OR) while also having the AND option to ensure none of the songs are from a DRM music folder.

[Clementine-Issue-Importer]

_From davidsansome on October 22, 2012 13:02:59_

Issue 3220 has been merged into this issue.

[Clementine-Issue-Importer]

_From mstaveley on November 09, 2012 14:36:16_

One way to do this (and is done by XBMC and Songbird) is to have a "playlist" type in the search terms. This way you can create a playlist for "jazz OR beebop OR standard" (called JAZZ) and a playlist for "Song in playlist JAZZ AND Rating > 3".

There should be both "Playlist is XXXX" and "Playlist is not XXXX" that mean the song is in playlist XXXX or the song is not in playlist XXXX.

[Clementine-Issue-Importer]

_From fuxupyo on December 15, 2012 11:44:13_

I vote for the "advanced parameters textfield" option. My use case is the same as eddw. It seems likely to me that anyone looking for these kinds of advanced features would be able to handle an intuitive query string over a weird GUI.

As a recent convert from iTunes I always found it kind of silly to be dragging and dropping search parameters around.

[ceribik]

Any update on this?

[coconutlulz]

Yes, I would like to do this.

It seems as though it would be simplest to accept raw SQL, which can then be sanitised and executed following the 'WHERE' clause of the query. A more human-readable version could be implemented, but is it worth the effort?

[stakaz]

Yeah, this is what I'm missing in Clementine for now. Would be nice, if this would be implemented in any (most simple) way.