Query for Jira tickets with Figma designs attached

Matt Meeks February 20, 2024

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. 

4 answers

1 vote
Manuela Miksa February 27, 2024

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 February 27, 2024

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 February 27, 2024

@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.

1 vote
Hariharan Iyer
Atlassian Team
Atlassian Team members are employees working across the company in a wide variety of roles.
February 20, 2024

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 February 21, 2024

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.

0 votes
Hannes Obweger - JXL for Jira
Marketplace Partner
Marketplace Partners provide apps and integrations available on the Atlassian Marketplace that extend the power of Atlassian products.
February 21, 2024

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):

attachment-type-search.gif

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 February 21, 2024

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

0 votes
Charlotte Santos -Appfire-
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
February 21, 2024

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!

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
STANDARD
TAGS
AUG Leaders

Atlassian Community Events