Hi Tech Support,
we're currently trying to find out how many bmml files there are in our jira instance.
i used the following logic(in the database via sql):
3 Tables: changeitem, changegroup and jiraissue
changeitem has a foreign key to changegroup as groupid
changegroup has a foreign key to jiraissue as issueid
additionally i filter the results for changeitem.Field = Attachment
but the results we're receiving are not right. we're not finding some specific bmml files in the database.
how can we achieve our goal, are there any best practices?