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

SQL query to get biggest attachments from Jira?

Sorin Sbarnea (

I am looking for a SQL query that would retrun me the first biggest attachments from a Jira instance.

It would be perfect to work on PostgreSQL but I can fix it myself even if it's for another SQL backend.

Accepted answers

Norman Abramovitz

select filesize, jiraissue.pkey from fileattachment, jiraissue WHERE
fileattachment.issueid = jiraissue.id
order by filesize desc limit 20;

All comments

Norman Abramovitz

select filesize, jiraissue.pkey from fileattachment, jiraissue WHERE
fileattachment.issueid = jiraissue.id
order by filesize desc limit 20;

Is there an update to this for a newer version of Jira? This returns the list of giant files i've but BUT the "pkey" column is empty. Any thoughts?

Welcome!

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

Quick Links

Find more posts tagged with

sql

jira