Skip to content

Commit 23cf1c6

Browse files
committed
update join comment
1 parent 56e1cb8 commit 23cf1c6

File tree

2 files changed

+6
-2
lines changed

2 files changed

+6
-2
lines changed

coderd/database/queries.sql.go

+3-1
Some generated files are not rendered by default. Learn more about customizing how changed files appear on GitHub.

coderd/database/queries/insights.sql

+3-1
Original file line numberDiff line numberDiff line change
@@ -282,7 +282,9 @@ SELECT
282282
FROM
283283
template_usage_stats AS tus, jsonb_each(app_usage_mins) AS app_usage
284284
LEFT JOIN LATERAL (
285-
-- Fetch the latest app info for each app based on slug and template.
285+
-- The joins in this query are necessary to associate an app with a
286+
-- template, we use this to get the app metadata like display name
287+
-- and icon.
286288
SELECT
287289
app.display_name,
288290
app.slug

0 commit comments

Comments
 (0)