Validation of Date Window

James Barratt

Is it possible to use a scriptrunner or JWT expression in the following scenario:

• A piece of equipment has been booked between date/time A and date time B. This has been added through the portal, and an Jira agent has accepted this by marking the request "Booking Accepted" = Yes, for Equipment = "x"
• Now, if someone else tried to put a request in that clashes with that time window it is not possible to submit the request in the portal.

I think what I'm after is, when the new request is submitted....

If date/time A of NEW request is between A and B for Equipment = X that already exists then deny the submission?

 

Thorsten Letschert _Decadis AG_

Hi @James Barratt,

what you're trying to achieve should be perfectly doable with the help of Jira Workflow Toolbox - I guess you're referring to when speaking of JWT.

While the final configuration is extremly dependent on your specific configuration, I'll do my best to provide some hints being as generic as possible:

• You should try using a validation based on JQL query (documented here: https://apps.decadis.net/display/JWT/Condition+and+validation+based+on+JQL+query).
• You have to define a matching JQL query that you can validate against and add it to your JQL Query section, e.g.

project = MYPROJECT AND type = MyIssueType AND "Equipment" = "x" AND "Booking Accepted" = "Yes" AND (("Date Picker A" >= "%{nnnnn}" AND "Date Picker A" <= "%{mmmmm}" ) OR ("Date Picker B"  >= "%{nnnnn}"  AND "Date Picker B" <= "%{mmmmm}"))

This JQL query would search for issues with an accepted booking for equipment x, where one of the dates provided falls in between the timeframe between Date Picker A and B (which means, the equipment would have already been blocked). Field code nnnnn has to match your Date Picker A and mmmmm Date Picker B.

• Choose Number of issues etc. (the third one) in the Condition section.
• Add the following Boolean expression:

{00058} = 0

This ensures that only if no issues are returned by the JQL, issue creation will be possible.

• Choose Summary as the Field to show in the Message to show when validation fails section and add your custom message, e.g.

<strong>Specific date range is already blocked!</strong>

The resulting message within the portal would look like this:

• Choose a user having the browse permission for all the relevant issues in the Run as section. (This is highly important, since I assume a portal user won't be able to see other tickets.)

I hope that helps.

Cheers,
Thorsten