Adding "start of sprint" to JQL

Question

In order to see that issues that were created and added to sprint after is was started, I tried to create a JQL that looks something like that:

project = XYZ AND sprint in openSprints() AND createdDate > 2018-11-25  AND issuetype not in (Bug)

Is there a way to have a "start of sprint" to automatically replace the date I manually added? Something like this drop down option:

Bastian Schenke _DHL IT Services_ · Answer

This might be helpful: https://docs.adaptavist.com/sr4jc/latest/features/scriptrunner-enhanced-search/scriptrunner-enhanced-search-jql-functions/agile-and-sprint-management

Olga Videc · Answer

Using StartOfDay(8) you can filter everything that was for example created 8 hours after the day started,  this only apply's to the current day.

The part Is there a way to have a "start of the sprint" to automatically replace the date I manually added? Something like this drop down option:

Maybe with some custom script, but not true JQL

Olga Videc · Answer

Hello Itay,

This is how your JQL should look like

project = test and Sprint = 1 and created >= 2018-11-25 and issuetype != Bug

the part after first and write like this "Sprint = " and then it will offer you drop down with sprints so you choose one you desire.

BR, Olga