Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

How can I query a custom column in a Structure

Roland Wiesinger June 16, 2021

We are using the latest Structure v7.0.0 plugin for providing an overview of our features in a structure. I have added a custom column called "Check", that outputs "OK" or "NOK" to indicate whether certain criteria of the issues children are met, and in some cases it outputs a blank string ("").

I can easily create a custom transformation to either filter for the OK, NOK or "" in that custom column.

However, I fail to create a filter that queries for "OK and not empty" - in one single filter.
I've read the documentation over and over, and although I am rather firm with JQL, I could not really figure it out. I tried defining the filter with both JQL / S-JQL and I just could not come up with the correct syntax.

1 answer

1 accepted

1 vote
Answer accepted
Stepan Kholodov _ALM Works_
Atlassian Partner
June 17, 2021

Hello Roland,

Although it is possible to use JQL in formulas, the Formula column has its own (Expr)language which is different from JQL and S-JQL.

In your use case, you try to use the Attribute Filter based on the formula column you have, and set its Operator to is not equal to NOK value. You can find more about this filter on our wiki: https://wiki.almworks.com/display/structure/Attribute+Filter

I hope this helps! If you need further assistance with the Formula, please feel free to contact us directly at support.almworks.com and we'll get back to you shortly.

Best regards,
Stepan Kholodov
ALM Works

Roland Wiesinger June 17, 2021 edited

Hi Stepan,

thx for your answer. For my current problem, this answer does indeed help me (it's so simple, that I'm ashamed I didn't think of it), so I will accept it.

I'm "somewhat" familiar with Expr, as I am using quite an extensive formula in that column - although we're using Structure only for a few weeks by now. However, is there a more generic approach to reference to a formula column rather than the attribute filter? Can I filter it via a JQL/S-JQL Query match as well?

 

PS: I don't have an account for support.almworks.com. Can I just create one? I am not our JIRA admin - just one of the many users, so I am not sure if I am allowed to do that.

Stepan Kholodov _ALM Works_
Atlassian Partner
June 17, 2021

I'm glad to hear it! And sure you can create an account - just sign up and we'll be able to get in touch with you if you submit any requests. You can also just send a direct email to support@almworks.com

As for the Formula - the results in the column are Structure attributes. These values only exist locally in the column in the structure, so Jira is not aware of them and they can't be referenced by JQL. But you can do it with the Attributes Filter which is specifically designed to work with the Formula or you can turn the values into regular field values in Jira first and then reference them by JQL. The latter can be done using Effectors - our functionality for writing any existing values in columns(formulas, total values, notes, etc) to Jira fields. You can find more about Effectors here: https://wiki.almworks.com/display/structure/Effectors

Best regards,
Stepan Kholodov
ALM Works

Suggest an answer

Log in or Sign up to answer