Query: open_issue_table

select
  p.full_path as "Project",
  title as "Issue",
  now()::date - i.created_at::date as "Age in Days",
  now()::date - i.updated_at::date as "Days Since Last Update",
  author as "Author",
  i.web_url,
  p.web_url as project_url
from
  gitlab_my_project p
  join gitlab_issue i on i.project_id = p.id
where
  i.state = 'opened'
order by
  "Age in Days" desc;