You're on your way to the next level! Join the Kudos program to earn points and save your progress.
Level 1: Seed
25 / 150 points
Next: Root
1 badge earned
Challenges come and go, but your rewards stay with you. Do more to earn more!
What goes around comes around! Share the love by gifting kudos to your peers.
Keep earning points to reach the top of the leaderboard. It resets every quarter so you always have a chance!
Join now to unlock these features and more
Hi Everyone!
Background: using {{lookupissues}} in automation for slack messages in a variety of ways but have been unable to figure out how to successfully utilize the distinct function to remove duplicates for a text-based custom field
(documented here under list.distinct)
Closest thing I have found on the community is (Automation distinct and formatted ) but to be honest it's a bit over my head and really looking for some help!
Example:
Any insight and help is greatly appreciated, I've spent many hours trying a lot of stuff unsucccessfully.
The lookupIssues function doesn't contain custom fields. it only has a few fields that you can reference (see: https://support.atlassian.com/cloud-automation/docs/jira-smart-values-issues/#Available-properties)
You will have to build your list some other way than lookupissues. Once you have that, then you can use the split with the distinct function that I mentioned in the other solution:
bummer on the custom fields but much appreciated for your help and quick reply!
I'll think through how/if I can tackle this another way.
Cheers
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
To clarify a little, I thought the custom fields wouldn't be supported due to that documentation but I am able to output a list with {{lookupIssues.customfield_16574}} .
It's just the distinct aspect that isn't working
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Ok... Then try adding the lookupissues to a variable "myList" like this notice the comma on the end:
{{#lookupIssues}}{{customfield_16574}},{{/}}
Then using that variable "myList" create another variable "myDistinctList":
{{myList.split(",").distinct}}
Maybe that will work?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Glad I could help!
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hey Daniel - Can you publish your actual rule with the code showing so future people looking here can see the solution you used? Thanks!
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Certainly!
customfield_16575 refers to locations, I'm also messing around with the inputting "not specified" for invalid references - when testing I found that if customfield_16575 was left blank I would get some wonky results, e.g "America, Mexico, , Canada"
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Awesome - thanks for sharing that!
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hey Daniel,
I have not tried the function before, but looking at the documentation, maybe try this:
{{lookupIssues.customfield_16575.split(",").distinct}}
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
no dice, that ^ actually returns a blank message but I do appreciate the attempt!
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.