How to create a Filter for my own "Structure Text Fields"

[Friedel_ Jens _K-DPPL_3_]

Hello,

I created a structure and added various own columns with the type Note in order to organize Brand specific data. 

Now I would like to create a Filter for these columns but my problem is - which formular do I have to use to filter on these added columns because my columns-Subtitels obviously do not appear in the JQL search bar?

I added my own columns with the type Note - is there any possibility to create columns with data type Number and  I can define which numbers the user can choose of - something like a value help?

Thank you

[Stepan Kholodov _Tempo_]

Hello @Friedel_ Jens _K-DPPL_3_ 

The Flex columns(Notes, text, number etc. custom columns in Structure) can be referenced in formulas the same as regular Jira fields. E.g. if you want to filter by some text in the Notes column, you can use a formula like this:
if search("text value", notes_column_name):1

You would need to manually mapped the notes-related variable to the Notes column.

The Filter by Formula generator will remove all work items that don't have the mentioned text value in their notes.

I hope this helps. If you have more questions about Structure, please reach out to us directly at our support portal.

Best regards,
Stepan
Tempo (the Structure app vendor)

[Friedel_ Jens _K-DPPL_3_]

Hello Stepan,

I still do not get it.

I am in the structure an I am using the following:

- Filter / Group

- New Filter

- JQL-Filter

Now I am struggeling with "Enter JQL query" because I do not know how to place a formular in this JQL query without creating an error.

Thanks for your help! 

[Stepan Kholodov _Tempo_]

Formulas and Flex fields (Notes etc.) exist only locally in the structure; they cannot be referenced in a JQL query since they are not Jira entities.

If you want to refer to a custom local column of your structure in a JQL query, the only way to do it is the use the Copy to Jira functionality - it writes the value of the column in a Jira field, effectively turning it into a regular field's value. So, you can:

- add a Notes column,
- define values for work items in the column,
- then reference the notes in the Formula,
- use Copy to Jira to sync the values to a field,
- and then refer to the values in the field in JQL queries the same like with any other field.

Best regards,
Stepan