Hi Daniele, sorry for the late answer, we are all a tad busy these days
On Wed, Mar 26, 2014 at 2:02 AM, <daniele.rosa.bl...@gmail.com> wrote: > Daniele Rosa sent a message using the contact form at > http://amarok.kde.org/en/contact. > > Dear Support, > I am querying the amarok db podcastepisodes tables and I don't know how to > filter those episodes that are actually still on my machine. > If I do > > where localurl <> "" and filesize <> 0 > > I still get some of the ones that were previously downloaded but are not on > my machine anymore. > > daniele@daniele-hpenvy:$ amarok -v > Qt: 4.8.4 > KDE Development Platform: 4.11.5 > Amarok: 2.8.0 If the episodes are not physically there anymore, the database shouldn't list them at all. Did you try doing a full rescan since you upgraded to Amarok 2.8.0? Hope this helps Regards, Myriam -- Proud member of the Amarok and KDE Community Protect your freedom and join the Fellowship of FSFE: http://www.fsfe.org Please don't send me proprietary file formats, use ISO standard ODF instead (ISO/IEC 26300) _______________________________________________ Amarok mailing list Amarok@kde.org https://mail.kde.org/mailman/listinfo/amarok