Commitfcaaff8

committed

simplify query

1 parent23f382c commitfcaaff8Copy full SHA for fcaaff8

File tree

+10

-17

lines changed

+10

-17

lines changed

Lines changed: 9 additions & 12 deletions

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

Lines changed: 1 addition & 2 deletions

Original file line number	Diff line number	Diff line change
`@@ -251,8 +251,7 @@ WITH`
`251`	`251`
`252`	`252`	`SELECT`
`253`	`253`	`t.template_ids,`
`254`		`-array_agg(DISTINCTai.user_id)::uuid[]AS active_user_ids,`
`255`		`-''::textAS access_method,-- TODO(mafredri): Remove.`
	`254`	`+COUNT(DISTINCTai.user_id)AS active_users,`
`256`	`255`	`ai.app_nameAS slug_or_port,`
`257`	`256`	`ai.display_name,`
`258`	`257`	`ai.icon,`

Lines changed: 0 additions & 3 deletions

Original file line number	Diff line number	Diff line change
`@@ -468,9 +468,6 @@ func convertTemplateInsightsApps(usage database.GetTemplateInsightsRow, appUsage`
`468`	`468`	`//`
`469`	`469`	`// ORDER BY access_method, slug_or_port, display_name, icon, is_app`
`470`	`470`	`slices.SortFunc(appUsage,func(a,b database.GetTemplateAppInsightsRow)int {`
`471`		`-ifa.AccessMethod!=b.AccessMethod {`
`472`		`-returnstrings.Compare(a.AccessMethod,b.AccessMethod)`
`473`		`-}`
`474`	`471`	`ifa.SlugOrPort!=b.SlugOrPort {`
`475`	`472`	`returnstrings.Compare(a.SlugOrPort,b.SlugOrPort)`
`476`	`473`	`}`

Comments

(0)