Notification at slack - using smart variables

Hugo Moraes Neto_081h6u

Hi folks, I'm trying to notify my team via Slack about issues stuck in a specific column.

The alert is daily:

 

 

The problem is that I define the text for the notification as:

"Today we have {{issueList.size}} issues stuck in the status 'Awaiting Code Review'"

{{#lookupIssues}}
{{url}} | {{summary}} | {{now.diff(issue.status.lastUpdated).days}} dias.
{{/}}

 

The variables {{issueList.size}} and {{now.diff(issue.status.lastUpdated).days}} are not being displayed.

 

can your help me please

Bill Sheboy

Hi @Hugo Moraes Neto 

I noticed a few things in your use of Lookup Issues that might help...

(1) The results of Lookup Issues is a list, and so use the size function to learn how many results there are for the JQL.  I recommend this, as it includes a default value of 0

{{lookupIssues.size|0}}

(2) As your lookup could be empty, I recommend adding some conditional logic to handle that case before sending the Slack message.

(3) I do not believe there is a field for the last update to a status which is available.  Do you have an add-on for JQL that provides that?  If not, you could modify your JQL and smart values to use either the Updated field or change the query to look for issues where the status has not CHANGED within a certain timeframe.  For example: 

project = myProject AND status = myStatus AND NOT Status CHANGED AFTER -2d

(4) Finally, when a rule is inside of an iterator like for Lookup Issues, you only need to use the field names and not the prefix issue.  In fact, inside the other rule information is not visible at that scope.  For example:

{{#lookupIssues}}
{{url}} | {{summary}} | {{updated.diff(now).days}} dias.
{{/}}

Please try those things to see how they help.

Kind regards,
Bill