In Jira, make a reference to an item from a table

In Jira, I would like to create a table (in the sense of a database table)  of products, so that each product has a number of fields, and there is a screen to fill in these fields.

In my issues (e.g. bug reports) I want to be able to add a reference to a product from that table.

I assume that to maintain that table of products, I shall create a separate issue type.

But then, I how do I create a field that is a reference to an issue of another type?

1 answer

This widget could not be displayed.
Gaston Valente Community Champion Oct 31, 2017

Jennifer,

i think you need to create an issue type for each group of products with the same field scheme.

then you can obtain the name of the concrete product from the db using a custom field designed to do that such as database custom fields for example 

Thank you, Gaston,

How do I create a custom field that contains references to products?

I have seen articles related to "Query issue related custom field", which is a part of a plugin, "Query Issues Custom Fields". However, I don't find it in the marketplace. I have googled up a link,  https://marketplace.atlassian.com/plugins/ru.mail.jira.plugins.lf.queryfields/server/support , but it is dead. Maybe that plugin is removed?

I think my problem should be quite common, and it is strange that I don't find a simple solution...

This is one of the use cases supported by the Table grid editor

 

Check also the documentation around the 'product list' use case 

 

Let me know if it helps

 


Francis

Thank you Francis,

I have installed and tried the Table Grid Editor. I don't find a way to make it do what I need.

AFAIU, Table Grid Editor lets you insert a table, which is fed from an external database.

While I need a dropdown field, whose values are built by a query on a table from the JIRA database.

Can it be done using Table Grid Editor?

https://marketplace.atlassian.com/plugins/ru.mail.jira.plugins.lf.queryfields/overview is back to life, and it does the job. 

Nevertheless, it's all too complicated. I compare it to venerable ClearQuest. It has "stateless" records, which are saved as tables in the database. You can  use queries on these tables to populate lists of values. In Jira, I have to create a special issue type and work hard to get rid of most standard fields and states.

Isn't there a better solution?

Suggest an answer

Log in or Sign up to answer
Community showcase
Published Friday in Jira

New 5k User Limit and Other Cloud Updates

Hi all! Lauren here from the Enterprise Cloud marketing team.  I have some exciting Cloud updates from #AtlassianSummit that I wanted to share. We want everyone in your organization to be ab...

119 views 0 3
Read article

Atlassian User Groups

Connect with like-minded Atlassian users at free events near you!

Find a group

Connect with like-minded Atlassian users at free events near you!

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you