which table in Jira database has column of story point

Question

Hi, I may seek assistance on the story point column in Jira database, I could not found it in customfield, is there any other table may contain story point by any chance

Filipi Lima · Answer

Hi, folks, I was helping a custom and saw this thread so might as well leave the info here for all:

To get all Story Points value from all issues on your instance, you can use the following:

SELECT ji.id as issue_id, p.pkey||'-'||ji.issuenum as key, cf.id as customfield_id, cfname, cfv.numbervalue
FROM customfield cf, customfieldvalue cfv join jiraissue ji on cfv.issue=ji.id join project p on ji.project = p.id
where cf.id = cfv.customfield
and cfname = 'Story Points';

If you'd like to reduce one join and make it a bit faster, you may fetch the ID of the Story Points field beforehand and hardcode it to your query:

* There are other ways to get the ID of the field: How to find id for custom field(s)?

select id from customfield where cfname = 'Story Points';

Then you replace the XXXXX with the ID from above:

SELECT ji.id as issue_id, p.pkey||'-'||ji.issuenum as key, cfv.numbervalue
FROM customfieldvalue cfv join jiraissue ji on cfv.issue=ji.id join project p on ji.project = p.id
where cfv.customfield = 'XXXXX';

If you have multiple Story Points then you need to determine which one you want.

The above is for the default Story Points which has the values on customfieldvalue.number column.

Orlando W · Answer

Thanks Monika, but I have question about that I found value or number column shows null, but I can indeed see the points in the sprint, do you know the reason, is it possible in other tables any column?

Orlando W · Answer

Thanks Sandesh, but do you know why it's null value in cfvalue table? even though it shows points number in sprint board