Using project groups in reports

The easiest way to use project group data in reports is if your reporting tool makes direct requests against the Jira database.

Project Groups for Jira use two database tables to store group-related data - AO_2E9800_GROUPS and AO_2E9800_PROJECT_LINK:

AO_2E9800_GROUPS definition
create table "AO_2E9800_GROUPS"
  (
      "ID"          serial primary key,
      "PARENT_ID"   integer default 0,
      "TITLE"       varchar(255),
      "BREADCRUMBS" varchar(255),
  )
AO_2E9800_PROJECT_LINK definition
create table "AO_2E9800_PROJECT_LINK"
  (
      "ID"         serial primary key,
      "GROUP_ID"   integer default 0,
      "PROJECT_ID" bigint  default 0
  )

An example query giving an idea of how to get the project group of an issue:

select issue.id, "group"."BREADCRUMBS"
  from jiraissue issue
           join
       "AO_2E9800_PROJECT_LINK" project_link on issue.project = project_link."PROJECT_ID"
           join
       "AO_2E9800_GROUPS" "group" on project_link."GROUP_ID" = "group"."ID"
Project consoleAPIs