ui: group uid tracks with the same uid

Bug: 338567280
Change-Id: I4c4e117fd619f0b4e5734b64073586590054fccd

1 files changed, 10 insertions, 2 deletions

diff --git a/ui/src/controller/track_decider.ts b/ui/src/controller/track_decider.ts
index b6dd3881e..e7e66f9f2 100644
--- a/ui/src/controller/track_decider.ts
+++ b/ui/src/controller/track_decider.ts
@@ -792,12 +792,20 @@ class TrackDecider {
 
   async addUserAsyncSliceTracks(engine: EngineProxy): Promise<void> {
     const result = await engine.query(`
+      with grouped_packages as materialized (
+        select
+          uid,
+          group_concat(package_name, ',') as package_name,
+          count() as cnt
+        from package_list
+        group by uid
+      )
       select
         t.name as name,
         t.uid as uid,
-        package_list.package_name as packageName
+        iif(g.cnt = 1, g.package_name, 'UID ' || g.uid) as packageName
       from _uid_track_track_summary_by_uid_and_name t
-      join package_list using (uid)
+      join grouped_packages g using (uid)
     `);
 
     const it = result.iter({