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

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

Roshan R.Shet Feb 13, 2017

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

0 votes
Abhinav Ojha Feb 15, 2017

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.



Matthew Korich Nov 09, 2017 • edited

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


DataSource.Error: The operation has timed out

Abhinav Ojha Nov 09, 2017

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. 



Suggest an answer

Log in or Sign up to answer
This widget could not be displayed.
This widget could not be displayed.
Community showcase
Posted in Jira Core

How to manage many similar workflows?

I have multiple projects that use variations of the same base workflow. The variations depend on the requirements of the project or issue type. The variations mostly come in the form of new statuses ...

667 views 7 0
Join discussion

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