Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in
Deleted user
0 / 0 points
Next:
badges earned

Your Points Tracker
Challenges
Leaderboard
  • Global
  • Feed

Badge for your thoughts?

You're enrolled in our new beta rewards program. Join our group to get the inside scoop and share your feedback.

Join group
Recognition
Give the gift of kudos
You have 0 kudos available to give
Who do you want to recognize?
Why do you want to recognize them?
Kudos
Great job appreciating your peers!
Check back soon to give more kudos.

Past Kudos Given
No kudos given
You haven't given any kudos yet. Share the love above and you'll see it here.

It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

Which tables to use to get a story with story points? Edited

I want to get the story points for a story, I cannot find it in the Issues table.  I read somewhere its in the customfieldsvalue table, but where is that table? I cannot see that when connecting jira data through odbc.. I am using the CData odbc connector.  Basically all I need is to be able to get a story and its story points for further analysis on data, but am not able to find which tables to use and how to link them.. Very confusing documentation.

1 answer

0 votes

I would stop using this database connection and do it properly - use a REST call to get the issues.  That way you don't have to worry about the tables or how they are related to each other

Thanks for your reply.  I am more of a database guy, so not quite familiar using the API's developing some code and all.  So I am trying to use the third party connectors and fetch data.  Can you elaborate more on the REST call method or any other easier way for me to get this?

Yeah, you need to stop thinking database with Atlassian products, they're simply not built for any form of reporting and you really don't want to be reading them.

Have a look at https://docs.atlassian.com/software/jira/docs/api/REST/1000.824.0/ - start with a look at the "get issue" call - when you use that, you'll get all the fields from an issue without having to look in multiple places.

Ya I understand its not built for reporting, but there are certain things operations team need and if not available directly within the platform we have to find alternate ways to do such things. If inbuilt we had such flexible options to query and create customer reports/alerts it would help.  Anyways I will give the REST api thing a try. Also one other issue I faced while using the odbc connector is its giving me 'Too many requests' or 'Rate limit exceeded' error while fetching even a not so big amount of data! Any resolution for this? Thanks in advance.

"but there are certain things operations team need and if not available directly within the platform"

That's actually my point.  The database is not intended for reporting, and the stuff your "operation team needs" is hard to extract from it.  In fact, there are things you see on-screen and in REST calls that are not in the database at all.  So it's absolutely the wrong way to look at Jira data.

If using the odbc connector is giving you rate limit errors, then that's another reason to stop doing it that way - it's not working.  It's probably doing a really bad thing like asking for an issue view as though it's done by a database table, which in fact means it could be making hundreds of calls just for one thing.

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
PREMIUM
TAGS
Community showcase
Published in Confluence

Introducing External Collaboration for Confluence

We’re excited to introduce external collaboration for Confluence, now available in early access. It is available to preview for Confluence Cloud Premium and Enterprise customers. (If you're not on ...

186 views 0 7
Read article

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you