setting up a jql for autmation notificaitons

[Jon]

hi, im trying to set up a notification and it works when I put it in my filter screen but on the audit screen it shows some error. what does this mean, how do I fix it? 

[John McKiernan · Accepted solution]

Hi Jon,

This rule all looks good except for the smart value you used in your 'send email' action.

You have {{Booking No.}} sailed and OK to invoice.

Assuming 'Booking No. is a custom field - you will need to use this format: {{issue.Custom Field.value}}

so in your case, it would be {{issue."Booking No."}}

note: I have put inverted commas around "Booking No." because it has a full stop at the end.

Let me know if that solves the problem for you.

Cheers,
John

[Jon]

Thanks, works. 

[John McKiernan]

Good to hear Jon, reach out if you have any other questions.

Cheers,

John

[Jon]

hi john, I tried to do some other fields. the odd thing is some worked but some did not and I feel I did the same thing.

here is what I added. 

SUBJECT: Shipment Notification WHEATON GRAIN Booking {{Summary}}, COMMODITY: {{issue."Commodity"}}, Contract {{EPIC LINK}}, ETD {{issue."ETD"}}

CONTENT

Booking: {{Summary}}
SSL: {{issue."SSL"}}
QUANTITY: {{issue."MT LOADED"}}  MT
COMMODITY: {{issue."Commodity"}}
Contract {{EPIC LINK}}
ETD: {{issue."ETD"}}
ETA: {{issue."ETA"}}
VESSEL: {{issue."Vessel"}}
PORT OF LOADING: {{issue."Port of Loading"}}

AND this is what I got. The Commodity is not working and I cant figure out why. And how do I put the epic link in the code? It showed up as the key but I would rather have the epic link which is an important number for me cause its the customer reference number. 

Subject: 

Shipment Notification WHEATON GRAIN Booking 038CHI1561817, COMMODITY: {self=https://wheatongrain.atlassian.net/rest/api/2/customFieldOption/10134, value=Soybeans, id=10134, child={self=https://wheatongrain.atlassian.net/rest/api/2/customFieldOption/101...

Content: 

Booking: 038CHI1561817
SSL: MSC (Med)
QUANTITY: 105.255
COMMODITY: {self=https://wheatongrain.atlassian.net/rest/api/2/customFieldOption/10134, value=Soybeans, id=10134, child={self=https://wheatongrain.atlassian.net/rest/api/2/customFieldOption/10136, value=#1, id=10136}}
Contract ES-6
ETD: 2018-08-21
ETA: 2018-09-30
VESSEL: MAERSK ANTARES 834S
PORT OF LOADING: Prince Rupert

[John McKiernan]

Hi Jon, 

It looks like Commodity is a cascading select field. 

So, with this in mind, you will need to specify the child value.

For example: 

{{issue.Commodity.value}} - {{issue.Commodity.child.value}}

will print: 

Soybeans - #1

Also, just to save you time, you only need to put the inverted commas around the smart values if there is a full stop at the end.

For the Epic link - {{issue.parent.Epic Link}} should print correctly for you. 

Hope that helps!

John 

[Jon]

Thanks 

is is there a way to add a field from the epic itself to the issue it is linked to? The epic link is the contract, and I’d like to put the customer on the notification as well if possible. 

[John McKiernan]

Hi Jon, 

The Epic Link will just print out the value so you need to pull a field from the epic. 

To do this - we need to add something like this:

{{issue.epic.custom field name}} 

Hope that helps,

John

[Jon]

hi john, do you know how to set up this for the status field? I did {{status}} and came up as "10002" but the status on the issue is custom to be either "Loaded" or "Sailed"

[John McKiernan]

Hi John, 

we have actually just published a blog which helps you find the smart values you need. I think it would be a really useful read for you:

 https://blog.codebarrel.io/how-to-use-smart-values-in-automation-for-jira-15edddfb8c7c

With regards to your question here, you will need to use {{status.name}}

By using the child 'name' - it should print out "loaded" or "sailed" rather than "10002"

Cheers,

John

[Jon]

Hi John, 

I have another automation with some different fields that do not work. Do you see anything wrong with these? I followed the same logic or think I followed the same logic on other similar fields you helped me with before. 

Origin Place of Receipt and RR: {{issue.Origin POR and RR.value}} -  {{issue.Origin POR and RR.child.value}}  
Load Order Container Count: {{issue."LO Cont. Ct"}}

[Iago Docando · Accepted solution]

<edited>