How to add in SQL quer customfield (category)

Question

How to add in SQL select extra column (customfield (category))? Maybe someone has some kind of sql script?

Now it looks like this:

select ASSIGNEE, SUMMARY, concat(originalkey, '-',issuenum) as Issuekey ,issuetype
from jiraissue, project
where project.id = jiraissue.project
and project.pkey = 'ABC'

NewByatl · Answer

@Nic Brough -Adaptavist-

Yea! I can do this, but I wanna get the same report via SQL, because I want to export more than 1000 issues (90293 issues) and ..I wanna find out how to export it via SQL (kind of challenge)

Nic Brough -Adaptavist- · Answer

I suggest you use JQL and the issue navigator to do this.

NewByatl · Answer

Hello! @Nic Brough -Adaptavist-

I'm trying to write something like that:

It looks like JQL report: project = "ABC"

And with extra column Category. If I use query like below, it returns me null in category column ( but It can't be, because  all category fields are filled in)

select ASSIGNEE, SUMMARY, concat(originalkey, '-',issuenum) as Issuekey ,issuetype,

(SELECT cfo.customvalue
FROM customfield cf, customfieldvalue cfv , customfieldoption cfo
where cf.id = cfv.customfield
and cast(cfv.stringvalue as integer) = cfo.id
and cf.ID = '24411' AND jiraissue.id = cfv.customfield
) AS Categoryy

--select*
from jiraissue, project
where project.id = jiraissue.project
and project.pkey = 'ABC'