Changes between Initial Version and Version 1 of UserViewsPublicReadingLists

Timestamp:

03/05/26 15:14:58 (2 weeks ago)

Author:

211099

Comment:

--

UserViewsPublicReadingLists

@@ +1 @@
+==  User Views Public Reading Lists
+
+=== Authors: **Regular User / Guest User**
+A user browses all public reading lists on the platform to discover new stories recommended by other readers.
+
+**1.** The user navigates to the "Community Reading Lists" section.
+
+**2.** The system retrieves all public reading lists along with their story counts.
+{{{#!sql
+SELECT rl.list_id, rl.name, rl.content, u.username,
+       COUNT(rli.story_id) AS total_stories, rl.created_at
+FROM READING_LIST rl
+JOIN USERS u ON rl.user_id = u.user_id
+LEFT JOIN READING_LIST_ITEMS rli ON rl.list_id = rli.list_id
+WHERE rl.is_public = TRUE
+GROUP BY rl.list_id, u.username
+ORDER BY total_stories DESC;
+}}}
+
+**3.** The user selects a reading list to view its contents.
+
+**4.** The system displays all stories in that reading list with their details.
+{{{#!sql
+SELECT s.story_id, s.short_description, s.mature_content,
+       u.username AS author, COUNT(l.user_id) AS likes,
+       rli.added_at
+FROM READING_LIST_ITEMS rli
+JOIN STORY s ON rli.story_id = s.story_id
+JOIN USERS u ON s.user_id = u.user_id
+LEFT JOIN LIKES l ON s.story_id = l.story_id
+WHERE rli.list_id = 1
+GROUP BY s.story_id, u.username, rli.added_at
+ORDER BY rli.added_at DESC;
+}}}
+
+**5.** The user clicks on a story from the list and is redirected to the story page.