Can I add request-channel-type as one of the columns in JQL list view?

[Zaldy Parian]

Hi all,

Is there a way to add the request-channel-type in the list view when running a JQL without creating a new custom field to duplicate it?

Regards,

[Jack Brickey · Accepted solution]

Hi @Zaldy Parian , the request-channel-type is not a field but rather an issue property. For this reason you cannot add it as a column in a JQL filter. You can use it in the filter itself however, e.g. project = abc and request-channel-type = email.

With that said, you could create a custom field and copy the request-channel-type into the field using Automation. Keep in mind that this can chew up your automation allocation pretty quickly. 

[Zaldy Parian]

Thanks, @Jack Brickey 

I'm trying not to add new custom field. I'll search for some code for ScriptRunner instead of Jira automation rule.

Cheers,

[Hannes Obweger - JXL for Jira]

Hi @Zaldy Parian

if you're open to solutions from the Atlassian Marketplace, this would be available out-of-the-box in the app that my team and I are working on, JXL for Jira.

JXL is a full-fledged spreadsheet/table view for your issues that allows viewing, inline-editing, sorting, and filtering by all your issue fields, much like you’d do in e.g. Excel or Google Sheets. It also comes with a number of so-called smart columns that aren’t natively available, including the Request channel.

This is how it looks in action:

As you can see above, you can easily sort and filter by the request channel, and also use it across JXL's advanced features, such as support for (configurable) issue hierarchies, issue grouping by any issue field(s), sum-ups, or conditional formatting.

This all just works, so there's no scripting or automation whatsoever required.

Any questions just let me know,

Best,

Hannes

[Zaldy Parian]

Thanks for the option @Hannes Obweger - JXL for Jira . Will definitely have a look.

[Asha Goyal]

Hello @Zaldy Parian 

Are you already using any Plugging in your instance like JMWE or Script Runner?

Thanks

[Zaldy Parian]

Hi @Asha Goyal ,

We have ScriptRunner installed.