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 Sign up to answer
Community showcase
Posted Oct 09, 2018 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 ...

240 views 6 0
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