Getint: Where every ticket finds it's place.
Support portalCase studiesSchedule a demo
  • Welcome to the Getint Documentation Hub
  • Getting started with Getint
    • About Getint / Concepts
      • How Getint works (how it syncs the data)
      • Onboarding
      • What is a Connection?
      • What Are Runs
      • One-directional / Bi-directional integration
      • Migration vs Integration
      • How Integrations Are Executed By Getint
    • Starting the Free Trial and Accessing the Getint App
      • Selecting the Correct app per license
      • How do I extend the trial of getint.io?
      • Jira Access and User Management
    • Deployment options
      • Getint for Jira Data Center / Jira Server
        • Getint Jira Server / Jira Data Center App (native)
        • Getint for Jira Data Center / Jira Server - Architecture
      • Getint for Jira Cloud
      • Getint On-Premise
        • Architecture
        • Installation
          • How to Install Getint On-Premise in Windows Server
          • On-Premise/Standalone Guide
        • Updating On-Premise
        • Cluster High Availability
    • Prepare for the integration
      • Understanding the difference between platforms you integrate
      • One-to-One, One-to-Many, and Many-to-Many integration
      • Simplifying Workflow Sync with Getint: Jira
    • Connectors
      • Jira
      • Asana
      • Azure DevOps
      • Freshdesk
      • GitLab
      • HubSpot
      • Monday.com
      • Notion
      • Salesforce
      • ServiceNow
      • Zendesk
  • Guides
    • Quickstart
      • Integration
      • Connection
    • Integration Guides
      • How to Map Fields
      • How to create a custom field in all supported software
      • Git Repository integration
        • Git Connector - Azure DevOps
        • Git Connector - GitHub
        • Git Connector - GitLab
      • Azure DevOps Asana integration
      • Jira Airtable integration
      • Jira Asana integration
        • Jira - Asana: Subtasks synchronization
      • Jira Azure DevOps integration
        • How to Setup a Connection with Azure DevOps On-Premise
        • Jira - Azure DevOps: Epics and Subtasks Synchronization
        • Syncing Dependencies between Jira and Azure DevOps using Getint
      • Jira ClickUp integration
      • Jira Freshdesk integration
      • Jira Freshservice integration
      • Jira GitHub integration
      • Jira GitLab integration
        • Attachments Sync in GitLab Integration
      • Jira HubSpot integration
      • Jira Jira integration
        • Jira Jira licensing
        • Time Tracking in Getint – One-Way Synchronization
      • Jira Monday.com integration
        • Synchronizing Attachments in a Monday.com Integration
        • How to Insert Monday.com Items into Specific Groups Using Getint
      • Jira Notion integration
      • Jira Salesforce integration
        • Salesforce OAuth Authentication
      • Jira ServiceNow integration
        • Creating a ServiceNow User for Getint Integration
        • ServiceNow OAuth authentication
        • Creating a Custom Field in ServiceNow
        • How to Restrict "Incident" Data to Specific 3rd Party Companies
        • How to Restrict Access to Specific Tables for Integration
        • REST API requests list
      • Jira Trello integration
      • Jira Wrike integration
      • Jira Zendesk integration
        • How to Manually Provide Zendesk Organization ID and Name
    • Migration Guides
      • Migrating Data with Getint
      • Migration support, and onboarding
      • Jira to Jira migration
      • Asana to Jira migration
      • Azure DevOps to Jira migration
      • GitLab to Jira migration
      • Jira to Monday.com Migration
      • Jira Zendesk migration
  • Using Getint
    • Core Features of Getint
    • Workflows
      • Type Mapping
      • Integrations List
      • Configuring Your Data Sync: Bidirectional and Unidirectional Options
      • Syncing Attachments
      • Hierarchy
      • Assignees (users) mapping
      • Mapping Labels
      • Filtering Items for Integration in Getint
        • Troubleshooting Sync Issues: Unmet Filter Conditions
        • How to Filter Comments
        • Filtering by Assignment Group and Status
      • Shared Mappings in Getint – Centralized Mapping for Efficient Integrations
      • How to Use JQL Filters for Jira Integrations
      • Integration status
      • Storing counterpart link in the task comment
      • Storing Reference IDs/URLs Across Integrations
    • Connections
      • Troubleshooting Getint Integration Connectivity Issues
      • Permissions Issue: Status Code 500
      • Editing Connections for Existing Integrations
      • Changing the URL or Transitioning Between Instances
      • Debugging Connections in Getint: How to Troubleshoot and Resolve Issues
    • Quick Build
    • Reporting
    • Notifications
    • Request type issue on Jira Service Management how to select and work with it
    • Integrating one project with many: Streamlining synchronization across multiple projects.
      • One to Many Project - El Ride Use Case
    • Transition Fields
    • Resync and Hard Resync
    • Synchronizing Existing Items on Both Sides
    • Handling Syncs for Deleted Items
    • Advanced Scripting
    • Platform Release History
      • Getint Version 1.82
      • Getint Version 1.81
      • Getint Version 1.80
      • Getint Version 1.79
      • Getint Version 1.78
      • Getint Version 1.77
      • Getint Version 1.76
      • Getint Version 1.75
      • Getint Version 1.74
      • Getint Version 1.73
      • Getint Version 1.72
      • Getint Version 1.71
      • Getint Version 1.70
      • Getint Version 1.69
      • Getint Version 1.68
      • Getint Version 1.67
      • Getint Version 1.66
      • Getint Version 1.65
      • Getint Version 1.64
    • Settings
      • Data Storage
      • Sharing Access Permission
      • How to Override Getint Behavior Using Custom Properties
  • Support, legal & others
    • FAQ
      • Technical FAQ
      • Security FAQ
    • Troubleshooting Guide for Getint Users
      • Resolving Error 500 in Jira ServiceNow Integration
      • Locating Your Instance ID for Support
      • Connection Error: Certification Path Failed/PKIX Path Building Failed
      • Error: Field '<field-name>' cannot be set. It is not on the appropriate screen, or unknown
      • Connection timed out error
      • Troubleshooting: Integration Task Retrieval Error
      • Upgrade to newest version from version lower than 1.52
      • Debug Requests Feature
      • Troubleshooting: Resolving Hanging Integration Runs in Getint
      • Troubleshooting License Issues in Getint
    • Security and compliance
    • Support / SLA
    • Privacy & Security
      • Data Residency with Getint
    • Procurement & Legal
      • Enhanced Support for Vendor Onboarding and Security Assessments
      • EULA
      • Privacy policy
  • Billing & Services
    • Transparent and User-Friendly Pricing
    • Consulting and Custom Development
    • Understanding Getint Licensing and Pricing
      • How to pay for the apps
      • Migrations
      • Network License
      • Jira-Jira Licensing Model
      • Partners
      • Seamless Transition Offer: Migrate from Competitors to Getint with Exclusive Benefits
  • Use cases
  • Pricing Comparison: Getint vs. Alternatives
  • Battlecards (getint.io vs competitors)
  • Free migration from ConnectAll, Backbone, Exalate, Unito, Workato, TFS4JIRA and other tools
  • Anything missing? Getint is feedback driven
