[Feature Request] sort feeds by last update time

[BasilTomato]

I would like to identify feeds which are not updated in quite a long time, eg. given feed is moved to new site or no longer maintained.

The idea is that in the Feeds view:

• show the date & time of the feed is updated, or last post is processed by Miniflux
• ability to sort the fees by "Title" or "Last updated", both ascending and descending

[shizunge]

I assume when you say "Last updated", you are referring to "latest published at" of articles of the feed

[BasilTomato]

Yes, the last time new article is retrieved from the given feed.

[shizunge]

I am still confused with what time you are taking about. There are at least 3 times for entries/feeds

1. Published at : when the article is published at a website.
2. Last Check at : when miniflux try to fetch the content. It gets updated even there is no new articles.
3. Change at : when an article marked as read.

I am more interested in 1 published time, as it helps me find inactive feeds.

But it seems you are interested in 2 (new article is retrieved ). Do I understand you correctly? Could you please tell me your use case?

On Tue, Jan 26, 2021, 09:56 BasilTomato [email protected] wrote:

Yes, the last time new article is retrieved from the given feed.

— You are receiving this because you commented. Reply to this email directly, view it on GitHub https://github.com/miniflux/v2/issues/632#issuecomment-767639586, or unsubscribe https://github.com/notifications/unsubscribe-auth/AAJY3U5MJMLL55FHVRJRVJTS33QZNANCNFSM4MCNVI7Q .

[BasilTomato]

My original idea was also the "1. Published at : when the article is published at a website." case. I would like to identify when was the latest article published in a given website. Sorry if this was not clear enough.

[shizunge]

I think this is related to https://github.com/miniflux/v2/issues/785

1. The goal is to find the inactive/active feeds.
2. This could be done by sorting
3. We would like to display the corresponding information on the feed list.

[ldexterldesign]

👋 https://github.com/miniflux/v2/issues/1434

[muuuh]

ChatGPT recommended me the following query with the schema of the database to detect abandoned feeds:

SELECT f.id AS feed_id, f.title AS feed_title, MAX(e.published_at) AS last_entry_published FROM public.feeds f JOIN public.entries e ON f.id = e.feed_id WHERE f.disabled = false GROUP BY f.id ORDER BY last_entry_published ASC;

That worked.