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; } } }

Need to run fortnightly report

Johnny_Lau

Need help with JQL expression to run scheduled fortnightly report.

For example:

End of Week 2 (Jan) - Run Report from 1 January to 15 January

End of Week 4 (Jan) - Run Report from 16 Jan to 31 Jan

And So On.

Currenty, the scheduled report is run quarterly and it has more than 1000 lines so the rest are not captured/reported.

Current JQL expression below:

project = "BOS" AND issuetype = "XXX Request" AND created >= 2019-01-01 AND created <= 2019-03-31

Accepted answers

Sreenivasaraju P

project = jira and created > startOfMonth() - you can use this for 15th report. This is will give all the issue created in this month.

project = jira and created > startOfMonth(2w) - you can use this for month end report. This will give all issues created after 2 weeks in this month.

All comments

Sreenivasaraju P

project = jira and created > startOfMonth() - you can use this for 15th report. This is will give all the issue created in this month.

project = jira and created > startOfMonth(2w) - you can use this for month end report. This will give all issues created after 2 weeks in this month.

Johnny_Lau

The Cron job/schedule as to when it will run has no issue. But the content of the report of which it needs to pull the created issue is what I am struggling.

Every time the Cron job is run, it will not pull the report content of which it has previously run.

Sreenivasaraju P

Sorry. You can use below jqls.

project = jira and created > startOfMonth() - you can use this for 15th report. This is will give all the issue created in this month.

project = jira and created > startOfMonth(2w) - you can use this for month end report. This will give all issues created after 2 weeks in this month.

Johnny_Lau

Thanks Sreeni.

With created > startOfMonth(), can you explain how it will capture 1st to 15th (inclusive)?

And how with created > startOfMonth(2w), will it capture 16th to end of month? If I schedule it to run fortnightly with Cron job?

Welcome!

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

Quick Links

Find more posts tagged with

server

jira

jira-server