Query Match in Structure

[BernardH]

In Structure, using a query match with JQL you are given the visual option of having a green Check mark for a positive result and blank if it was false. I would like to know if anyone has any ideas on how to change the blank to a Red X or some other visual representation other than  blank in a false scenario?

If not using query match, can anyone think of another way to do a visual representation of True or False in a column from a JQL query?

Thanks

Bernard

[David Niro · Accepted solution]

Hello @BernardH ,

David from ALM Works here.

You should be able to accomplish you goal through the use of a Formula Column, utilizing an IF Conditional Statement along with Wiki Markup.  This will depend on which version of Structure you are currently on as well as what your JQL Query.

In the example below, I am using Structure 7.3 and reference a specific issuetype.

Please give this a try and let me know how it goes!  I look forward to your feedback.

Best Regards,
David Niro
www.almworks.com

[BernardH]

Silly question, where did you get the Checkmark and X from? I can't seem to add the graphic to the statement? Great solution BTW...thanks!

[BernardH]

It is emoji...Doh!

[David Niro]

Hi @BernardH !

I was just drafting a response :) 

Is it working for you now?

Best,
David Niro
www.almworks.com

[BernardH]

Yes your answer worked perfectly. It solves one part of the problem, now I am on to part two which is combining that statement with an aditional requirements.

My goals are simple:

If the component field  is EMPTY then show the Red X, If it is populated, then show the Green Check. That works perfectly. However I want to add a second part, which is only look at issuetype in (Epic, Initiative) which I can't get to work in combination.

I want to do the same logic with Acceptance Criteria, but for some reason the formula will not accept "Acceptance Critera"=EMPTY . It does not like it ,but the solution for the first part works perfectly.

[David Niro]

Hello @BernardH ,

Glad to hear that the first part of the problem is solved!!

For the second part, we can try something like this

if((issuetype = "task" or issuetype = "story")and status = "to do" and assignee != empty; 
"✅";
if((issuetype = "task" or issuetype = "story")and (status != "to do" or assignee = empty);
"❌"))

I am using status and assignee where you will want to use component and acceptance criteria.  

There are some nuances to how we need to use JQL queries inside of a formula that this should help you address.  Please let me know if it helps!

Please also feel free to reach out to our support team via support@almworks.com or our portal support.almworks.com.

Looking forward to your feedback!

Best Regards,
David Niro
www.almworks.com

[BernardH]

I gave this a try and it is not working for me. It is respecting the issuetype but it is not respecting the EMPTY status of the field and marking it correctly (It does not mark the X at all, it just leaves it blank..

if((issuetype = "Epic" or issuetype = "Initiative")and "Acceptance Criteria" != empty;
"✅";
if((issuetype = "Epic" or issuetype = "Initiative")and "Acceptance Criteria" = empty;
"❌"))

Any suggestions, and as always. I truly appreciate your help!

[David Niro]

Hello @BernardH ,

I believe I see what is causing the issue.

"Acceptance Criteria" = empty

should be

AcceptanceCriteria = empty

When done this way, AcceptanceCriteria will become a variable.  You may need to map it to the right field if it is not automatically selected.

Please let me know if it helps!  If you would like, we can dive deeper into it via support ticket.  Just send a note to support@almworks.com.

Best Regards,
David Niro
www.almworks.com