Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in
Deleted user
0 / 0 points
Next:
badges earned

Your Points Tracker
Challenges
Leaderboard
  • Global
  • Feed

Badge for your thoughts?

You're enrolled in our new beta rewards program. Join our group to get the inside scoop and share your feedback.

Join group
Recognition
Give the gift of kudos
You have 0 kudos available to give
Who do you want to recognize?
Why do you want to recognize them?
Kudos
Great job appreciating your peers!
Check back soon to give more kudos.

Past Kudos Given
No kudos given
You haven't given any kudos yet. Share the love above and you'll see it here.

It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

Jira Structure Formula User (Assignee) Full Name

I defined a formula in Jira Structure as follows:

CASE(issuetype, 'Sub-task' , assignee,'' )

In words: If the issuetype of current issue is Sub-task I want to display the assignee.

 

The Problem is that the usertag is displayed and not the full name.

Is there a possibility to display the full name of the assignee in the formula?

1 answer

1 accepted

1 vote
Answer accepted

Hi Max,

There is a trick, that can let you retrieve the full name. Not very elegant, but it should work. The formula should be as follows:

with v_ind=SEARCH('link">', assignee)+5:
with v_start=SEARCH('">', assignee, v_ind)+1:
with v_end=SEARCH("</a>", assignee)-1:
with v_assignee=SUBSTRING(assignee, v_start, v_end):
CASE(issuetype, 'Sub-task' , v_assignee,'' )

One more thing, assignee variable below formula needs to be changed to Manual Specification, which should be modified to {"id":"assignee","format":"html"} from {"id":"assignee","format":"text"}

Regards,
Egor Tasa

ALM Works

Perfect THX!

Is there a special docu for stuff like this?

Hi @Max 

This is more of a trick than a normal solution, so there is no docs. We hope to introduce a more comfortable solution to this kind of thing in the future.

Regards,

Egor

Like Max likes this

Hi @Egor Tasa _ALM Works_ ,

I've used your formula and it works perfectly for us. But while grouping the issues, is there any way where I can display the aggregation of usernames in the grouped field?

My Use Case:

I'm displaying Product owner names in structure and grouping the issues based on Teams (custom field). Aggregation of all the Product owner names should roll up to the Teams field.

Thanks,

Poojaa

Hi Poojaa,

If I understand the described requirement correctly, then when you group by Team field, you can add a formula 

JOIN#subtree#distinct{SUBSTRING(assignee, SEARCH('">', assignee, SEARCH('link">', assignee)+5)+1, SEARCH("</a>", assignee)-1)}

Cannot use variables here because of aggregate construct, though.

If your requirement is grouping when multiple users can be assigned to a single field, then this cannot be solved at the moment, as formulas cannot yet work with lists (we are planning to introduce it soon).

Regards,

Egor

Thanks @Egor Tasa _ALM Works_ ,

This worked for me.

Regards,

Poojaa

Like Egor Tasa _ALM Works_ likes this

I have forgotten that in Structure 6.0 one can use USER_NAME(user) function instead of having to modify format and parse results.

So for instance latest formula will be much more simple

JOIN#subtree#distinct{USER_DISPLAY_NAME(assignee)}

Regards,
Egor

Like Daniil Pronin likes this

Suggest an answer

Log in or Sign up to answer
TAGS
Community showcase
Published in Marketplace Apps & Integrations

Jira issue check and more advanced commit verifications for Bitbucket DC

Pre-receive hooks that verify the Git commit message, the modified files, and implement similar code change controls used to be requirements of large enterprises working in regulated industries only....

42 views 0 2
Read article

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you