Powered by GitBook
On this page

Was this helpful?

  1. Using Getint
  2. Workflows

How to Use JQL Filters for Jira Integrations

In this guide, we will explore how to use Jira Query Language (JQL) filters to enhance and customize integrations with Jira. JQL is a powerful tool that helps build structured queries for better data management and synchronization between tools. By leveraging JQL, you can create highly specific queries that help streamline the flow of information between integrated systems, ensuring that only the most relevant issues are synchronized according to your workflow needs.

However, JQL is just one of the filtering options available. We encourage users to also explore the filtering capabilities provided through the Getint user interface (UI). In this guide, we'll explain how to use JQL for filtering, compare it to UI-based filtering, and discuss how Getint approaches these filtering methods.

What is JQL?

Jira Query Language (JQL) is a flexible query language used to search for issues in Jira. It allows you to build custom queries using fields, operators, keywords, and functions, which helps filter the right data to be synced during integrations. This advanced search capability is handy for large projects or teams with complex workflows.

Why Use JQL for Integrations?

  • Enhanced control: By applying JQL filters, you can sync only the relevant issues between Jira and other platforms.

  • Custom synchronization: JQL filters allow you to create conditions such as syncing by assignee, status, due date, priority, or any custom fields.

  • Improved efficiency: Filtering reduces data fetching and decreases processing time by applying conditions, such as JQL filters, on the Jira REST API side, instead of fetching a broader range of results and filtering them with UI filters (link here) by Getint., speeds up syncs, and minimizes potential errors.

Setting Up JQL Filters for Integration

