Antennapod: How do I mark all episodes as read up to a specific episode?

[rnoennig]

Hi, I like to listen to old episodes first in most podcasts and just switched to using AntennaPod.
How can I mark all episodes I have already listened to as read if I know which episode I listened to last?

Example:
The Podcast "WDR 5 Das philosophische Radio" has 50 episodes and the last one I listened to was ep 34.
I want to mark ep 34 and all eps before that as read. The only way I found was to manually select all 34 eps individually and mark them as read, right?

Since I have multiple such podcasts and with hundreds of episodes I used the db import export function and marked them read via SQL:

UPDATE FeedItems SET read = 1 
WHERE feed IN (SELECT id FROM Feeds WHERE title = 'WDR 5 Das philosophische Radio')
and pubdate < 1517598317000;

Maybe there is an easier solution? Preferrable via the app?

[ByteHamster]

You can use the batch edit function that is currently available with the gears icon in the ActionBar (will be changed in the next update to a checkbox). You can sort the episodes by date and de-select the ones you don't want to edit. Then you can mark them as played.

I know that this is not a one-click solution, but it's a lot faster than doing it manually. I am not sure if you have already discovered that function.

I don't think that adding your query directly to the app as a button is a good idea because it won't be used by many users and it clutters the interface.

[rnoennig]

Thanks for mentioning the batch function. I didn't know how it is called. Manually selecting hundreds of episodes with the batch function sounds fun, but I'll pass.
I posted the SQL to avoid repetitive non-stimulating tasks and posted it to clarify what I meant and as a workaround for others.
My main goal was to ask whether I overlooked a function.

The solution to include the query directly to the app sounds like a good impulse. But I'd suggest something different: Currently there is not a single long tap action on items in the gear menu selection. Would the UI be more cluttered by adding one? Or even two: 1) select everything above 2) select everything below or maybe something like selecting one episode and long tap another and choose "select all between last and current". I'm brainstorming...

You claim not many users need this function, yet Podcast addict implemented this function. On a PC I wouldn't want to live without being able to mass select elements from one position to the other. So why would that be different on a tablet or smartphone?

[davebrny]

just trying out this app the last few days but this is a bit of a deal breaker unfortunately.

im on episode 210 of re:joyce in another app and im only half way through, so even with the batch mode i will have to tap on 200 or so checkboxes. not all podcasts have this many episodes but i still have a few others where i would have to tap 50+ items to get back to where i was

i agree with rnoennig, a long press option with "select all items above/below" would do the job without cluttering up the UI

[rnoennig]

@davebrny You are not alone! You can still use the workaround I mentioned with the DB export, manipulating your feeds with SQL and then importing it back. It is a one time effort and was well worth it.

[ByteHamster]

I would be happy to merge a PR that adds a long press menu with "Select all above" / "Select all below" to the batch edit mode. Shouldn't be too complicated to implement.

[davebrny]

nice one @ByteHamster i look forward to trying that out.
let me know if you want me to beta test it or whatever

@rnoennig sounds complicated! i never used SQL or any databases before so i think it would be safer to wait :)