Can't use ~ Operator to search on Text Custom fields

[luizduarte]

I would like to know which kind of custom text fields use or what do I need to do for them to use ~ on a JQL search.

I am trying to use it on a Text Field(Single Line) and it says it's unsupported. On some Text Field(Multi-Line) it works but in others it doesn't. Does it need a specific configuration anywhere so it works?

JIRA version 8.5.1.

[Juergen Lanner]

Hi @luizduarte ,

operator ~ apparently only works for e.g. multiline text fields when the "Free text searcher" is configured for this field.

You reach this setting in the "edit custom field details" screen under "Search template". 

You might have to reindex after changing this.

reference: https://confluence.atlassian.com/jiracoreserver0813/advanced-searching-operators-reference-1027139133.html

Best regards

jue

[Sachin]

Hello @luizduarte , as per Advanced searching - operators reference ~ should work with Text Field (single line) and multi line. If it's a newly create custom field, I would recommend you (as jira admin) to do a background reindexing and see if that fixes the issue. Also see Search syntax for text fields 

The "~" operator is used to search for issues where the value of the specified field matches the specified value (either an exact match or a "fuzzy" match — see examples below). For use with version and text fields only, i.e:

Text fields:

• Summary
• Description
• Environment
• Comments
• Custom fields that use the "Free Text Searcher"; this includes custom fields of the following built-in Custom Field Types
  • Free Text Field (unlimited text)
  • Text Field (< 255 characters)
  • Read-only Text Field

Version fields:

• Affected version
• Fix version
• Custom fields that use the "Version Picker".

The JQL field "text" as in text ~ "some words" searches an issue's Summary, Description, Environment, Comments. It also searches all text custom fields. If you have many text custom fields you can improve performance of your queries by searching on specific fields, e.g. 
Summary ~ "some words" OR Description ~ "some words"

Note: when using the "~" operator, the value on the right-hand side of the operator can be specified using Jira text-search syntax.