Here’s how you can set up a JQL filter for your Jira integration:

  1. Navigate to the Integration Setup:

    • Open the Getint app.

    • Go to the Workflows section, and locate the integration you want to configure.

  2. Access JQL Filters:

    • Once you’ve selected your integration, select the Jira app.

    • Look for the Custom JQL Filter field.

  1. Writing Your JQL Query:

  • In the JQL filter field, you can define specific criteria for your integration. Here are some common JQL queries you might use:

  • Filter by Status:

    status = "In Progress"

    This query will sync only the issues that are currently marked as “In Progress”.

  • Filter by Assignee:

    assignee = "jsmith"

    This query will sync issues assigned to the user jsmith.

  • Filter by Priority:

    priority = "High"

    This query will sync only the issues with high priority.

  • Combine Multiple Conditions: You can combine conditions using operators like AND, OR, and parentheses:

    project = "PROJ" AND status = "In Progress" AND assignee = currentUser()

    This query will sync only the issues from the project "PROJ", which are in progress and assigned to the currently logged-in user.

  1. Apply the Filter:

  • Once you have written the JQL query, click Close and Save the integration to activate the filter.

  • The integration will now sync only the issues that match your JQL query.

Examples of Advanced JQL Queries for Integrations

  • Sync by Custom Field:

    customField_12345 = "Critical"

    Sync issues where the custom field with ID 12345 has a value of "Critical".

  • Filter by Date Range:

    created >= "2024/01/01" AND created <= "2024/12/31"

    Sync only issues created within the year 2023.

  • Issues with Open Pull Requests:

    development[pullrequests].open > 0

    Sync only issues that have open pull requests linked to them.

Best Practices for JQL Filtering

  • Keep queries simple to avoid performance bottlenecks.

  • Test your JQL query in Jira’s advanced search feature before applying it to an integration.

  • Use specific criteria to narrow down the number of issues synced. This reduces load and speeds up synchronization.

  • Avoid unnecessary complexity by using common fields like status, assignee, and priority for the most relevant filtering.

Limitations

  • Text fields like Summary or Description may require special operators like ~ for partial matches (e.g., summary ~ "error").

  • Reserved words and special characters may require additional syntax such as quotation marks.

Verifying Your JQL

To ensure your JQL query is correctly scoping to the tickets you want, you can take the JQL and test it directly in Jira. This allows you to see the exact issues that match your query before applying it to your Getint integration. By doing this, you can be confident that your query will return the desired results when used to filter issues during synchronization.

Automatic Addition of Project and Issue Types

One of the conveniences provided by Getint is that project and issue types are automatically added to your query. This means that when you create a JQL filter within Getint, you don't need to manually include these elements in your query—they are automatically appended, ensuring that your filters are scoped correctly to the relevant projects and issue types.

UI-Based Filtering

While JQL offers a high degree of customization, Getint also provides a user-friendly interface for filtering issues. The UI-based filtering option allows you to select filters through dropdown menus and checkboxes, making it accessible for users who may not be familiar with JQL syntax. This method is ideal for quick setups and less complex filtering needs.

Comparing JQL vs. UI-Based Filtering

  • Flexibility: JQL is more flexible and allows for more complex queries, making it ideal for advanced users who need precise control over their data synchronization.

  • Ease of Use: UI-based filtering is easier to set up and doesn't require knowledge of JQL syntax, making it more accessible to a broader range of users.

  • Performance: Depending on the complexity of the JQL query, filtering via the UI might offer quicker setup and execution times, especially for basic filtering needs.

Getint's Approach to Filtering

At Getint, we understand that different users have different needs. That's why we offer both JQL and UI-based filtering options. For users who require advanced, granular control over their integration rules, JQL is the recommended approach. For those who prefer a simpler, more intuitive setup, our UI-based filtering provides a quick and efficient way to manage data synchronization.

We encourage customers to experiment with both methods to find the best fit for their specific use case. Testing filters via the UI can provide immediate feedback and is a great way to refine your filtering criteria before applying more complex JQL queries.

Conclusion

Both JQL and UI-based filtering offer valuable tools for managing your Jira integrations. By understanding the strengths and differences of each method, you can choose the one that best aligns with your workflow and integration needs. Whether you're syncing issues between Jira and ServiceNow, Azure DevOps, or any other platform, Getint provides the flexibility and power to ensure your integrations work seamlessly.

PreviousShared Mappings in Getint – Centralized Mapping for Efficient IntegrationsNextIntegration status

Last updated 7 months ago

Was this helpful?

Before finalizing your JQL query within Getint, we recommend testing it in Jira to verify that it scopes to the exact tickets you need. For additional support, visit our .

Help Center
UI filter