Structure: How to search the history of each issue for assignees

peter_dickermann

In a structure, I want a list of all users who have ever worked on a project within a certain time period. I.e. if in the course of a story a total of 3 people have worked on it, then I want to see the number 3. So I need to search the history of each issue by user

David Niro

Hello @peter_dickermann ,

David from ALM Works here. .

Assuming you are utilizing Jira's time tracking, you can use a formula like this:

SIZE(UNIQUE(
worklogs.FILTER($.MAP(DAYS_BETWEEN($.created,today())<30)).author))

The worklogs.FILTER part identifies the worklogs array and filters out the records that were created in the past 30 days, then returns the author of the worklog. (you can adjust the 30 to meet your desired timeframe).

The UNIQUE & SIZE part looks at the new filtered array and then counts each unique occurrence of the author.  So, if you have the same person log several pieces of work during the timeframe, it will only count them once.

If instead you wanted just a list of names of the people who worked on the issue, you can drop the SIZE piece of the formula.  It would look like this:

UNIQUE(
worklogs.FILTER($.MAP(DAYS_BETWEEN($.created,today())<30)).author)

Please let me know if this helps.

Best,
David