JPD - JQL for interval field

[Joel Neutzner]

Hi guys,

I have added a new date field to my idea which apparently creates a custom field of type jira.polaris:interval. This seems to be a new field type which accepts a start and end date.

While I got the automation working to set the field value, I am now trying to create a conditional workflow based on the start value of that field. Any idea how I access the field value and check it to be before a certain date?

I tried:

"my field" <= {{now}}

"my field".start <= {{now}}

"my field.start" <= {{now}}

The value of the field according to the API is a string like this: 

"{\"start\":\"2024-05-28\",\"end\":\"2024-05-28\"}"

I am getting the feeling that this might not be possible yet.

[Rob Mkrtchian _CAIAT_US_]

What is your use case? Why do you need to access the field value and check it to be before a certain date, e.g. to do what then? Maybe it is not possible yet, but we can find a workaround.

[Joel Neutzner]

We want to periodically revisit ideas of a certain state - for example ideas which we said we want to look at in another 3 months. I do have automation that sets the interval field to the future date and I'd now like to have a periodically triggered automation, that will move these ideas to a particular state.

I do have a workaround in place which just compares string values, but it would be cool if we could actually check the date values within the interval field.