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

Question

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?

Jennifer Philips · Answer

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?

Jennifer Philips · Answer

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?

francis · Answer

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