Downloaded podcasts episode order by recently downloaded

[Nirajn2311]

Describe the bug
The downloaded episodes of any podcast currently shows the episodes in oldest to newest order.

Expected behavior
The episodes should be ordered to show the recently downloaded episode first for each podcast.

[SharmaDhruv2511]

I want to work on this issue. Can you please assign me the issue? and adding to it can you please mark out the file where i can get the downloading of podcast code?

[himanshu608]

Isn't the current behavior more appropriate?
As the downloaded section of each podcast represents similar to as how we explore it.
Which gives user same experience in downloaded section as in exploring podcast.
When we explore the podcast, each video is listed in descending order, and when we download it, the same behavior displays in downloaded section.??

[himanshu608]

the episode model does not store downloaded date as mentioned in mode :
Episode_model

Solution 1:
Adding download date to the model and sort the results by downloaded date in getEpisodes query whenEver we are in DownloadView state,Episode List View model.

Solution 2: We can just reverse the list when we fetch the episodes from downloaded database.

[himanshu608]

As in our DB : PRIMARY KEY (id, podcastId)
We are using episode_ID and Podcast_ID for our primary key,
So reversing the list does not solve our problem, I think.
@Nirajn2311 Is there something I am missing here?

[Sembauke]

@himanshu608

We can just reverse the list when we fetch the episodes from downloaded database.

Lets go with this.

[Nirajn2311]

My bad, I hadn't thoroughly investigated this behavior in other podcast applications. We shouldn't be touching the episode order even when they've been downloaded. @himanshu608 was right about that behavior.

But the order in which podcasts are displayed can be varies. Some show them in the same order while others display podcasts in descending order of their last downloaded episode. I personally prefer not changing the order, what do the rest of you think?