Question regarding how "Edit Tags > Mark Selected Files as Played" is handled
Posted: Sun Aug 20, 2023 2:52 pm
I increased the "Played counter" for a specific "Song" several times via "Edit tags > Mark selected files as played" by 1 each time, and the "Last played" was set accordingly. (each time recognizable in "File Properties > Details").
After that I could not read the accordingly changed data from the DB using the tags "Playdate" of "Songs" using SQL.
Apparently the so changed data in "PlayCounter" and "LastTimePlayed" are not transferred to the DB!?
The SQL code I used:
SELECT Strftime('%Y/%m/%d %H:%M:%S', ( Julianday(playdate) + 2415018.5 ), 'localtime')
AS plays
FROM played AS p
JOIN songs AS s
ON s.id = p.idsong
WHERE album = 'Kristallen'
AND songtitle = 'The Wedding';
After that I could not read the accordingly changed data from the DB using the tags "Playdate" of "Songs" using SQL.
Apparently the so changed data in "PlayCounter" and "LastTimePlayed" are not transferred to the DB!?
The SQL code I used:
SELECT Strftime('%Y/%m/%d %H:%M:%S', ( Julianday(playdate) + 2415018.5 ), 'localtime')
AS plays
FROM played AS p
JOIN songs AS s
ON s.id = p.idsong
WHERE album = 'Kristallen'
AND songtitle = 'The Wedding';