Date validator (30 days) - JMWE

[RIZKY JTUASIKAL]

Example:

Today is 05/25/2023 and if I create a task on 06/26/2023 (30 days) it will show an error message,

and if I create a task between the interval on 05/25/2023-06/25/2023 there is no error and the task is being created.

What is the query to get that result??

and what type of validator can I use??

[David Fischer _Appfire_ · Accepted solution]

Hi @RIZKY JTUASIKAL ,

what do you mean by "I create a task on 06/26/2023"? Where is that date input? In a custom field?

[RIZKY JTUASIKAL]

Hi @David Fischer _Appfire_ ,

it doesn't use custom field/date input. 

is that possible?



or does it have to use date input?

please advice,

thank you David 

[RIZKY JTUASIKAL]

Example:


I created subtask A, and will record the creation date.

Created on 05/25/2023.

Then there is a rule if it is still within 30 days (bases on the date of subtask A creation),

I can still create another subtask,

(ex: subtask B)

but, if it exceeds 30 days, I can't create subtask B

[David Fischer _Appfire_]

So to summarize:

1. you create a main issue
2. you create a first sub-task on that issue
3. when you attempt to create a second sub-task on that issue, you want to disable the creation if the first sub-task was created more than 30 days earlier
4. when you attempt to create additional sub-tasks, you want to disable the creation if the oldest sub-task was created more than 30 days earlier

Is that correct?

[RIZKY JTUASIKAL]

Yes, it's correct.

Everything you described above is correct, @David Fischer _Appfire_ :)

[David Fischer _Appfire_]

Hi @RIZKY JTUASIKAL ,

in that case, you can use a Build-your-own Validator with this Jira Expression:

!issue.parent || !issue.parent.subtasks.some(sub=>sub.created < new Date().minusDays(30))

[RIZKY JTUASIKAL]

Hi @David Fischer _Appfire_ ,

" when you attempt to create a second sub-task on that issue, you want to disable the creation if the first sub-task was created more than 30 days earlier "

what if these two subtasks are different issue types and workflows?

Ex:

subtask 1 is "Release Project"

subtask 2 is "Release PIR"

does it mean that I have to create a validator in the create transition (in Release PIR workflow)?

so that subtask 2 cannot be created if it exceeds 30 days

for addtional information,

I use the Release Project - Created Date field as the reference date.

This field (Release Project - Created Date) is the date when subtask 1 was created. 

[David Fischer _Appfire_]

1. Yes, you need to add the Validator on the Create transition of the sub-task workflow(s)
2. With my script, you don't need to refer to the Prelease Project - Created Date since the script looks at all sub-tasks and their creation date

[RIZKY JTUASIKAL]

Thank you @David Fischer _Appfire_ , for the answers

I really appreciate it

but one more question,

"With my script, you don't need to refer to the Prelease Project - Created Date since the script looks at all sub-tasks and their creation date"

what if only one of the subtasks?
for example, Release PIR subtask only

[David Fischer _Appfire_]

Then you can use your custom field instead:

!issue.parent || !issue.parent.customfield_12345 || issue.parent.customfield_12345 >= new Date().minusDays(30)

where customfield_12345 is the custom field ID of the Release Project - Created date custom field.  

[RIZKY JTUASIKAL]

thank you David :)

you help me so much