How do I use a Date Picker field in a JQL query to find updates made after that date?

Question

We have a custom field in the issues called Sprint Start Date which through an automation gets updated with the start date of the sprint for all issues in that sprint or added after the sprint started.

I want to see which issues have not transitioned during that said sprint but we don't have access to startOfSprint() function.

I thought I could use:
NOT status changed after "Sprint Start Date"
or
issuefunction in dateCompare("", "'Sprint Start Date' > updated")

But none of these work.

Marcos Michel · Answer

This was actually very useful. I was using 'Sprint Start Date' with the single quote thinking I had to because of the multiple words.

I'm still struggling to get what I need though.

I'm trying to get all the issues that have not transitioned after the sprint started.

I thought the following was going to do it, but it didn't.

issuefunction in dateCompare("not status changed", "updated >= Sprint Start Date")

Marc -Devoteam- · Answer

Hi @Marcos Michel

Ah, you have scriptrunner installed on the instance, that gives extra functions, above the default JQL

you could use: issuefunction in dateCompare("",  "updated > Sprint Start Date")

As @Jim Knepley - ReleaseTEAM mentions a subquery is useful as performance can be an issue. You could at something like; project = <project_key> and sprint in openSprints()

Marcos Michel · Answer

It doesn't take the custom field and I don't know why