How to block an issue from transitioning if there are incomplete child issues?

[Frank Cecere]

As the title says, I want to stop a user from transitioning an issue to the Done column unless the child issues underneath it are incomplete. How can I do this?

[StevenA]

Hi Bill,

As what I know, if using PosGreSQL, the table is public.jiraissue . Not sure whether if it is same with SQL server 2008 R2. In addition, you can enable SQL loggin to see SQL retrieved when issue is created.

Best Regards,

Steven

[Bill Mariasoosai]

Hi Nic:

The above link contains really a lot of information I need.

Thanks & Regards,

Bzoo

[Nic Brough -Adaptavist-]

Although you've now been given the table you asked about, I suspect you're going to look at it and find it doesn't contain what you think it does and you're going to ask for more.

Before you do, have a look at https://developer.atlassian.com/display/JIRADEV/Database+Schema

[Bill Mariasoosai]

Hi Steve:

Thanks for your info. Based on your reply, I figured out.

The name of the table is dbo.jiraissue in my SQL SERVER 2008 R2

Thanks again

Bzoo