Database relationship between Project and Issue Type Scheme

Question

I have been trying to fin this for a few hours and am stumped!

There is a post that was of great help for some of the project relationships, but not this one.

The TABLE that holds the Issue Type Schemes is fieldconfigscheme

But I can not find out how that table relates to the project table.

Thanks in advance for any assistance!

Robin Powell_pjvgk1 · Answer

Just a heads-up, that query shows all of the schemes associated with a project. Not a bad thing, but if you want only the issue type schemes, you need a where clause that narrows the scope of what's returned. Something like this (works on Postgres):

SELECT cc.project AS project_id, p.pname AS project_name, fcs.configname AS issue_type_scheme, p.lead AS project_lead
FROM configurationcontext cc
  INNER JOIN fieldconfigscheme fcs ON cc.fieldconfigscheme = fcs.id
  INNER JOIN project p ON cc.project = p.id
WHERE fcs.fieldid = 'issuetype'
ORDER BY project_name;

Damjan Koporec · Answer

Thx Joe.... had the same issue and this post really helped.

Regards

Damjan

António José Figueiredo · Answer

Hi Joe!

Hard time to figured out here too, but after i read all your posts, u solved my problem!

This last one worked for me. Thanks alot!

Regards,

António