Can a Filter compare an issue custom date field with a runtime query?

[Phil Bustin]

There are two parts to this question, and I've added two more questions:

1) Is there such a thing as a runtime query in JQL or in a Filter?

2) If so, can an issue date (not date/time) field be compared with the runtime query?  I figure the JQL would read something like this, with startOfDay and endOf Day being replaced by the runtime Query syntax:

     "PR Move Requested Date[Date]" > startOfDay() AND "PR Move Requested Date[Date]" < endOfDay()

I also figure that the JQL above would work if the filter were run on the date equal to issue."PR Move Requested Date".  (The two comparisons are needed because the comparison entities are date/time.)

3) I don't suppose there's a date (note date/time) comparison entity.

4) If this can't be done with a Filter (and Dashboard that uses it), can it be done by other means, without 3rd party apps?

[Trudy Claspill · Accepted solution]

Hello @Phil Bustin 

Can you clarify exactly what you mean by "runtime query"?

Exactly what sort of query would you want to substitute in where you currently have startOfDay() and endOfDay().

What problem are you trying to solve that you want a date comparison entity?

Perhaps if you provide more information about the problem that you are trying to solve, with examples of the source data and the results you would want to get, then we can provide relevant suggestions.

[Phil Bustin]

Two or so days before a monthly software move, I run an SBM report that I configured to request a date ("runtime query").  The report is a preview of the monthly move, and includes a software move instructions field.  It compares the date I input (in response to the report's prompt) to a field "PR Move Requested Date" in SBM items, so that only the items ("issues" in Jira) with dates that match are selected.

I would like to emulate the report in Jira.

[Trudy Claspill]

There is not a native method to prompt for a date and plug that input into a JQL query run through the View all issues search screen.

You could create an Automation Rule that uses a Manual trigger. A Manual trigger can be set up to prompt a user for input. You could then use that input in a Lookup Issues action to retrieve a list of issues based on a JQL that compares a date field to that input. You could send the results of the action to yourself in an email.

You could also create a Saved Filter that uses the startOfDay() function and then set up 1..n schedule Subscriptions to the filter to send the results to you one, two, three, or however many days before the end of the month.

There may also be third party apps that could enable you to select a date to feed into a filter, or maybe a custom reporting app like eazyBI would enable you to construct the type of report you want.

[Phil Bustin]

Thanks.  For now, I'll update the Filter once a month, and perhaps try the automation rule.