Commitf643daf

committed

fix coalesce and cleanup with array remove

1 parent77e8382 commitf643dafCopy full SHA for f643daf

File tree

-4

lines changed

-4

lines changed

Lines changed: 2 additions & 2 deletions

Some generated files are not rendered by default. Learn more aboutcustomizing how changed files appear on GitHub.

Lines changed: 2 additions & 2 deletions

Original file line number	Diff line number	Diff line change
`@@ -65,7 +65,7 @@ WITH ts AS (`
`65`	`65`	`SELECT`
`66`	`66`	`COALESCE((SELECT idsFROM template_ids),'{}')::uuid[]AS template_ids,`
`67`	`67`	`-- Return IDs so we can combine this with GetTemplateAppInsights.`
`68`		`-array_agg(DISTINCT user_id)::uuid[]AS active_user_ids,`
	`68`	`+COALESCE(array_agg(DISTINCT user_id),'{}')::uuid[]AS active_user_ids,`
`69`	`69`	`COALESCE(SUM(usage_vscode_seconds),0)::bigintAS usage_vscode_seconds,`
`70`	`70`	`COALESCE(SUM(usage_jetbrains_seconds),0)::bigintAS usage_jetbrains_seconds,`
`71`	`71`	`COALESCE(SUM(usage_reconnecting_pty_seconds),0)::bigintAS usage_reconnecting_pty_seconds,`
`@@ -194,7 +194,7 @@ WITH ts AS (`
`194`	`194`	`SELECT`
`195`	`195`	`from_AS start_time,`
`196`	`196`	`to_AS end_time,`
`197`		`-COALESCE(array_agg(DISTINCT template_id) FILTER (WHERE template_idIS NOT NULL),'{}')::uuid[]AS template_ids,`
	`197`	`+array_remove(array_agg(DISTINCT template_id),NULL)::uuid[]AS template_ids,`
`198`	`198`	`COUNT(DISTINCT user_id)AS active_users`
`199`	`199`	`FROM unflattened_usage_by_day`
`200`	`200`	`GROUP BY from_, to_;`

Comments

(0)