Aug 5, 2025 · Aug 5, 2025 · Aug 5, 2025
diff --git a/coderd/database/dbauthz/dbauthz.go b/coderd/database/dbauthz/dbauthz.go
 return q.db.GetWorkspacesEligibleForTransition(ctx, now)
 }

 func (q *querier) HasTemplateVersionsWithAITask(ctx context.Context) (bool, error) {
 // Anyone can call HasTemplateVersionsWithAITask.
 return q.db.HasTemplateVersionsWithAITask(ctx)
 }

 func (q *querier) InsertAPIKey(ctx context.Context, arg database.InsertAPIKeyParams) (database.APIKey, error) {
 return insert(q.log, q.auth,
 rbac.ResourceApiKey.WithOwner(arg.UserID.String()),
diff --git a/coderd/database/dbauthz/dbauthz_test.go b/coderd/database/dbauthz/dbauthz_test.go
 })
 check.Args(j.ID).Asserts(v.RBACObject(tpl), policy.ActionRead).Returns(j)
 }))
 s.Run("HasTemplateVersionsWithAITask", s.Subtest(func(db database.Store, check *expects) {
 check.Args().Asserts()
 }))
 }

 func (s *MethodTestSuite) TestNotifications() {
diff --git a/coderd/database/dbmetrics/querymetrics.go b/coderd/database/dbmetrics/querymetrics.go
diff --git a/coderd/database/dbmock/dbmock.go b/coderd/database/dbmock/dbmock.go
diff --git a/coderd/database/querier.go b/coderd/database/querier.go
diff --git a/coderd/database/queries.sql.go b/coderd/database/queries.sql.go
diff --git a/coderd/database/queries/templateversions.sql b/coderd/database/queries/templateversions.sql
 WHERE
 template_versions.id IN (archived_versions.id)
 RETURNING template_versions.id;

 -- name: HasTemplateVersionsWithAITask :one
 -- Determines if the template versions table has any rows with has_ai_task = TRUE.
 SELECT EXISTS (SELECT 1 FROM template_versions WHERE has_ai_task = TRUE);
diff --git a/site/site.go b/site/site.go
 var user database.User
 var themePreference string
 var terminalFont string
 var tasksTabVisible bool
 orgIDs := []uuid.UUID{}
 eg.Go(func() error {
 var err error
 orgIDs = memberIDs[0].OrganizationIDs
 return err
 })
 eg.Go(func() error {
 // If HideAITasks is true, force hide the tasks tab
 if h.opts.HideAITasks {
 tasksTabVisible = false
 return nil
 }

 hasAITask, err := h.opts.Database.HasTemplateVersionsWithAITask(ctx)
 if err != nil {
 return err
 }
 tasksTabVisible = hasAITask
 return nil
 })
 err := eg.Wait()
 if err == nil {
 var wg sync.WaitGroup
 wg.Add(1)
 go func() {
 defer wg.Done()
 tasksTabVisible, err := json.Marshal(tasksTabVisible)
 tasksTabVisible, err := json.Marshal(!h.opts.HideAITasks)
 if err == nil {
 state.TasksTabVisible = html.EscapeString(string(tasksTabVisible))
 }
diff --git a/site/src/pages/TasksPage/TasksPage.tsx b/site/src/pages/TasksPage/TasksPage.tsx
 import { AvatarDataSkeleton } from "components/Avatar/AvatarDataSkeleton";
 import { Button } from "components/Button/Button";
 import { displayError } from "components/GlobalSnackbar/utils";
 import { Link } from "components/Link/Link";
 import { Margins } from "components/Margins/Margins";
 import {
 PageHeader,
 import { useMutation, useQuery, useQueryClient } from "react-query";
 import { Link as RouterLink, useNavigate } from "react-router-dom";
 import TextareaAutosize from "react-textarea-autosize";
 import { docs } from "utils/docs";
 import { pageTitle } from "utils/page";
 import { relativeTime } from "utils/time";
 import { type UserOption, UsersCombobox } from "./UsersCombobox";
 No Task templates found
 </h3>
 <span className="text-content-secondary text-sm">
 Create a Task template to get started
 <Link href={docs("/ai-coder/tasks")} target="_blank" rel="noreferrer">
 Learn about Tasks
 </Link>{" "}
 to get started.
 </span>
 </div>
 </div>
Original file line number	Diff line number	Diff line change
Expand Up		@@ -3617,11 +3617,6 @@ func (q *querier) GetWorkspacesEligibleForTransition(ctx context.Context, now ti
		return q.db.GetWorkspacesEligibleForTransition(ctx, now)
		}

		func (q *querier) HasTemplateVersionsWithAITask(ctx context.Context) (bool, error) {
		// Anyone can call HasTemplateVersionsWithAITask.
		return q.db.HasTemplateVersionsWithAITask(ctx)
		}

		func (q *querier) InsertAPIKey(ctx context.Context, arg database.InsertAPIKeyParams) (database.APIKey, error) {
		return insert(q.log, q.auth,
		rbac.ResourceApiKey.WithOwner(arg.UserID.String()),
Expand Down
Original file line number	Diff line number	Diff line change
Expand Up		@@ -4826,9 +4826,6 @@ func (s *MethodTestSuite) TestSystemFunctions() {
		})
		check.Args(j.ID).Asserts(v.RBACObject(tpl), policy.ActionRead).Returns(j)
		}))
		s.Run("HasTemplateVersionsWithAITask", s.Subtest(func(db database.Store, check *expects) {
		check.Args().Asserts()
		}))
		}

		func (s *MethodTestSuite) TestNotifications() {
Expand Down
Original file line number	Diff line number	Diff line change
Expand Up		@@ -234,7 +234,3 @@ FROM
		WHERE
		template_versions.id IN (archived_versions.id)
		RETURNING template_versions.id;

		-- name: HasTemplateVersionsWithAITask :one
		-- Determines if the template versions table has any rows with has_ai_task = TRUE.
		SELECT EXISTS (SELECT 1 FROM template_versions WHERE has_ai_task = TRUE);
Original file line number	Diff line number	Diff line change
Expand Up		@@ -448,7 +448,6 @@ func (h Handler) renderHTMLWithState(r http.Request, filePath string, state ht
		var user database.User
		var themePreference string
		var terminalFont string
		var tasksTabVisible bool
		orgIDs := []uuid.UUID{}
		eg.Go(func() error {
		var err error
Expand DownExpand Up		@@ -484,20 +483,6 @@ func (h Handler) renderHTMLWithState(r http.Request, filePath string, state ht
		orgIDs = memberIDs[0].OrganizationIDs
		return err
		})
		eg.Go(func() error {
		// If HideAITasks is true, force hide the tasks tab
		if h.opts.HideAITasks {
		tasksTabVisible = false
		return nil
		}

		hasAITask, err := h.opts.Database.HasTemplateVersionsWithAITask(ctx)
		if err != nil {
		return err
		}
		tasksTabVisible = hasAITask
		return nil
		})
		err := eg.Wait()
		if err == nil {
		var wg sync.WaitGroup
Expand DownExpand Up		@@ -571,7 +556,7 @@ func (h Handler) renderHTMLWithState(r http.Request, filePath string, state ht
		wg.Add(1)
		go func() {
		defer wg.Done()
		tasksTabVisible, err := json.Marshal(tasksTabVisible)
		tasksTabVisible, err := json.Marshal(!h.opts.HideAITasks)
		if err == nil {
		state.TasksTabVisible = html.EscapeString(string(tasksTabVisible))
		}
Expand Down
Original file line number	Diff line number	Diff line change
Expand Up		@@ -13,6 +13,7 @@ import { AvatarData } from "components/Avatar/AvatarData";
		import { AvatarDataSkeleton } from "components/Avatar/AvatarDataSkeleton";
		import { Button } from "components/Button/Button";
		import { displayError } from "components/GlobalSnackbar/utils";
		import { Link } from "components/Link/Link";
		import { Margins } from "components/Margins/Margins";
		import {
		PageHeader,
Expand DownExpand Up		@@ -60,6 +61,7 @@ import { Helmet } from "react-helmet-async";
		import { useMutation, useQuery, useQueryClient } from "react-query";
		import { Link as RouterLink, useNavigate } from "react-router-dom";
		import TextareaAutosize from "react-textarea-autosize";
		import { docs } from "utils/docs";
		import { pageTitle } from "utils/page";
		import { relativeTime } from "utils/time";
		import { type UserOption, UsersCombobox } from "./UsersCombobox";
Expand DownExpand Up		@@ -139,7 +141,10 @@ const NoTemplatesPlaceholder: FC = () => {
		No Task templates found
		</h3>
		<span className="text-content-secondary text-sm">
		Create a Task template to get started
		<Link href={docs("/ai-coder/tasks")} target="_blank" rel="noreferrer">
		Learn about Tasks
		</Link>{" "}
		to get started.
		</span>
		</div>
		</div>
Expand Down