Hi all, I noticed I can pull assignee but not the date of the most latest assignee. Is there someway I may have missed it within the Structure Documentation, or is the meta data not really available?
I assume its probably available via an API call but I was hoping for something to use within "Jira Structure".
Alternatively I may just create a field for this and use an automation to auto update it with a date/time each time a new user is assigned and use that value but I was hoping to get away from an automation for each project.
Thanks!
Hello Calvin !
It looks like you are using Structure for an onprem hosted instance of Jira. Since this is the case, you can reference the History in a Formula.
Please try adding a new formula column and use this:
history.changes
.FILTER($.field = "assignee").changegroup
.LAST().timeperformed
It filters the history events where the assignee was changed. It then filters it again to the last time that the field was changed and returns the date/time it was done.
You will just need to make sure to set the formula's formatting option to Date/Time.
Please let me know if it helps!
Best,
David
Incredible answer and documentation/links for me to check out. Worked great. Thank you so much!
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You are very welcome! Glad to hear it worked for you :)
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.