Hello @Ismael Nunez Gatica,
Thank you for reaching out to the Atlassian Community!
The request-channel-type is an issue property and not a custom field, so it will not be possible to add it as a column in order to export it to excel.
The workaround for that would be to use automation that will validate if the ticket was created, for example, via Portal, and then add this information on a custom field.
In the example below, I created a new custom field called Channel (type Text Field (read only)). I'm using a company-managed project for the below steps, but in case you are using a team-managed, you can use the Short text field.
After that, on Project settings > Automation > Automation I created a new rule to validate if the request is created via Jira, then edit the custom field Channel with the value Jira, else, if created via Portal, then edit the field with the value Portal.
When: Issue created
New condition > If / else block > Add conditions > JQL condition
It will be necessary to create five of the if/else for the following JQLs:
request-channel-type = jira
request-channel-type = portal
request-channel-type = anonymousportal
request-channel-type = email
request-channel-type = api
Then > New action > Edit issue > Select the custom field > Type the desired value > Save.
After that, also add this field as a column on the issue search for you to be able to export in Excel:
Hope this helps!
Hello Atlassian Community! We’re thrilled to announce some exciting changes to incident management in Jira Service Management Cloud, in order to give your teams extra muscle during incidents, and ...
Connect with like-minded Atlassian users at free events near you!Find an event
Connect with like-minded Atlassian users at free events near you!
Unfortunately there are no Community Events near you at the moment.Host an event
You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events