Adjust parents due date automatically to the nearest due date of one of the sub-tasks

[Sharon Freij]

Hi everyone, hope someone can help me.

Within my jira project, I have several Stories, Tasks and sub-tasks. With Jira automation, the story/task will be automatically progressed when all of the sub-tasks are done (for example). 

But now I'm facing an issue which I'm not able to solve. Hope that someone within this community can help.

I would like to make the due date of the parent dependent on the nearest/shortest due date of their sub-tasks. For example:
Story --> due date is empty during creation
Sub-task 1 --> due date is 01.04.2021
Sub-task 2 --> due date is 06.04.2021
Sub-task 3 --> due date is 31.03.2021

The due date of the parent should also be 31.03.2021 automatically.

How to do that?

[Sean Kane · Accepted solution]

Applying this patch to activeobjects.xml in the backup archive before restoring it, either fixes or works around the problem by basically changing the datatype of two of the plugin fields from varchar(255) to text (unlimited length) in postgresql.

<pre>
--- activeobjects.xml.orig  2012-10-29 20:50:40.908046517 +0000
+++ activeobjects.xml 2012-10-29 20:51:16.246045775 +0000
@@ -318,7 +318,7 @@
     <column name="USER" primaryKey="false" autoIncrement="false" sqlType="12" precision="255"/>
   </table>
   <table name="AO_88DE6A_TRANSACTION_CONTENT">
-    <column name="CONTENT" primaryKey="false" autoIncrement="false" sqlType="12" precision="255"/>
+    <column name="CONTENT" primaryKey="false" autoIncrement="false" sqlType="12" precision="-1"/>
     <column name="ID" primaryKey="true" autoIncrement="true" sqlType="4" precision="10"/>
     <column name="TRANSACTION_ID" primaryKey="false" autoIncrement="false" sqlType="4" precision="10"/>
     <foreignKey fromTable="AO_88DE6A_TRANSACTION_CONTENT" fromColumn="TRANSACTION_ID" toTable="AO_88DE6A_TRANSACTION" toColumn="ID"/>
@@ -326,7 +326,7 @@
   <table name="AO_88DE6A_TRANSACTION_LOG">
     <column name="ID" primaryKey="true" autoIncrement="true" sqlType="4" precision="10"/>
     <column name="LEVEL" primaryKey="false" autoIncrement="false" sqlType="12" precision="255"/>
-    <column name="MESSAGE" primaryKey="false" autoIncrement="false" sqlType="12" precision="255"/>
+    <column name="MESSAGE" primaryKey="false" autoIncrement="false" sqlType="12" precision="-1"/>
     <column name="TIME" primaryKey="false" autoIncrement="false" sqlType="93" precision="29"/>
     <column name="TRANSACTION_ID" primaryKey="false" autoIncrement="false" sqlType="4" precision="10"/>
     <foreignKey fromTable="AO_88DE6A_TRANSACTION_LOG" fromColumn="TRANSACTION_ID" toTable="AO_88DE6A_TRANSACTION" toColumn="ID"/>
</pre>

[Anandhi A]

I face a similar issue. Can you please tell me how to apply the patch that you have mentioned? Please bear with me since I am very new to all these stuff.