Questions about Lookup tables? And help with a load based ticket automation

Question

Hi all,

I've been asked to create a load based automation slightly different from the load based one that Atlassian currently offers.

Basically, the user wants the tickets to have a "weight" based on a field that they enter, called "complexity".

Weights are 1,3,5,etc.

They would also like the automation to not assign tickets to users if their ticket load is over 30.

I've been messing with jira smart values and jql summaries for a bit and was wondering what the best way to do this would be.

I'm currently stuck with a lookup table to reference all of the jql for the first user

the value is {{assignee = (firstuserid) AND "Complexity[Dropdown]" = Complex}}

This is the jql query that will tally how many work item issues are assigned to each user based on complexity, so that I can do the math for the weight load with it and not assign it to the user if the weight is above 30.

I've tested it to comment on the work item, but it says that the value is empty.

I've also tried it with the raw JQL but it just returns the string of the actual JQL instead (assignee = (firstuserid) AND "Complexity[Dropdown]" = Complex)

I think the jql I'm putting in might be wrong or might not be able to be parsed by the lookup table, but any help is appreciated thank you!

Bill Sheboy · Answer

The values for your Lookup Table are incorrect: they cannot dynamically lookup work items (formerly called "issues") for a user when the table is created.  Instead...

To get the work items assigned to the person who triggered the rule, first use the Lookup Issues action with JQL.  For example:

* trigger: value changes for Complexity
* condition: Issue is unassigned
* action: lookup issues, with JQL of the following.  Please adjust to meet your scenario.* assignee = {{initiator.accountId}} AND statusCategory != Done

Then create your lookup table to count the values in the Complexity field for that user's work items, using the match() function to find them and the size function to count the matches.

Assuming the field's smart value is "complexity" and it is single-select, this would work.

* action: create lookup table* name: varIssueCountByComplexity* row* key: Complex
* value: {{lookupIssues.complexity.value.match("(Complex)").size}}

* row* key: Detailed
* value: {{lookupIssues.complexity.value.match("(Detailed)").size}}

* repeat for other values...

Finally, use the table to get the counts for the trigger's issues Complexity value:

Evan Kaung · Answer

Hey Bill,

Basically when the field "Complexity" changes value (manually by a user), and the issue is unassigned, the lookup table will automatically grab all of the agent's tickets and then see if the weight is over a number, at which point they will be assigned a ticket or not.

Right now it's just in a testing phase right now so it'll just leave a comment-

In the lookup table I'm trying to get the number of tickets that a user has been assigned with the complexity of a specific value. So for instance, assigned to John Smith and then a complexity of "complex" as an int.

Once that's done I'll do math with it to calculate the weight of the tickets to see if the user can be assigned a ticket or not but right now I'm a bit stumped on how to grab the number of tickets with that field assigned to the user with the conditional expressions on the table as it seems like it only does true/false statements.

Best regards,

Evan

Evan Kaung · Answer

Hey Fernando,

Thanks for the help!

In this case I would need to grab the number of issues assigned to a specific user with that field being a specific value. Is there any way I can do this with smart values?

Looking at the documentation linked by Bill I can only see true/false conditional logic.

Best regards,

Evan