Compare the same custom field value in different issues

[Vahagn Beglaryan]

Hello smart people.

How to compare the same field value in different issues? For example when issue is created, the system should look up in issues opened in the last 24 hours and if there any issue with the same field value which has triggered the rule, return us the issue and then we can set some actions.

If there is any method, please help.

Thanks in advance.

[Nikos Sotirakos]

Hello all,

I have a same case to create an automation rule in our company's projects. We want, if a customer creates within the same day two tickets, to be assigned both of them to the same agent to handle. Assuming that we distinct our customers with a custom field named VAT.  What the JQL query would be, in order just to check from that custom field?

[Simeon Leatherland]

Hi there,

@Alex Koxaras _Relational_ is on the right track. Assuming the client will always be set on the same custom field you will be able to dynamically compare the custom field in the ticket created to issues in the JQL condition query as below.

Please let me know if you have any further questions.

Cheers,
Simeon

[Vahagn Beglaryan]

Hi dear Simeon,

Thanks for your reply, Jira should look up and compare the custom field value not in trigger issue but in issues which were opened in the last 24 hours.

example

We have a ticket with customfield a = 1 which is created now (key =test-1)

1. after 12 hours a new ticket (key = test-2) is created with the same  customfield a = 1 and automation should take actions. (because there was a ticket with the same cf value and opened during last 24hours)

2. in the same time an other ticket (key = test-3) is created and customfield a = 2 , then the automation shouldn't work. (because there was not any ticket with the same cf value in the last 24 hours)

Thanks in advance

[Alex Koxaras _Relational_]

Hi @Vahagn Beglaryan and welcome to the community!

WHy you don't use a Jira Automation (if you have it installed on your instance)?

• Trigger "On create issue"
• IF statement with JQL
• Some action

This is quite a simple rule, but I don't know if you has something else in your mind. 

[Vahagn Beglaryan]

Hi Alex, thanks for the reply. It doesn't solve our problem as we want to use it with custom fields. For example, when created an issue with cf xxxx value yyyy, the rule should look up if there is any ticket created in the last 24 hours with the same cf xxxx value yyyy, *values* can be different.

[Vahagn Beglaryan]

if look up cf value equals created issue cf value the returns true

[Alex Koxaras _Relational_]

Hi @Vahagn Beglaryan apart from the fact that I've forgotten to put the time constraint of the issue creation, which would be the following:

clients = "SPEK" AND (created >= -24h AND created <= now())

I'm not sure I understand what exactly you want to search. You mean that you want to search for an array of values?

[Vahagn Beglaryan]

Hi dear @Alex Koxaras _Relational_

The question is that our "clients" can be different,

Client "a" opened a ticket, system should check if there is a ticket opened in the last 24 hours by client "a" and should take an action,

Clients can be different, so "a"=x, we can't set clients custom field in automation, there can be different values.

Thank you.