Database Querying

Hi Antonella,

In our current change process we are querying directly on the JIRA Database, as you search in more detail and we can send out emails automatically.

For the new process in which we would like to use your plugin, we also want to work with direct querying on the database

I am not sure if you have done this already but what are the DB tables Herzum is using. If possible maybe you can give us some examples quieries?

Many thanks,

Stefan

5 answers

This widget could not be displayed.

Hi Stefan,
please, review https://chicago.herzum.com/confluence/display/HAP/HAP+-+Database+Documentation.

I hope it helps.

Regards,

Antonella

This widget could not be displayed.

Hi Antonella, thanks for this very handy. Do you maybe have some example sql scripts we can use to test?

Not sure if you were already experimenting with this?

For example

Show me all tickets from Project X in workflowstatus X where the herzum group approval = "Groupname"

If you already know the joins we do not have to check everything.

Many thanks! Stefan

This widget could not be displayed.

Hi Stefan,


Here it is the Script you have required based on your Approval configuration with Group Picker custom Field:


SELECT hql6411dbstaging.AO_D195E9_ISSUE_APPROVAL.* FROM hql6411dbstaging.AO_D195E9_ISSUE_APPROVAL inner join hql6411dbstaging.jiraissue on hql6411dbstaging.AO_D195E9_ISSUE_APPROVAL.issue_id= hql6411dbstaging.jiraissue.ID inner join hql6411dbstaging.project on hql6411dbstaging.project.ID=hql6411dbstaging.jiraissue.PROJECT inner join hql6411dbstaging.issuestatus on hql6411dbstaging.issuestatus.ID=hql6411dbstaging.AO_D195E9_ISSUE_APPROVAL.ISSUE_STATUS where hql6411dbstaging.project.pname= 'Test2' and hql6411dbstaging.AO_D195E9_ISSUE_APPROVAL.custom_approver= 'admin' AND hql6411dbstaging.issuestatus.pname= 'To Do';

You need to customize the following:

  • hql6411dbstaging -> your Database name
  • 'Test2' -> your Project name
  • 'admin' -> your Group name
  • 'To Do' -> your workflow status

I hope it helps.

Regards,

Antonella

This widget could not be displayed.

Hi Antonella,

Much appreciated!! let me do some testing and come back to you!

Regards,

Stefan

This widget could not be displayed.

It worked! thanks smile. If I have additional questions I will let you know.

Regards,

Stefan

Suggest an answer

Log in or Sign up to answer
Community showcase
Published Aug 22, 2018 in Marketplace Apps

How a Marketplace app tech team is achieving gender diversity

Hello! My name is Genevieve Blanch, and I'm the Marketing Manager at RefinedWiki, creators of apps to give teams the tools to customize Atlassian platforms. Currently, 44% of the tech team at Re...

486 views 3 18
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