How can I count the number of open issues and comment that on a newly created issue?

Will Fieldsend

I want to count the number of open issues and then add that to a comment telling people where they are in the queue. 

So far in my automation I have 

---

Trigger - Manually triggered (this is just for testing I will change it to "Issue created" later)

Then: Lookup issues. Search for issues using JQL "resolution = Unresolved AND Status != Pending".
(I have clicked "Validate issues" and it correctly says "9 issues found")

And: Create variable. Variable name "OpenIssueNumber". Smart value "{{OpenIssueNumber.count}}"

And: add comment to issue: "Hi, there are {{OpenIssueNumber}} open requests ahead of yours."

---

I would expect this to add a comment saying "Hi, there are 9 open requests ahead of yours." But instead it is saying "Hi, there are  open requests ahead of yours."

Where am I going wrong?

Paul Wiggers

Hello @Will Fieldsend 

It looks like you are using the wrong smart value. You can access your results with {{lookupIssues}} and the incorrect count option. You need to use size to get the number of items in the result.

There is no need to create a separate variable here but if you want you need to change the smart value to {{lookupIssues.size}}

Otherwise, just add a comment with: "Hi, there are {{lookupIssues.size}} open requests ahead of yours."