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.
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?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.