JQL: field that contain at least 2023 Q3

[Eric Roetenberg]

Hello,

I'm looking for a JQL query that can retrieve a piece of text in a field.
Example: the field PLANNING must contain at least 2023 Q3.

who has a solution

Grtz  Eric

[Manoj Gangwar · Accepted solution]

Hi @Eric Roetenberg , 

Please refer to the below link for syntax. 

https://confluence.atlassian.com/jiracoreserver073/search-syntax-for-text-fields-861257223.html#Searchsyntaxfortextfields-escapingEscapingspecialcharacters:%5Cor%5C%5C

[Bill Sheboy]

Hi @Manoj Gangwar 

That reference link is for Jira Server and it appears Eric is using Jira Cloud.  As there can be differences between the versions / supported features, the equivalent reference for Cloud might be this one:

https://support.atlassian.com/jira-software-cloud/docs/jql-operators/#CONTAINS----

Kind regards,
Bill

[Mohamed Benziane · Accepted solution]

Hi,

You can try Planning~"2023 Q3"