How to use Jira-Smartsheet Connector filter so that filtered items are not in sheet?

GTBHI2022

Is there a way to use the Jira-Smartsheet Connector so that items that do not match the filter criteria are not brought into the Smartsheet sheet? I'd like to do this so that when my source data exceeds the SmartSheet sheet limits it does not break the sheet and downstream workflows associated with the sheet.

Genevieve P.

Hi @GTBHI2022

You can set up JQL (Jira Query Language) to filter your data. Here's the Smartsheet article on Jira filtering:

Smartsheet for Jira: Tips for using filters | Smartsheet Learning Center

https://help.smartsheet.com/articles/248265-jira-tips-using-filters

Use filters to control the volume and type of issues that you work with.

Here's the article from Jira on JQL:

JQL: The most flexible way to search Jira

https://www.atlassian.com/blog/jira-software/jql-the-most-flexible-way-to-search-jira-14

This tutorial series walks through the basics of Jira's query language explaining how to make the best use of search features within Jira.

Cheers,

Genevieve

GTBHI2022

So does that mean that when I'm in this screen, when setting up my connector, selecting a field and using the built in filter will not filter my results. I actually need to write a 'Custom JQL' query in that section at the bottom of the drop down in order to prevent the filtered items from being available in the SmartSheet sheet?

Genevieve P.

Hi @GTBHI2022

You can use that built in filter or create a Custom JQL filter, either-or!

Keep in mind that if your data changes and current rows no longer meet your filter criteria, they'll still be in the sheet but they will move under the "Filtered out by Connector—not synced" parent row.

Here's more information: How to Use "Filtered Out by Connector—Not Synced.

Cheers,

Genevieve