Original story points

[talha Parvaiz]

Hi,

I am trying to locate which table has Original story points

It seems like customfield and customfieldvalue tables do not have the data. I was able to extract other fields like Planned End, Planned Start, etc., from these tables and that's why I am confident that these tables do not contain Original story points for our implementation.

Please advise

Thanks

[Nic Brough -Adaptavist-]

I would strongly recommend that you stop reading the database, it's the single worst way you can possibly get data out of Jira.

If you insist on doing this badly, I'll save you some time - it's on jiraissue, but you won't like the way it handles.  I'd strongly recommend using the REST API for whatever you're doing instead.

[talha Parvaiz]

which JiraIssue field has this information? I am unable to track it

Thanks again for your assistance

[Nic Brough -Adaptavist-]

Have a look at the table - the field names are clear (mostly)

[talha Parvaiz]

found it

to_char(json_value(json_value,'$.original_story_points'), '9,999.99') as Original_Story_Pts
from jir.entity_property
where
Entity_name = 'IssueProperty'

Thanks for your assistance