Query for Jira tickets with Figma designs attached

[Matt Meeks]

We're using the Figma for Jira app to attach Figma designs to the stories that need designs. I want to create a query in Jira to show stories that have or do not have designs attached, but I can't find a way put the design field into the query. 

[Manuela Miksa]

Hi @Matt Meeks 

You should be able to do this via JQL with the following search parameter:

design[totalCount]>=1 order by created DESC

will return any issue that has at least 1 design attached

design[totalCount]=0 order by created DESC

will return all issues that have no design attached, but you might want to do more filtering there

[Matt Meeks]

Yes, I should be able to do that, but it doesn't work for 

design[totalCount]=0 order by created DESC

Maybe because the design field doesn't exist until the user clicks the "Design" button in the story?  

[Matt Meeks]

@Manuela Miksa I just did some testing, and it turns out that both queries actually DO work, but for some reason, design[totalCount]=0 only works in one project and doesn't work in the project that I need it to. Yet the design[totalCount]>=1 DOES work in that project. So I guess I need to open a ticket with my IT department.

[Hariharan Iyer]

Hi @Matt Meeks ,

I think this is not possible out of the box in JQL. One option would be to create an automation to add a label like "figma-attached" to the issue using the "when: design linked to an issue" trigger. Then you can use the labels NOT IN (figma-attached') clause in JQL to fetch such issues.

Hope that helps!

[Matt Meeks]

I think that's what I'm going to try. It's a bit hacky and more involved than I'd like, but it seems like the best solution at the moment. I just need to get permissions for the engineering project to be able to do that. We use a UX project to manage our design stories and relate those stories to the engineering story, and I only have admin access for the UX project.

[Hannes Obweger - JXL for Jira]

Hi @Matt Meeks,

if you're open to solutions from the Atlassian Marketplace, this would be easy to do using 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. For attachments, JXL offers a text search in which you can simply search by the file name or file extension, or even regular expressions for more complex use cases.

This is how it looks in action (I don't have a Figma file in my Jira site, so using Sketch instead):

I should add that JXL can do much more than that: From support for configurable issue hierarchies, to issue grouping by any issue field(s), sum-ups, or conditional formatting.

Any questions just let me know,

Best,

Hannes

[Matt Meeks]

Thanks, but there isn't a budget for paid extensions.

[Charlotte Santos -Appfire-]

Hi @Matt Meeks 

I’m Charlotte, a support engineer at Appfire and I’m here to help you.

Unfortunately, using vanilla JQL, you’ll not be able to do it dynamically.

In the app where my team works, JQL Search Extensions for Jira, you can use this query to find issues that have Figma designs attached:

attachmentExtension = fig

Please contact our support if you have any other questions about this query.

We’ll be happy to help you!