Changes between Version 6 and Version 7 of Complex DB Reports

Timestamp:

02/07/26 17:05:36 (21 hours ago)

Author:

231035

Comment:

--

Complex DB Reports

@@ -106 +106 @@
 
 ORDER BY activity_rank;
+LIMIT 10;
 }}}
 === Relation Algebra
@@ -205 +206 @@
 (ScoredUsers)
 Result <-
-τ activity_rank ASC
-(
-  π
-    user_id,
-    username,
-    email,
-    name,
-    surname,
-    listings_created,
-    reviews_left,
-    avg_rating_left,
-    appointments_total,
-    appointments_done,
-    appointments_no_show,
-    appointments_cancelled,
-    favorites_saved_all_time,
-    activity_score,
-    activity_rank
-  (RankedUsers)
-)
+topK_{K := 10}
+(
+  τ activity_rank ASC
+  (
+    π
+      user_id,
+      username,
+      email,
+      name,
+      surname,
+      listings_created,
+      reviews_left,
+      avg_rating_left,
+      appointments_total,
+      appointments_done,
+      appointments_no_show,
+      appointments_cancelled,
+      favorites_saved_all_time,
+      activity_score,
+      activity_rank
+    (RankedUsers)
+  )
+)
+
 
 }}}