Query based tabs or add tracks dialog #72

New Issue

kae · 2021-09-17T18:10:07+01:00

kae commented

2021-09-17 18:10:07 +01:00

Singles played but not recently:

select tracks.title, tracks.artist, max(playdates.lastplayed) from tracks,playdates where tracks.path like '%/Singles/%' and playdates.track_id = tracks.id and playdates.lastplayed < '2021-08-01' group by tracks.title order by playdates.lastplayed Desc;

Singles never played.

Singles played but not recently: select tracks.title, tracks.artist, max(playdates.lastplayed) from tracks,playdates where tracks.path like '%/Singles/%' and playdates.track_id = tracks.id and playdates.lastplayed < '2021-08-01' group by tracks.title order by playdates.lastplayed Desc; Singles never played.

kae added the

enhancement

label 2022-01-30 08:39:58 +00:00

kae added this to the (deleted) milestone 2022-12-24 20:40:27 +00:00

kae commented

2023-10-08 22:34:18 +01:00

A better implementation would be a query based add tracks dialog

kae changed title from ~~Query based tabs~~ to Query based tabs or add tracks dialog

2023-10-08 22:34:32 +01:00

kae added the

Priority

label 2023-10-12 18:52:08 +01:00

kae commented

2023-10-15 08:51:04 +01:00

Add from query:

free text where clause
See text of where clause in tab
Check boxes to select multiple
query has name
faves for shortcut on menu

Add from query: - free text where clause - See text of where clause in tab - Check boxes to select multiple - query has name - faves for shortcut on menu

kae removed the

Priority

label 2023-11-18 22:00:49 +00:00

Sign in to join this conversation.