I’m trying to export some data from Jira, but I’m running into a small issue. I want to get all the comments for our tickets, but I don’t need the ones made by admins. They often leave internal notes that aren’t relevant to what I’m looking for.
Does anyone know if there’s a setting or option to exclude admin comments during the export process? I’ve looked through the export settings, but I can’t seem to find anything specific for this.
It would save me a ton of time if I could filter these out automatically instead of having to clean up the data manually after exporting. Any tips or tricks would be super helpful!
hey there! i’ve dealt with this before. what i do is export everything, then use a script to remove admin comments. it’s not perfect, but it works ok. you could also try asking ur jira admin to set up a custom field for ‘comment type’ - that might make filtering easier in future exports. good luck!
While Jira doesn’t offer a direct option to filter out admin comments during export, a practical workaround is available. You can export all comments as usual and then process the data in a spreadsheet application such as Excel or Google Sheets. In your spreadsheet, designate a column for user identification and use formulas to mark the admin comments. Once identified, you can easily filter or remove these rows. This approach, although indirect, helps reduce manual clean-up and has worked well for me with proper verification.
I’ve faced a similar challenge when exporting Jira data. Unfortunately, there’s no built-in option to filter out admin comments during the export process. However, I found a workaround that might help you.
Instead of relying on the export feature, I use Jira’s REST API to pull the data I need. With the API, you can create a custom JQL query that excludes comments from specific users or user groups. This way, you can fetch only the relevant comments.
It does require some coding knowledge, but once set up, it’s much more flexible than the standard export. You can use a script to automate the process, making it a one-click solution for future exports.
If you’re not comfortable with coding, another option is to use a third-party Jira add-on. Some of these offer more advanced filtering options for exports. They’re not free, but they can save a lot of time in the long run.