"last played" not working in smart playlist

Bug #296956 reported by gershee
2
Affects Status Importance Assigned to Milestone
Exaile
Fix Released
Medium
Unassigned

Bug Description

When "last played" is used as a criterion for playlist selection no entries are selected; this is independent of the date used or whether "in the last" or "not in the last" variable is used. Also, it would be helpful if "last played" were selectable to view under column display.

Exaile was opened in terminal mode:

elg@elxg-laptop:~$ exaile
location: /usr/lib/xulrunner-1.9.0.3/libxpcom.so
before 3
Exaile 0.2.14
Plugins 'Update Notifier' version '0.3.3' loaded successfully
Plugins 'Music Sharing' version '0.8.2' loaded successfully
Plugins 'iPod Device Driver' version '0.4.6' loaded successfully
Plugins 'Sound Juicer' version '0.1.3' loaded successfully
Plugins 'Shoutcast Radio' version '0.4.8' loaded successfully
Created db for thread Thread-4
{'Thread-4': <sqlite3.Connection object at 0x177cc00>}
Activated gnome mmkeys for gnome 2.22.x
Using multimedia keys from: gnome
loading tracks...
Starting scan timer at 25.0
Closed db for thread Thread-4
done loading tracks...
loading songs
Clearing tracks cache
Importing /home/elg/.exaile/saved/playlist0000.m3u
Last playlist loaded
Loading page 0
[0.0, u'seconds']
[8.0, u'weeks']

            SELECT paths.name
                FROM tracks,paths,artists,albums
            WHERE
                (
                    paths.id=tracks.path AND
                    artists.id=tracks.artist AND
                    albums.id=tracks.album
                )
                AND (genre = "jazz" OR last_played < '2008-09-16 17:05:32')
                ORDER BY
                    LOWER(artists.name),
                    THE_CUTTER(albums.name),
                    track, title

[0.0, u'seconds']
[8.0, u'weeks']

            SELECT paths.name
                FROM tracks,paths,artists,albums
            WHERE
                (
                    paths.id=tracks.path AND
                    artists.id=tracks.artist AND
                    albums.id=tracks.album
                )
                AND (genre = "JazzEarly" AND last_played < '2008-09-16 17:06:00')
                ORDER BY
                    LOWER(artists.name),
                    THE_CUTTER(albums.name),
                    track, title

[([u'Genre', u'is'], 'jazz'), ([u'Last Played', u'not in the last'], [8.0, u'weeks'])]
[0.0, u'seconds']
[8.0, u'weeks']
[0.0, u'seconds']
[1.0, u'weeks']

            SELECT paths.name
                FROM tracks,paths,artists,albums
            WHERE
                (
                    paths.id=tracks.path AND
                    artists.id=tracks.artist AND
                    albums.id=tracks.album
                )
                AND (genre = "jazz" AND last_played < '2008-11-04 16:07:07')
                ORDER BY
                    LOWER(artists.name),
                    THE_CUTTER(albums.name),
                    track, title

[([u'Genre', u'is'], 'jazz'), ([u'Last Played', u'not in the last'], [1.0, u'weeks'])]
[0.0, u'seconds']
[1.0, u'weeks']

Revision history for this message
Steve Dodier-Lazaro (sidi) wrote :

Confirmed for the record. This isn't available yet in Exaile 0.3.0.

Changed in exaile:
status: New → Confirmed
importance: Undecided → Low
Revision history for this message
Steve Dodier-Lazaro (sidi) wrote :

This should be reimplemented ASAP in the 0.3.1 branch.

Changed in exaile:
importance: Low → Medium
milestone: none → 0.3.1
Revision history for this message
reacocard (reacocard) wrote :

too big to do before 0.3.1 now, deferring.

Changed in exaile:
milestone: 0.3.1 → 0.3.2
Revision history for this message
Mathias Brodala (mathbr) wrote :

"Last played" is working in smart playlists and available as column in the playlist.

Changed in exaile:
status: Confirmed → Fix Committed
reacocard (reacocard)
Changed in exaile:
status: Fix Committed → Fix Released
To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.