Skip to content

Commit 8a9eb15

Browse files
committed
update join comment
1 parent f8a2056 commit 8a9eb15

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
@@ -196,7 +196,9 @@ WITH
196196
FROM
197197
template_usage_stats AS tus, jsonb_each(app_usage_mins) AS app_usage
198198
LEFT JOIN LATERAL (
199-
-- Fetch the latest app info for each app based on slug and template.
199+
-- The joins in this query are necessary to associate an app with a
200+
-- template, we use this to get the app metadata like display name
201+
-- and icon.
200202
SELECT
201203
app.display_name,
202204
app.icon,

0 commit comments

Comments
 (0)