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

Phil Bustin
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
April 22, 2024

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?

1 answer

1 accepted

1 vote
Answer accepted
Trudy Claspill
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
April 22, 2024

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
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
April 22, 2024

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
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
April 22, 2024

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
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
April 23, 2024

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

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
PREMIUM
PERMISSIONS LEVEL
Site Admin
TAGS
AUG Leaders

Atlassian Community Events