Skip to content

Add jira imports to usage data

Jarka Košanová requested to merge 208920-jira-import-usage-data into master

What does this MR do?

It adds Jira import stats to the Usage data.

Queries

SELECT MIN("jira_imports"."id") FROM "jira_imports" WHERE "jira_imports"."status" = 4

SELECT MAX("jira_imports"."id") FROM "jira_imports" WHERE "jira_imports"."status" = 4

SELECT COUNT("jira_imports"."id") FROM "jira_imports" WHERE "jira_imports"."status" = 4 AND "jira_imports"."id" BETWEEN 0 AND 99999

SELECT COUNT("jira_imports"."id") FROM "jira_imports" WHERE "jira_imports"."status" = 4 AND "jira_imports"."id" BETWEEN 0 AND 99999

SELECT MIN("jira_imports"."project_id") FROM "jira_imports" WHERE "jira_imports"."status" = 4

SELECT MAX("jira_imports"."project_id") FROM "jira_imports" WHERE "jira_imports"."status" = 4

SELECT COUNT(DISTINCT "jira_imports"."project_id") FROM "jira_imports" WHERE "jira_imports"."status" = 4 AND "jira_imports"."project_id" BETWEEN 0 AND 9999

SELECT SUM("jira_imports"."imported_issues_count") FROM "jira_imports" WHERE "jira_imports"."status" = 4

Does this MR meet the acceptance criteria?

Conformity

Availability and Testing

Issue #208920 (closed)

Edited by Yorick Peterse

Merge request reports