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

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 Join to answer
Community showcase
Emilee Spencer
Published Friday in Marketplace Apps

Marketplace Spotlight: DeepAffects

Hello Atlassian Community! My name is Emilee, and I’m a Product Marketing Manager for the Marketplace team. Starting with this post, I'm kicking off a monthly series of Spotlights to highlight Ma...

64 views 0 3
Read article

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
Atlassian Team Tour

Join us on the Team Tour

We're bringing product updates and pro tips on teamwork to ten cities around the world.

Save your spot