Last user modified by pudymody · Pull Request #7886 · FreshRSS/FreshRSS

pudymody · 2025-08-31T17:49:03Z

Changes proposed in this pull request:

This is an implementation of the proposed feature. It allows entries to have a new field that will be updated whenever an item is marked as read/unerad or bookmark/removed from bookmarks. And a new sort criteria to sort by it.

I couldnt find any documentation about migrations but i think this is the way. I only tested this with sqlite, but i believe the others should work, its a copy-paste from the existing ones.

If you find this ok, i could continue with the tag implementation to also modify this date whenever a new tag is added or removed from an article. In this or another PR as preferred.

How to test the feature manually:

Mark items from a feed as read/unread
Mark items from a feed as bookmark / remove bookmark
Sort by the new criteria

Pull request checklist:

clear commit messages
code manually tested
unit tests written (optional if too hard)
documentation updated

Additional information can be found in the documentation.

Inverle · 2025-08-31T18:17:34Z

I think a migration needs to be done here

FreshRSS/app/Models/EntryDAO.php

Lines 123 to 129 in c44bb02

    
           protected function autoUpdateDb(array $errorInfo): bool { 
        
           	if (isset($errorInfo[0])) { 
        
           		if ($errorInfo[0] === FreshRSS_DatabaseDAO::ER_BAD_FIELD_ERROR || $errorInfo[0] === FreshRSS_DatabaseDAOPGSQL::UNDEFINED_COLUMN) { 
        
           			$errorLines = explode("\n", $errorInfo[2], 2);	// The relevant column name is on the first line, other lines are noise 
        
           			foreach (['attributes'] as $column) { 
        
           				if (str_contains($errorLines[0], $column)) { 
        
           					return $this->addColumn($column);

FreshRSS/app/Models/EntryDAO.php

Lines 102 to 114 in c44bb02

    
           	protected function addColumn(string $name): bool { 
        
           		if ($this->pdo->inTransaction()) { 
        
           			$this->pdo->commit(); 
        
           		} 
        
           		Minz_Log::warning(__METHOD__ . ': ' . $name); 
        
           		try { 
        
           			if ($name === 'attributes') {	//v1.20.0 
        
           				$sql = <<<'SQL' 
        
           ALTER TABLE `_entry` ADD COLUMN attributes TEXT; 
        
           ALTER TABLE `_entrytmp` ADD COLUMN attributes TEXT; 
        
           SQL; 
        
           				return $this->pdo->exec($sql) !== false; 
        
           			}

(add the new lastUserModified column alongside attributes)

Inverle · 2025-08-31T18:21:01Z

app/i18n/en/index.php

+			'user_modified_asc' => 'User modified 1→9',
+			'user_modified_desc' => 'User modified 9→1',


See https://freshrss.github.io/FreshRSS/en/internationalization.html#addremoveupdate-a-key

make i18n-add-key key=index.menu.sort.user_modified_desc value='User modified 9→1' needs to be used
or ./cli/manipulate.translation.php -a add -k index.menu.sort.user_modified_desc -v 'User modified 9→1'
Same for the other key

Inverle · 2025-08-31T18:23:36Z

app/SQL/install.sql.mysql.php

 	INDEX (`is_favorite`),	-- v0.7
 	INDEX (`is_read`),	-- v0.7
 	INDEX `entry_lastSeen_index` (`lastSeen`),	-- v1.1.1
+	INDEX `entry_last_user_modified_index` (`lastUserModified`),	-- v1.1.1


Suggested change

INDEX `entry_last_user_modified_index` (`lastUserModified`), -- v1.1.1

INDEX `entry_last_user_modified_index` (`lastUserModified`), -- v1.27.1

and in other places where v1.1.1 is used instead of 1.27.1 (or 1.28.0, not sure what the next release is so maybe put 1.27.1+)

Inverle · 2025-09-01T05:51:30Z

It's also good to run make fix-all && make test-all to make sure the CI passes

https://freshrss.github.io/FreshRSS/en/developers/03_Running_tests.html

pudymody · 2025-09-01T21:13:26Z

I think now the pipeline should pass.
I haven't added new tests as i didnt find anything about how they should be created or one to use as an example.

Alkarex · 2025-09-02T20:11:06Z

app/Models/EntryDAO.php

 		$hash = static::sqlHexEncode('e0.hash');
 		$sql = <<<SQL
-SELECT e0.id, e0.guid, e0.title, e0.author, {$content}, e0.link, e0.date, {$hash} AS hash, e0.is_read, e0.is_favorite, e0.id_feed, e0.tags, e0.attributes
+SELECT


Personal preference: I am not a fan of excessive vertical scroll

Alkarex · 2025-09-02T20:13:05Z

Looks good at a quick glance 👍🏻
I think we will release a version 1.27.1 before merging this PR and target 1.28.0 for that one

app/i18n/fr/index.php

Alkarex · 2025-09-02T20:24:51Z

app/Models/EntryDAO.php

 			$this->addEntryPrepared->bindParam(':last_seen', $valuesTmp['lastSeen'], PDO::PARAM_INT);
+
+			if (empty($valuesTmp['lastUserModified'])) {
+				$valuesTmp['lastUserModified'] = time();


I have not tested the code yet, but if I am not mistaken, I think it would be better to default to 0 here.
It is probably more desirable for new entries, not touched by the user, to have a value of 0.
Or this code could simply be removed to use the default value defined in SQL.

Alkarex · 2025-09-02T20:27:36Z

It does not like the case of adding/removing a label is covered, is it? It might be a bit more tricky to implement, though

Co-authored-by: Alexandre Alapetite <alexandre@alapetite.fr>

pudymody · 2025-09-06T18:57:49Z

It does not like the case of adding/removing a label is covered, is it? It might be a bit more tricky to implement, though

Thats right, it isnt. I can make a new PR branching from this one or in this one itself, however you prefer

Inverle · 2025-09-06T19:09:46Z

app/i18n/en/index.php

+			'user_modified_asc' => 'User modified 1→9',	// TODO
+			'user_modified_desc' => 'User modified 9→1',	// TODO


Wouldn't it be better to call this Last modified?

See discussion in #7862 (comment). Last modified could be about the article itself, so ideally it should be disambiguated. Something like User modified does that, even if it sounds a bit weird.

app/i18n/pl/index.php

app/i18n/nl/index.php

Co-authored-by: Inverle <inverle@proton.me>

Co-authored-by: Frans de Jonge <fransdejonge@gmail.com>

…hrss into pr/pudymody/7886

Copilot

Pull Request Overview

This PR implements a "Last user modified" feature that tracks when users interact with RSS entries by adding a new lastUserModified field to the database schema and corresponding functionality. The feature allows sorting entries by when they were last modified by user actions (read/unread, bookmark/unbookmark).

Key changes:

Adds lastUserModified field to the entry database schema with migration support
Updates all entry modification operations to set the timestamp when users mark items as read/unread or bookmark/unbookmark
Adds new sorting option "User modified" with ascending/descending order in the UI

Reviewed Changes

Copilot reviewed 39 out of 39 changed files in this pull request and generated 3 comments.

Show a summary per file

File	Description
app/layout/nav_menu.phtml	Adds UI menu items for new user modified sorting options
app/i18n/*/index.php	Adds translations for new sort options across multiple languages
app/SQL/install.sql.*.php	Database schema updates to add lastUserModified column and index
app/Models/Entry*.php	Core implementation of lastUserModified tracking in database operations
app/Models/Context.php	Adds lastUserModified to valid sort options
app/Controllers/indexController.php	Updates pagination logic to handle new sort option
README*.md	Updates translation completion percentages

_{Tip: Customize your code reviews with copilot-instructions.md. Create the file or learn how to get started.}

app/Models/EntryDAOPGSQL.php

app/i18n/en/index.php

app/Models/EntryDAO.php

Alkarex · 2025-10-10T22:44:30Z

Merged 🚀 Thanks again.
@pudymody Please add a line for you in https://github.com/FreshRSS/FreshRSS/blob/edge/CREDITS.md

Alkarex · 2025-10-10T23:02:45Z

app/i18n/fi/index.php

+			'user_modified_asc' => 'User modified 1→9',	// TODO
+			'user_modified_desc' => 'User modified 9→1',	// TODO


Ping @minna-xD a couple of new strings if you can (in a new PR)

Follow-up of FreshRSS#7886 (Probably wrong merge conflict resolution)

Follow-up of #7886 (Probably wrong merge conflict resolution)

fix FreshRSS#8087 (comment) Regression from FreshRSS#7886

Alkarex · 2025-10-13T00:12:36Z

app/Models/EntryDAO.php

 				. 'SET title=:title, author=:author, '
 				. (static::isCompressed() ? 'content_bin=COMPRESS(:content)' : 'content=:content')
 				. ', link=:link, date=:date, `lastSeen`=:last_seen'
+				. ', `lastUserModified`=MAX(:last_user_modified, `lastUserModified`)'


Wrong max() function. Fixed in #8105

fix #8087 (comment) Regression from #7886

fix FreshRSS#8105 Related to FreshRSS#7886

* Fix SQLite GREATEST() fix #8105 Related to #7886

fix FreshRSS#8129 Regression from FreshRSS#7886

Alkarex · 2025-10-17T07:32:01Z

app/Models/EntryDAO.php

 		$repeats = str_repeat('?,', count($ids) - 1) . '?';
 		$sql = <<<SQL
-SELECT id, guid, title, author, link, date, {$hash} AS hash, is_read, is_favorite, id_feed, tags, attributes, {$content}
+SELECT id, guid, title, author, link, date, {$hash} AS hash, is_read, is_favorite, id_feed, tags, attributes, {$content}, lastUserModified


Quotes missing. Fixed in #8130

fix #8129 Regression from #7886

pudymody · 2025-10-28T18:19:21Z

Sorry about the delay, it was exam's month.
Will add to the credits and test it in production in the following weeks

This PR contains the following updates: | Package | Update | Change | |---|---|---| | [freshrss/freshrss](https://freshrss.org/) ([source](https://github.com/FreshRSS/FreshRSS)) | minor | `1.27.1` -> `1.28.0` | --- ### Release Notes <details> <summary>FreshRSS/FreshRSS (freshrss/freshrss)</summary> ### [`v1.28.0`](https://github.com/FreshRSS/FreshRSS/blob/HEAD/CHANGELOG.md#2025-12-24-FreshRSS-1280) [Compare Source](FreshRSS/FreshRSS@1.27.1...1.28.0) - Features - New sorting and filtering by date of *User modified* [#7886](FreshRSS/FreshRSS#7886), [#8090](FreshRSS/FreshRSS#8090), [#8105](FreshRSS/FreshRSS#8105), [#8118](FreshRSS/FreshRSS#8118), [#8130](FreshRSS/FreshRSS#8130) - Corresponding search operator, e.g. `userdate:PT1H` for the past hour [#8093](FreshRSS/FreshRSS#8093) - Allows finding articles marked by the local user as read/unread or starred/unstarred at specific dates for e.g. undo action. - New sorting by article length [#8119](FreshRSS/FreshRSS#8119) - New advanced search form [#8103](FreshRSS/FreshRSS#8103), [#8122](FreshRSS/FreshRSS#8122), [#8226](FreshRSS/FreshRSS#8226) - Add compatibility with PCRE word boundary `\b` and `\B` for regex search using PostgreSQL [#8141](FreshRSS/FreshRSS#8141) - More uniform SQL search and PHP search for accents and case-sensitivity (e.g. for automatically marking as read) [#8329](FreshRSS/FreshRSS#8329) - New overview of dates with most unread articles [#8089](FreshRSS/FreshRSS#8089) - Allow marking as read articles older than 1 or 7 days also when sorting by publication date [#8163](FreshRSS/FreshRSS#8163) - New option to show user labels instead of tags in RSS share [#8112](FreshRSS/FreshRSS#8112) - Add new feed visibility (priority) *Show in its feed* [#7972](FreshRSS/FreshRSS#7972) - New ability to share feed visibility through API (implemented by e.g. Capy Reader) [#7583](FreshRSS/FreshRSS#7583), [#8158](FreshRSS/FreshRSS#8158) - Configurable notification timeout [#7942](FreshRSS/FreshRSS#7942) - OPML export/import of unicity criteria [#8243](FreshRSS/FreshRSS#8243) - Ensure stable IDs (categories, feeds, labels) during export/import [#7988](FreshRSS/FreshRSS#7988) - Add username and timestamp to SQLite export from Web UI [#8169](FreshRSS/FreshRSS#8169) - Add option to apply filter actions to existing articles [#7959](FreshRSS/FreshRSS#7959), [#8259](FreshRSS/FreshRSS#8259) - Support CSS selector `~` *subsequent-sibling* [#8154](FreshRSS/FreshRSS#8154) - Upstream PR [phpgt/CssXPath#231](phpgt/CssXPath#231) - Rework saving of configuration files for more reliability in case of e.g. full disk [#8220](FreshRSS/FreshRSS#8220) - Web scraping support date format as milliseconds for Unix epoch [#8266](FreshRSS/FreshRSS#8266) - Allow negative category sort numbers [#8330](FreshRSS/FreshRSS#8330) - Performance - Improve SQL speed for updating cached information [#6957](FreshRSS/FreshRSS#6957), [#8207](FreshRSS/FreshRSS#8207), [#8255](FreshRSS/FreshRSS#8255), [#8254](FreshRSS/FreshRSS#8254), [#8255](FreshRSS/FreshRSS#8255) - Fix SQL performance issue with MySQL, using an index hint [#8211](FreshRSS/FreshRSS#8211) - Scaling of user statistics in Web UI and CLI, to help instances with 1k+ users [#8277](FreshRSS/FreshRSS#8277) - API streaming of large responses for reducing memory consumption and increasing speed [#8041](FreshRSS/FreshRSS#8041) - Security - 💥 Move unsafe autologin to an extension [#7958](FreshRSS/FreshRSS#7958) - Fix some CSRFs [#8035](FreshRSS/FreshRSS#8035) - Strengthen some crypto (login, tokens, nonces) [#8061](FreshRSS/FreshRSS#8061), [#8320](FreshRSS/FreshRSS#8320) - Create separate HTTP `Retry-After` rules for proxies [#8029](FreshRSS/FreshRSS#8029), [#8218](FreshRSS/FreshRSS#8218) - Add `data:` to CSP in subscription controller [#8253](FreshRSS/FreshRSS#8253) - Improve anonymous authentication logic [#8165](FreshRSS/FreshRSS#8165) - Enable GitHub [release immutability](https://github.blog/changelog/2025-10-28-immutable-releases-are-now-generally-available/) [#8205](FreshRSS/FreshRSS#8205) - Bug fixing - Exclude local networks for domain-wide HTTP `Retry-After` [#8195](FreshRSS/FreshRSS#8195) - Fix OpenID Connect with Debian 13 [#8032](FreshRSS/FreshRSS#8032) - Fix MySQL / MariaDB bug wrongly sorting new articles [#8223](FreshRSS/FreshRSS#8223) - Fix MySQL / MariaDB database size calculation [#8282](FreshRSS/FreshRSS#8282) - Fix SQLite bind bug when adding user label [#8101](FreshRSS/FreshRSS#8101) - Fix SQL auto-update of field `f.kind` to ease migrations from FreshRSS versions older than 1.20.0 [#8148](FreshRSS/FreshRSS#8148) - Fix search encoding and quoting [#8311](FreshRSS/FreshRSS#8311), [#8324](FreshRSS/FreshRSS#8324), [#8338](FreshRSS/FreshRSS#8338) - Fix handling of database unexpected null content (during migrations) [#8319](FreshRSS/FreshRSS#8319), [#8321](FreshRSS/FreshRSS#8321) - Fix drag & drop of user query losing information [#8113](FreshRSS/FreshRSS#8113) - Fix DOM error while filtering retrieved full content [#8132](FreshRSS/FreshRSS#8132), [#8161](FreshRSS/FreshRSS#8161) - Fix `config.custom.php` during install [#8033](FreshRSS/FreshRSS#8033) - Fix do not mark important feeds as read from category [#8067](FreshRSS/FreshRSS#8067) - Fix regression of warnings in Web browser console due to lack of `window.bcrypt` object [#8166](FreshRSS/FreshRSS#8166) - Fix chart resize regression due to `chart.js` v4 update [#8298](FreshRSS/FreshRSS#8298) - Fix CLI user creation warning when language is not given [#8283](FreshRSS/FreshRSS#8283) - Fix merging of custom HTTP headers [#8251](FreshRSS/FreshRSS#8251) - Fix bug in the case of duplicated mark-as-read filters [#8322](FreshRSS/FreshRSS#8322) - SimplePie - Fix support of HTTP trailer headers [#7983](FreshRSS/FreshRSS#7983), [simplepie#943](simplepie/simplepie#943) - Apply HTTPS policy also on GUIDs and permalinks [#8037](FreshRSS/FreshRSS#8037), [simplepie#951](simplepie/simplepie#951) - Fix `WordPress.com` HTTP duplicates with WebSub [Automattic/pushpress#16](Automattic/pushpress#16) - Implement HTML whitelist for SimplePie sanitizer [#7924](FreshRSS/FreshRSS#7924), [simplepie#947](simplepie/simplepie#947) - Various upstream contributions [simplepie#940](simplepie/simplepie#940), [simplepie#944](simplepie/simplepie#944) - Deployment - Docker default image updated to Debian 13 Trixie with PHP 8.4.11 and Apache 2.4.65 [#8032](FreshRSS/FreshRSS#8032) - Docker alternative image updated to Alpine 3.23 with PHP 8.4.15 and Apache 2.4.65 [#8285](FreshRSS/FreshRSS#8285) - Fix Docker healthcheck `cli/health.php` compatibility with OpenID Connect [#8040](FreshRSS/FreshRSS#8040) - Improve Docker for compatibility with other base images such as Arch Linux [#8299](FreshRSS/FreshRSS#8299) - Improve `cli/access-permissions.sh` to detect the correct permission Web group such as `www-data`, `apache`, or `http` - Update PostgreSQL volume for Docker [#8216](FreshRSS/FreshRSS#8216), [#8224](FreshRSS/FreshRSS#8224) - Catch lack of `exec()` function for git update [#8228](FreshRSS/FreshRSS#8228) - Work around `DOMDocument::saveHTML()` scrambling charset encoding in some versions of libxml2 [#8296](FreshRSS/FreshRSS#8296) - Improve configuration checks for PHP extensions (in Web UI and CLI), including recommending e.g. `php-intl` [#8334](FreshRSS/FreshRSS#8334) - UI - New button for toggling sidebar on desktop view [#8201](FreshRSS/FreshRSS#8201), [#8286](FreshRSS/FreshRSS#8286) - Better transitions between groups of articles [#8174](FreshRSS/FreshRSS#8174) - New links in transitions and jump ⏭ to next transition [#8294](FreshRSS/FreshRSS#8294) - More visible selected article [#8230](FreshRSS/FreshRSS#8230) - Show the parsed search query instead of the original user input [#8293](FreshRSS/FreshRSS#8293), [#8306](FreshRSS/FreshRSS#8306), [#8341](FreshRSS/FreshRSS#8341) - Show search query in the page title [#8217](FreshRSS/FreshRSS#8217) - Scroll into filtered feed/category on page load in the sidebar [#8281](FreshRSS/FreshRSS#8281), [#8307](FreshRSS/FreshRSS#8307) - Fix autocomplete issues in change password form [#7812](FreshRSS/FreshRSS#7812) - Fix navigating between read feeds using shortcut <kbd>shift</kbd>+<kbd>j</kbd>/<kbd>k</kbd> [#8057](FreshRSS/FreshRSS#8057) - Dark background in Web app manifest to avoid white flash when opening [#8140](FreshRSS/FreshRSS#8140) - Increase button visibility in UI to change theme [#8149](FreshRSS/FreshRSS#8149) - Replace arrow navigation in theme switcher with `<select>` [#8190](FreshRSS/FreshRSS#8190) - Improve scroll of article after load of user labels [#7962](FreshRSS/FreshRSS#7962) - Keep scroll state of page when closing the slider [#8295](FreshRSS/FreshRSS#8295), [#8301](FreshRSS/FreshRSS#8301) - Scroll into filtered feed/category on page load [#8281](FreshRSS/FreshRSS#8281) - Display sidebar dropdowns above if no space below [#8335](FreshRSS/FreshRSS#8335), [#8336](FreshRSS/FreshRSS#8336) - Use native CSS instead of SCSS [#8200](FreshRSS/FreshRSS#8200), [#8241](FreshRSS/FreshRSS#8241) - Using [CSS nesting](https://developer.mozilla.org/en-US/docs/Web/CSS/Guides/Nesting) and [relative colours](https://developer.mozilla.org/en-US/docs/Web/CSS/Guides/Colors/Using_relative_colors). - Various UI and style improvements: [#8171](FreshRSS/FreshRSS#8171), [#8185](FreshRSS/FreshRSS#8185), [#8196](FreshRSS/FreshRSS#8196) - JavaScript finalise migration from `Promise` to `async`/`await`: [#8182](FreshRSS/FreshRSS#8182) - API - API performance optimisation: streaming of large responses [#8041](FreshRSS/FreshRSS#8041) - Fever API: Add `with_ids` parameter to mass-change read/unread/saved/unsaved on lists of articles [#8312](FreshRSS/FreshRSS#8312) - Misc API: better REST error semantics [#8232](FreshRSS/FreshRSS#8232) - Extensions - Add support for extension priority [#8038](FreshRSS/FreshRSS#8038) - Add support for extension compatibility [#8081](FreshRSS/FreshRSS#8081) - Improve PHP code with hook enums [#8036](FreshRSS/FreshRSS#8036) - New hook `nav_entries` [#8054](FreshRSS/FreshRSS#8054) - Rename [Extensions](https://github.com/FreshRSS/Extensions) default branch from *master* to *main* [#8194](FreshRSS/FreshRSS#8194) - I18n - Translation status as text in README [#7842](FreshRSS/FreshRSS#7842) - Add new translate CLI commands `move` [#8214](FreshRSS/FreshRSS#8214) - Change some regional language codes to comply with RFC 5646 / IETF BCP 47 / ISO 3166 / ISO 639-1 [#8065](FreshRSS/FreshRSS#8065) - Improve German [#8028](FreshRSS/FreshRSS#8028) - Improve Greek [#8146](FreshRSS/FreshRSS#8146) - Improve Finnish [#8073](FreshRSS/FreshRSS#8073), [#8092](FreshRSS/FreshRSS#8092) - Improve Hungarian [#8244](FreshRSS/FreshRSS#8244) - Improve Italian [#8115](FreshRSS/FreshRSS#8115), [#8186](FreshRSS/FreshRSS#8186) - Improve Polish [#8134](FreshRSS/FreshRSS#8134), [#8135](FreshRSS/FreshRSS#8135) - Improve Russian [#8155](FreshRSS/FreshRSS#8155), [#8197](FreshRSS/FreshRSS#8197) - Improve Simplified Chinese [#8308](FreshRSS/FreshRSS#8308), [#8313](FreshRSS/FreshRSS#8313) - Misc. - Add code to modify a search expression [#8293](FreshRSS/FreshRSS#8293) - Remove *Pocket* sharing service [#8127](FreshRSS/FreshRSS#8127), [#8128](FreshRSS/FreshRSS#8128) - Update to PHPMailer 7.0.1 [#8048](FreshRSS/FreshRSS#8048), [#8180](FreshRSS/FreshRSS#8180), [#8272](FreshRSS/FreshRSS#8272) - 💥 Housekeeping of `lib_rss.php` with potential breaking changes for some extensions [#8193](FreshRSS/FreshRSS#8193), - Use native PHP `#[Deprecated]` [#8325](FreshRSS/FreshRSS#8325) - Improve PHP code [#8156](FreshRSS/FreshRSS#8156), [#8203](FreshRSS/FreshRSS#8203), [#8284](FreshRSS/FreshRSS#8284), [#8292](FreshRSS/FreshRSS#8292), [#8297](FreshRSS/FreshRSS#8297) - GitHub Actions: `--no-progress` [#8315](FreshRSS/FreshRSS#8315) - Update dev dependencies [#8043](FreshRSS/FreshRSS#8043), [#8044](FreshRSS/FreshRSS#8044), [#8045](FreshRSS/FreshRSS#8045), [#8046](FreshRSS/FreshRSS#8046), [#8047](FreshRSS/FreshRSS#8047), [#8052](FreshRSS/FreshRSS#8052), [#8176](FreshRSS/FreshRSS#8176), [#8177](FreshRSS/FreshRSS#8177), [#8178](FreshRSS/FreshRSS#8178), [#8179](FreshRSS/FreshRSS#8179), [#8210](FreshRSS/FreshRSS#8210), [#8270](FreshRSS/FreshRSS#8270), [#8271](FreshRSS/FreshRSS#8271), [#8273](FreshRSS/FreshRSS#8273), [#8274](FreshRSS/FreshRSS#8274), [#8275](FreshRSS/FreshRSS#8275), [#8276](FreshRSS/FreshRSS#8276) </details> --- ### Configuration 📅 **Schedule**: Branch creation - At any time (no schedule defined), Automerge - At any time (no schedule defined). 🚦 **Automerge**: Disabled by config. Please merge this manually once you are satisfied. ♻ **Rebasing**: Whenever PR is behind base branch, or you tick the rebase/retry checkbox. 🔕 **Ignore**: Close this PR and you won't be reminded about this update again. --- - [ ] If you want to rebase/retry this PR, check this box --- This PR has been generated by [Renovate Bot](https://github.com/renovatebot/renovate).  Reviewed-on: https://gitea.alexlebens.dev/alexlebens/infrastructure/pulls/2851 Co-authored-by: Renovate Bot <renovate-bot@alexlebens.net> Co-committed-by: Renovate Bot <renovate-bot@alexlebens.net>

feat: Add user modified functionality

d70609e

pudymody force-pushed the last-user-modified branch from 05bbaa9 to 6d71b48 Compare August 31, 2025 18:13

pudymody added 2 commits August 31, 2025 15:13

feat: Add sort functionality

00b6204

feat: Add sort nav button

4be9881

pudymody force-pushed the last-user-modified branch from 6d71b48 to 4be9881 Compare August 31, 2025 18:14

Inverle reviewed Aug 31, 2025

View reviewed changes

pudymody added 2 commits August 31, 2025 16:08

fix: Use correct migrations

29f39a4

fix: Add internationalization

548edf3

fix: Linter errors

bf83263

Alkarex reviewed Sep 2, 2025

View reviewed changes

Alkarex added this to the 1.28.0 milestone Sep 2, 2025

Alkarex reviewed Sep 2, 2025

View reviewed changes

app/i18n/fr/index.php Outdated Show resolved Hide resolved

Alkarex reviewed Sep 2, 2025

View reviewed changes

pudymody and others added 2 commits September 6, 2025 15:55

chore: PR comments

6bcfdfb

Update app/i18n/fr/index.php

012790c

Co-authored-by: Alexandre Alapetite <alexandre@alapetite.fr>

Inverle reviewed Sep 6, 2025

View reviewed changes

app/i18n/pl/index.php Outdated Show resolved Hide resolved

Frenzie reviewed Sep 6, 2025

View reviewed changes

app/i18n/nl/index.php Outdated Show resolved Hide resolved

pudymody and others added 5 commits September 6, 2025 19:55

Update app/i18n/pl/index.php

a919f12

Co-authored-by: Inverle <inverle@proton.me>

Update app/i18n/nl/index.php

abc7556

Co-authored-by: Frans de Jonge <fransdejonge@gmail.com>

Merge branch 'edge' into pr/pudymody/7886

add728e

Fix wrong merge

7709996

Merge branch 'last-user-modified' of https://github.com/pudymody/fres…

bc8191f

…hrss into pr/pudymody/7886

Alkarex added 2 commits October 4, 2025 11:31

Fix unneeded column

fe33a41

Fix auto-create indexes

19848c9

Alkarex requested a review from Copilot October 4, 2025 10:22

Copilot AI reviewed Oct 4, 2025

View reviewed changes

app/Models/EntryDAOPGSQL.php Outdated Show resolved Hide resolved

app/i18n/en/index.php Outdated Show resolved Hide resolved

app/Models/EntryDAO.php Show resolved Hide resolved

Alkarex added 2 commits October 4, 2025 12:27

Some copilot suggestions

53f5156

Merge branch 'edge' into last-user-modified

e5dd3b1

Alkarex linked an issue Oct 10, 2025 that may be closed by this pull request

[Feature] Store a date and time in the DB to record when an entry was marked as read. #4280

Closed

Alkarex added 2 commits October 11, 2025 00:11

Merge branch 'edge' into pr/pudymody/7886

940ddc9

One more fix

8ca06dd

Alkarex merged commit 673067a into FreshRSS:edge Oct 10, 2025
1 check passed

Alkarex reviewed Oct 10, 2025

View reviewed changes

Alkarex added a commit to Alkarex/FreshRSS that referenced this pull request Oct 11, 2025

Fix MySQL autoupdate Last user modified

7af9e20

Follow-up of FreshRSS#7886 (Probably wrong merge conflict resolution)

Alkarex mentioned this pull request Oct 11, 2025

Fix MySQL autoupdate Last user modified #8090

Merged

Alkarex added a commit that referenced this pull request Oct 11, 2025

Fix MySQL autoupdate Last user modified (#8090)

0551544

Follow-up of #7886 (Probably wrong merge conflict resolution)

minna-xD mentioned this pull request Oct 11, 2025

Translate new user_modified strings #8092

Merged

Alkarex added a commit to Alkarex/FreshRSS that referenced this pull request Oct 13, 2025

Fix SQL updateEntry

0bfe3a7

fix FreshRSS#8087 (comment) Regression from FreshRSS#7886

Alkarex mentioned this pull request Oct 13, 2025

Fix SQL updateEntry #8105

Merged

Alkarex reviewed Oct 13, 2025

View reviewed changes

Alkarex added a commit that referenced this pull request Oct 13, 2025

Fix SQL updateEntry (#8105)

201c113

fix #8087 (comment) Regression from #7886

Alkarex added a commit to Alkarex/FreshRSS that referenced this pull request Oct 14, 2025

Fix SQLite GREATEST()

8b71ed7

fix FreshRSS#8105 Related to FreshRSS#7886

Alkarex mentioned this pull request Oct 14, 2025

Fix SQLite GREATEST() #8118

Merged

Alkarex added a commit that referenced this pull request Oct 14, 2025

Fix SQLite GREATEST() (#8118)

1b8bc1a

* Fix SQLite GREATEST() fix #8105 Related to #7886

Alkarex added a commit to Alkarex/FreshRSS that referenced this pull request Oct 17, 2025

Fix API list by IDs

b03e2ff

fix FreshRSS#8129 Regression from FreshRSS#7886

Alkarex mentioned this pull request Oct 17, 2025

Fix API list by IDs #8130

Merged

Alkarex reviewed Oct 17, 2025

View reviewed changes

Alkarex added a commit that referenced this pull request Oct 17, 2025

Fix API list by IDs (#8130)

fbbb5a5

fix #8129 Regression from #7886

Alkarex mentioned this pull request Nov 22, 2025

Implement filter on last modified date by server #8131

Merged

		'user_modified_asc' => 'User modified 1→9',
		'user_modified_desc' => 'User modified 9→1',

	INDEX `entry_last_user_modified_index` (`lastUserModified`), -- v1.1.1
	INDEX `entry_last_user_modified_index` (`lastUserModified`), -- v1.27.1

Uh oh!

Conversation

pudymody commented Aug 31, 2025 • edited Loading Uh oh! There was an error while loading. Please reload this page.

Uh oh!

Uh oh!

Inverle commented Aug 31, 2025 • edited Loading Uh oh! There was an error while loading. Please reload this page.

Uh oh!

Uh oh!

Choose a reason for hiding this comment

Uh oh!

Inverle Aug 31, 2025 • edited Loading Uh oh! There was an error while loading. Please reload this page.

Uh oh!

Choose a reason for hiding this comment

Uh oh!

Inverle commented Sep 1, 2025

Uh oh!

pudymody commented Sep 1, 2025 • edited Loading Uh oh! There was an error while loading. Please reload this page.

Uh oh!

Uh oh!

Choose a reason for hiding this comment

Uh oh!

Alkarex commented Sep 2, 2025

Uh oh!

Uh oh!

Choose a reason for hiding this comment

Uh oh!

Alkarex commented Sep 2, 2025

Uh oh!

pudymody commented Sep 6, 2025 • edited Loading Uh oh! There was an error while loading. Please reload this page.

Uh oh!

Uh oh!

Choose a reason for hiding this comment

Uh oh!

Choose a reason for hiding this comment

Uh oh!

Choose a reason for hiding this comment

Uh oh!

Uh oh!

Uh oh!

Copilot AI left a comment

Choose a reason for hiding this comment

Pull Request Overview

Reviewed Changes

Uh oh!

Uh oh!

Uh oh!

Uh oh!

Uh oh!

Alkarex commented Oct 10, 2025

Uh oh!

Choose a reason for hiding this comment

Uh oh!

Choose a reason for hiding this comment

Uh oh!

Choose a reason for hiding this comment

Uh oh!

pudymody commented Oct 28, 2025

Uh oh!

Reviewers

Assignees

Labels

Projects

Milestone

Development

Uh oh!

5 participants

pudymody commented Aug 31, 2025 •

edited

Loading

Inverle commented Aug 31, 2025 •

edited

Loading

Inverle Aug 31, 2025 •

edited

Loading

pudymody commented Sep 1, 2025 •

edited

Loading

pudymody commented Sep 6, 2025 •

edited

Loading