How can I search multiple items for the field Gap[Short text]

[Saranya Mohan babu]

When I search "Gap[Short text]" ~ (741,729,734) , shows error that Operator '~' does not support the list value '(741, 729, 734)' for field 'Gap[Short text]'. I wanted to get the issues raised only for these three Items.

Thanks in advance.

[pawarsachin84]

Hello @Saranya Mohan babu ,

You are using - "Gap[Short text]" ~ (741,729,734)

The ~ (contains / fuzzy match) operator only works with single string values, not lists.

Lists like (a, b, c) are only allowed with operators like IN — and only for exact match fields, not text fields.

Try this ->

Since the field is a short text custom field, you need to query like this:

"Gap[Short text]" ~ "741" OR "Gap[Short text]" ~ "729" OR "Gap[Short text]" ~ "734"

Optional: Use IN with exact match if the field type supports it

"Gap[Short text]" in ("741", "729", "734")

Tip for Reuse ->

project = ABC AND ("Gap[Short text]" ~ "741" OR "Gap[Short text]" ~ "729" OR "Gap[Short text]" ~ "734")

[Priyanka Khare]

Hi,

The ~ operator is not suitable for handling lists of values. Replace it with the IN operator (if supported) or use multiple OR conditions to explicitly list the values you want to match. If the problem persists, consult the documentation of your tool to confirm the correct syntax for filtering using multiple values.

[Dick]

Hi @Saranya Mohan babu Welcome to the Atlassian Community

The ~ operator is for comparing a string to another string. It's called the "like" operator (as in similar to)

You're presenting a small list of three comma separated numbers and want to compare this string of text to a the string  "Gap[Short text]". That does not compute.

You say you want to get issues raised for these three items. I interpret that as you have three issue keys of a project described in that small array. Only thing is, an issue key has a different format:  XYZProject-123.

So I guess you want to use the text content of the Gap field to yield you an appropriate issue. The way to go about that is to construct the key by prefixing XYZProject- to the number. Atlassian has described string operations in their documentation on text operators

I use singular here, to not overcomplicate your problem.

Kind regards,
Dick

[Philipp Sendek]

Hi Saranya,

welcome to the community!

So yes, the ~ (tilde) operator which is used for searching text fields doesn't support lists and I'm not aware of another operator for text fields that does.

So in your case, I would simply build a statement using OR to chain your 3 different search queries together, such as:

"Gap[Short text]" ~ 741 OR "Gap[Short text]" ~ 729 OR "Gap[Short text]" ~ 734

This would list all work items where either of these values was found.

A little addition to my answer: Here you can find the documentation of the ~ operator as well as other operators: https://support.atlassian.com/jira-service-management-cloud/docs/jql-operators/#CONTAINS----

I hope that helps!

Greetings
Philipp