nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Assignee using Formula in structure

sarathgd

Hi,

I have a structure with one of column as Assginee, which I am able to pull the data into the structure.

If I'm trying to build a formula if there is an assignee and expecting to get the name of assignee against the issue type. If there is no assignee against to that issue type i want to populate 'No Assignee'. I am trying to use below formula but I am not getting the name of the assignee though assignee name is there against to that issue.

If(Assignee != "empty"; Assignee;
Assignee = "empty"; "No Assignee")

Appreciate any help here.

Thanks in advance.

Accepted answers

David Niro

Hello @sarathgd ,

Are you receiving an error or the values are all "blank"?

Rather than saying "Empty", you will want to use undefined, like this:

If(Assignee != undefined; Assignee;
Assignee = undefined; "No Assignee")

I can't say for sure if it is the reason you are encountering an issue though. What version of Jira and Structure are you currently using?

Please feel free to contact our support team directly via email support@almworks.com or customer portal support.almworks.com.

Best,
David

All comments

David Niro

Hello @sarathgd ,

Are you receiving an error or the values are all "blank"?

Rather than saying "Empty", you will want to use undefined, like this:

If(Assignee != undefined; Assignee;
Assignee = undefined; "No Assignee")

I can't say for sure if it is the reason you are encountering an issue though. What version of Jira and Structure are you currently using?

Please feel free to contact our support team directly via email support@almworks.com or customer portal support.almworks.com.

Best,
David

sarathgd

Hi David, thanks for quick response.

I'm using Jira v8.20.10, OnPrim version.

With the above formula I'm able to populate No Assignee against issues if there is no assignee. For the issues if the issue have assignee also I am not getting the name of assignee but I'm getting value as JIRAUSER.

Appreciate your help here.

David Niro

Hello @sarathgd ,

You are very welcome! Thank you for the additional information!

This modification should work:

If(Assignee != undefined; Assignee.name;
Assignee = undefined; "No Assignee")

This asks for the name rather than the key when returning the value.

Hope this helps.

Best,
David

sarathgd

Thanks David, this logic worked

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

cloud

jira-software

jira-software-cloud

structure

addon-com.almworks.jira.structure

expr

formula