any operator which works as LIKE operator to search by part of string in JIRA

[Danamma Muttakkanavar]

Hi ,

I want to filter a sprint column on particular search of word. to do so is there any operator use as like operator does in SQL

[Łukasz Szarecki]

Hi,

I assume that you want to create Quick Filter for your board. Quick Filter uses JQL to restrict view to issues matching that JQL. In JQL you can use operator "~" - it's similar operator to LIKE in SQL, but is allowed to use only for text type fields. You can read more about possibilities in JQL at https://confluence.atlassian.com/jirasoftwarecloud/search-syntax-for-text-fields-764478343.html

Example JQL
summary ~ "test"

Best regards! 

[Danamma Muttakkanavar]

It works for summary column but i want to do it with sprint column. Is sprint column has values like PI21  avangers Sprint1 i.e Pi team name sprint Number.. in this case want to filter on PI21 .  

[Łukasz Szarecki]

In your case try to type something like that:

Sprint = "PI21"

I checked similar JQL on my local environment and it worked. Searcher returns all results where sprint's name contain inputted text.