Automation error - limit reached

[Anna Machala]

Hi there!

I started using Jira yesterday. I've created an automatic role which sends an email notification to the assignee once a day, at a specific time, from Monday to Friday. 

First I got a problem that it won't send an email until I put a specific email address manually.

I was changing some settings to try and make it work but I triggered it only around 10 times.

Now I'm getting an error: com.codebarrel.automation.component.outgoing.email.action.global.error.limit 

The limit for Free Plan is 100 per day so I shouldn't be out of quota.

Have you got any idea why that's happening? 

Thanks!

[Gaston Valente]

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 

[Jennifer Philips]

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

[francis]

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

[Jennifer Philips]

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?

[Jennifer Philips]

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?