Automation to fill insight field in issue automatically

[Janis Pirgge]

Hi Community,

I'm trying to set up an automation, which automatically fills out:

1. insight field in an jira issue based on the selected value of an other insight field.

2. The organization based on an insight field.

I have the following use case:

In the jira service management tickets the service team member shall select the affected system in the field system. The field is an insight objects field.

When the value of the field is changed an automation rule should start, which look ups the insight objects of the specific obejcttype "System" an searches for the Attribute "Kennzeichen" = "UML-Test-RTW" (the selected system).

It shall pick the referenced object "Kunde" and paste it in the insight object field "kunde" of the issue.

Unfortunatly i wasn't successful so far. My automation looks like that:

Thanks for your help!

BR

Janis

[Janis Pirgge · Accepted solution]

Hi,

I now was able to get the correct query for the lookup object: 

The query delivers the attribute "Kunde" of the object, which was selected in the field "System" ("UML-Test-RTW").

After a few tries, i was able to find the correct statement, which pastes the attribute value in the field "Kunde".

Maybe this will help someone else. ;-)

BR
Janis

[Jaime Gonzalez]

Hello, I am trying to achieve this during issue create, via webhook trigger. Following your recommendations, I am able to query the object using the name and the Lookup Objects action. However, when attempting to set the value during the issue create acton, the insight field is not set:

Any ideas? Thank you

[Janis Pirgge]

Hi Jaime,

I had some problems with my first solution so I talked to the atlassian support. 

Here is the rule, which finally worked. Maybe this helps you too. The log actions are really helpful for problem analyzation:

{{issue.system.label}} Value: {{#issue.system}}"{{label}}",{{/}}

{{test.substringBeforeLast(",")}})

objecttype in objectTypeAndChildren(18) AND ("kennzeichen" IN ({{test.substringBeforeLast(",")}}) OR "Name" IN ({{test.substringBeforeLast(",")}})) 

Maybe this will help you somehow.

[Jaime Gonzalez]

Hi @Janis Pirgge thank you very much for responding to my question.

Following your suggestions, I realized it was not working for me as I was attempting to set the insight field within the webhook trigger rule, which apparently is not possible, because there is no reference issue at this point.

What I ended up doing, is create a 2nd rule that triggers after the webhook creates the issue, and then set the insight field there, using the value of the Affected Hardware field, that was previously filled by the 1st automation rule, using data from the webhook.

I hope this makes sense for other running into the same issue.

Thanks again for your support, have an excellent day!

Jaime.

[Deleted user]

is this also for jira datacenter ?

[Janis Pirgge]

@[deleted]  in the latest newsletter they said, that Automation for Jira will be included in Data Center in the next few months. So I would say, as soon as this happens it should also work for data center. 

[Sergei Gridnevskii]

Strange,

When I set an Insight field from another field it works fine.

Key="{{customField_14472}}"

When I set it using text I get Internal Server Error.

Name LIKE "{{approle.Role.Name}}"

My head is going to blow up.

[Sergei Gridnevskii]

Finally I found an answer. The post should be like this:

"customfield_14472": [{"workspaceId":"e02eca9b-beba-4406-bcbc-6c95dcb24212","id":"e02eca9b-beba-4406-bcbc-6c95dcb24212:8155","objectId":"8155"}]

How to get workspace ID?

Set the field in the issue manually and then go to 

https://<yourcompany>.atlassian.net/rest/api/latest/issue/<issue_key>

Search for custom field number. You will see the record like above.

How to set object by Key?

Just remove the first letters and dash. My object was AR-8155, so I used 8155.

[Rilwan Ahmed]

Try automation rule "Issue updated"