issues
search
delphis-inc
/
delphisbe
Backend monolith for delphis
GNU General Public License v3.0
1
stars
1
forks
source link
When listDiscussions is called, we need to update sorting by lastViewed
#80
Open
nedrocks
opened
4 years ago
nedrocks
commented
4 years ago
listDiscussions query should be updated:
Grab all discussions that the user should see (as we do today)
Within this query, ensure to join with the user's viewer object
Within this query, join with the Posts table grabbing the most recent post for that discussion
group by:
Whether the lastViewedPost timestamp is less than the most recent post
sort by
Most recent post created_at descending.
listDiscussions query should be updated: