[cherry-pick] Adjust the query by UUID sql so that it can use the idx…

…_task_extra_at… (#20546) Adjust the query by UUID sql so that it can use the idx_task_extra_attrs_report_uuids fixes #20505 Signed-off-by: stonezdj <stone.zhang@broadcom.com>
goharbor · Jun 4, 2024 · 7025568 · 7025568
1 parent 81fcc0a
commit 7025568
Showing 1 changed file with 2 additions and 2 deletions.
diff --git a/src/pkg/task/dao/task.go b/src/pkg/task/dao/task.go
@@ -114,8 +114,8 @@ func (t *taskDAO) ListScanTasksByReportUUID(ctx context.Context, uuid string) ([
 	}
 
 	var tasks []*Task
-	param := fmt.Sprintf(`{"report_uuids":["%s"]}`, uuid)
-	sql := `SELECT * FROM task WHERE extra_attrs::jsonb @> cast( ? as jsonb )`
+	param := fmt.Sprintf(`"%s"`, uuid)
+	sql := `SELECT * FROM task WHERE extra_attrs::jsonb -> 'report_uuids' @> ?`
 	_, err = ormer.Raw(sql, param).QueryRows(&tasks)
 	if err != nil {
 		return nil, err