nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Narrow search for year 2022

John Pereira_pmwytc

I am trying to write a JQL but it's not working in Jira. If I take the AND (resolutiondate = startOfYear("2022")) AND (resolutiondate = endOfYear("2022") ) the query works. I'm trying to ensure that I can only see tickets within 2022.

("Customer Request Type" = "Hidden Onboarding (SUPPORT)" OR "Customer Request Type" = "Non-Employee - Onboard (SUPPORT)") AND (resolutiondate = startOfYear("2022")) AND (resolutiondate = endOfYear("2022") ).

Accepted answers

Trudy P Claspill

Hello @John Pereira

How exactly is the query not working?

Are you getting an error message? If so, what is it?

Is it not giving you the results you expect? If so please provide the details for an issue you expect to be in the results but is not appearing, for the following fields:

Custom Request Type

Resolution Date

All comments

Trudy P Claspill

Hello @John Pereira

How exactly is the query not working?

Are you getting an error message? If so, what is it?

Is it not giving you the results you expect? If so please provide the details for an issue you expect to be in the results but is not appearing, for the following fields:

Custom Request Type

Resolution Date

John Pereira_pmwytc

No errors. I just do not return anything. I'm trying to see all tickets I resolved between 1/1/22 till 12/31/22. I get no results when I try to set these dates.

If I leave things as ("Customer Request Type" = "Hidden Onboarding (SUPPORT)" OR "Customer Request Type" = "Non-Employee - Onboard (SUPPORT)") I get tons of tickets 300+.. with various dates and years.

Trudy P Claspill

Your parameters for startOfYear and endOfYear are wrong. You should not specify a specific year. You need to specify an increment/decrement relative to the current year.

Refer to

https://support.atlassian.com/jira-software-cloud/docs/advanced-search-reference-jql-functions/#Advancedsearchingfunctionsreference-startOfYearstartOfYear--

You need to use

startOfYear("-1")

endOfYear("-1")

John Pereira_pmwytc

Hi Trudy,

Thanks for your help. Still nothing.

I tried: ("Customer Request Type" = "Hidden Onboarding (SUPPORT)" OR "Customer Request Type" = "Non-Employee - Onboard (SUPPORT)") AND (resolutiondate <= startOfYear("-1") AND resolutiondate >= endOfYear("-1") )

and

("Customer Request Type" = "Hidden Onboarding (SUPPORT)" OR "Customer Request Type" = "Non-Employee - Onboard (SUPPORT)") AND (resolutiondate = startOfYear("-1") AND resolutiondate = endOfYear("-1") ).

No luck.

William Smith_tgh2yu

This site helps people get strong support for stress, anxiety, and life problems in a gentle and caring way. I like how it talks about real help for fear and tough feelings. It makes visitors feel safe and ready to get better.

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

jira

jira-software

jira-software-server