Import using JQL

Read about how you can import against a stored JQL query in Avion.

If you haven't yet read our primer on importing, check it out before you read on.

Importing

Our Jira integrations allow you to store a JQL query, which Avion will use when you import data. This can be used to reduce the amount of noise in the story map, or simply to only import what is really required.

To enable JQL for imports, head to the configuration panel and select it from under Importer options.

Please understand that the JQL is taken completely literally. This can occasionally product unexpected results. Read more.

If you are fluent in JQL, you might have some great ideas on how to get the most out of this already. Here are a few ideas of our own.

Filter by label

Only import issues with the label For-Avion.

labels in ('For-Avion')

Filter by created today

Only import issues that were created today.

created > startOfDay(-0d)

Filter by created this week

Only import issues that were created this week.

created <= startOfWeek(5d)

Filter by updated today

Only import issues that were updated today.

updated > startOfDay(-0d)

Filter by updated this week

Only import issues that were updated this week.

updated <= startOfWeek(5d)

Filter by assigned to a specific user

Only import issues that are assigned to Bill Gates.

Assignee = 'Bill Gates'

Filter by issues with an empty description

Only import issues with no description (ready for planning in Avion).

description is EMPTY

Filter by issues in a specific status

Only import issues with a status of For Avion.

Status = 'For Avion'

JQL cheatsheet

JQL (JIRA Query Language) Cheat SheetCheatography