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

How to get jira project that has not updated before six months?

New_lasm7y

Hi Support,

We want to write a SQL to get jira project that has not updated before six months?

For example,today is 2018/01/23,that I want to get current date - 6 months that means I need to get the last issue updated before 2017/07/23,Is it possible to get the information for postgresql database?

Thank you in advance!

Accepted answers

All comments

Alexey Matveev

I think the SQL query would be like this

select * from

(select project, max(updated) lastUpdate from jiraissue group by project) a

where lastUpdate < to_date("YYYY/MM/DD", "2017/07/23")

New_lasm7y

Hi Support,

But we want to dynamic use this SQL,not just use to_date?

How could we revise to current - 6 months ?

SQL error message as below(our database is postgresql)

Thank you.

Alexey Matveev

select * from

(select project, max(updated) lastUpdate from jiraissue group by project) a

where lastUpdate <
now() - interval '6 month'

New_lasm7y

Hi Support,

But it can't show the project issue key?

It only shows the timestamp?

Welcome!

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

Quick Links

Find more posts tagged with

jira

postgres