Formula in Jira structure to check whether a specific component is present

[Zigi Fibert]

I'm trying to create a custom column that calculates different values based on specific components.  I'm looking for a formula that will look at the component field and determine whether the component is present.  

I think Match should do it but I can't work out how to use it with a field.

Help will be greatly appriciated.

Zigi

[Stepan Kholodov · Accepted solution]

Hello Zigi,

Unfortunately, the Formula column is not implemented yet in Structure Cloud. If you would be interested, we can notify you when it is released in the future.

Best regards,
Stepan Kholodov
ALM Works

[Zigi Fibert]

Hello Stepan, in which case I'm not using Jira cloud.   I can do formula's I just don't know how to do this specific one.

Can you help me with the actual formula?

Regards

Zigi

[Stepan Kholodov]

If you have the Server/Data Center version, then you can use this formula:
if(search("abc", components),1)
where abc is the name of the Component. As a result, the formula will mark with "1" all issues that have this Component.

I hope this helps. If you need further assistance with the Formula column or with something else, 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

[Zigi Fibert]

Thank you very much, that works. 

I tried unsuccessfully to extend the formula to search for two values thus:
if(search("abc" or  "def", components),1).

How would I do that?

Regareds

Zigi Fibert

[Stepan Kholodov]

I'm glad to hear it! If you want to add another Component, it should be wrapped in the search() function individually: if(search("abc", components) or search("def", components),1)

Best regards,
Stepan Kholodov
ALM Works

[Zigi Fibert]

Thank you, Stepan.  Much appreciated.

Zigi