List custom integration projects
What does this MR do?
As part of Mass-integration at a Group and Instance Level &2137, we are moving service templates to become instance-level service configuration &2430.
This is part of the first iteration to deliver the MVC #213857 (closed). The admin page to save instance-level integrations is currently under a feature flag instance_level_integrations
, so this doesn't have user-facing changes. We also need to implement the frontend for this.
Here, we list custom integration projects, projects with integration that don't inherit the settings from the instance-level integration. This is the SQL query:
SELECT "projects".*
FROM "projects"
WHERE (EXISTS
(SELECT 1
FROM "services"
WHERE "services"."type" = 'JiraService'
AND "services"."inherit_from_id" IS NULL
AND (services.project_id = projects.id)))
I've created a new concern to add specific methods related to integrations, another good candidate to this concern is project_ids_without_integration
.
Related to #218252 (closed)