fix recent sort for paginated comments

huumn · huumn · commit 777a8c000321 · 2025-11-09T18:04:18.000-06:00
diff --git a/api/resolvers/item.js b/api/resolvers/item.js
@@ -41,7 +41,7 @@ function commentsOrderByClause (me, models, sort) {
   if (sort === 'recent') {
     return `ORDER BY ${sharedSorts},
       ("Item".cost > 0 OR "Item"."weightedVotes" - "Item"."weightedDownVotes" > 0) DESC,
-      COALESCE(("payIn"->>'payInStateChangedAt')::timestamp(3), "Item".created_at) DESC, "Item".id DESC`
+      "Item".created_at DESC, "Item".id DESC`
   }
 
   if (sort === 'hot') {

Original file line number	Diff line number	Diff line change
`@@ -41,7 +41,7 @@ function commentsOrderByClause (me, models, sort) {`
`41`	`41`	`if (sort === 'recent') {`
`42`	`42`	return `ORDER BY ${sharedSorts},
`43`	`43`	`("Item".cost > 0 OR "Item"."weightedVotes" - "Item"."weightedDownVotes" > 0) DESC,`
`44`		- COALESCE(("payIn"->>'payInStateChangedAt')::timestamp(3), "Item".created_at) DESC, "Item".id DESC`
	`44`	+ "Item".created_at DESC, "Item".id DESC`
`45`	`45`	`}`
`46`	`46`
`47`	`47`	`if (sort === 'hot') {`