How do I query the JIRA Ultimate Tracking Utility values in the database?

Can I fetch the original estimate by each role , time logged by each roles in teh database.

Could you please share the tables where this info is stored?

1 answer

This widget could not be displayed.

Hi Roshan,

The plugin stores the role based estimates in the form of a string type custom field against each issue. The customfield are stored in database in the "customfieldvalue" table's "CUSTOMFIELD" column, where this column stores the id of the custom field. 

For log work by roles, you can check this table : "AO_222C21_WORK_LOG_ROLE" of the plugin. This active object (AO) table stores role id and worklog id.

If you want to access the role based estimates, you can very easily do that using the REST services we have created. In your case following REST services will be useful:

"/rest/adweb/2/logworkCF/{IssueKey}" = to get the log works for roles

"/rest/adweb/2/timetracking/{IssueKey}" = to get estimates by roles

"/rest/adweb/2/logworkCF/project/{ProjectKey}" = to get all the log work by roles in a project


I hope this will be helpful for you. Let us know if you have any further queries.


Thanks,

Abhinav.

Our project DB is large and the project query is timing out. Any suggestions to optimize? 

/rest/adweb/2/logworkCF/project/<project-key>

DataSource.Error: The operation has timed out
Details:...

Hi Matthew,

If you have the latest update of the plugin, you can see a couple of filter options (using JIRA REST API Browser), which can allow you to limit your results by start & end dates and/or a number of results.

Please try and let us know if that helps. 

Thanks,

Abhinav.

Suggest an answer

Log in or Sign up to answer
Atlassian Summit 2018

Meet the community IRL

Atlassian Summit is an excellent opportunity for in-person support, training, and networking.

Learn more
Community showcase
Posted 5 hours ago in Statuspage

What are your best incident management tips and stories? #HugOps

 👋Community members! Downtime happens. And great incident response takes a village. Teams like Support, Dev, SRE, Ops, IT, and Marketing have to come together to resolve the problem while keep...

23 views 0 2
Join discussion

Atlassian User Groups

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

Find a group

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

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you