util/Migrator/DbScripts/2025-08-12_00_SecurityTaskMetrics.sql

CREATE OR ALTER PROCEDURE [dbo].[SecurityTask_ReadMetricsByOrganizationId]
    @OrganizationId UNIQUEIDENTIFIER
AS
BEGIN
    SET NOCOUNT ON

    SELECT
        COUNT(CASE WHEN st.[Status] = 1 THEN 1 END) AS CompletedTasks,
        COUNT(*) AS TotalTasks
    FROM
        [dbo].[SecurityTaskView] st
    WHERE
        st.[OrganizationId] = @OrganizationId
END
GO
[PM-23580] Security Task Metrics (#6164) * add metrics endpoint for an organization to return completed and total security tasks * refactor metrics fetch to use sql sproc for efficiency rather than having to pull all security task data * add separate response model for security task metrics endpoint * Pascal Case to match existing implementations * refactor org to organization for consistency with other methods * alter security task endpoint: - remove "count" from variable naming - update sproc naming * remove enablement check * replace orgId with organizationId 2025-08-13 08:23:22 -05:00			`CREATE OR ALTER PROCEDURE [dbo].[SecurityTask_ReadMetricsByOrganizationId]`
			`@OrganizationId UNIQUEIDENTIFIER`
			`AS`
			`BEGIN`
			`SET NOCOUNT ON`

			`SELECT`
			`COUNT(CASE WHEN st.[Status] = 1 THEN 1 END) AS CompletedTasks,`
			`COUNT(*) AS TotalTasks`
			`FROM`
			`[dbo].[SecurityTaskView] st`
			`WHERE`
			`st.[OrganizationId] = @OrganizationId`
			`END`
			`GO`