Search query

[Donna Brown]

I am search in 2 projects to find summary text where "DL" or better "DL+" exist.  Here is my search sql which is not working 

project in (SOPS, SCUS) ORDER BY created DESC summary ~ DL

project in (SOPS, SCUS) ORDER BY created DESC OR summary ~ DL

[Trudy Claspill]

Hello @Donna Brown 

Welcome to the Atlassian community!

In what way is your search not working? Are you getting an error message? Or are you not getting all the results you expect?

Are you looking for the literal "+" character in the text?

I notice that your filter syntax is out of of order. All the selection criteria need to be specified before the ORDER BY clause:

project in (SOPS,SCUS) OR summary ~ "DL" ORDER BY created DESC

Additionally, if you want only the issues from the two projects that have summaries containing "DL" then you need to change the OR to an AND.

project in (SOPS,SCUS) AND summary ~ "DL" ORDER BY created DESC

To learn more about creating search filters, you may want to review the documentation found here:

https://support.atlassian.com/jira-software-cloud/docs/search-for-issues-in-jira/

To learn more specifically about searching for content in text fields refer to:

https://support.atlassian.com/jira-software-cloud/docs/search-syntax-for-text-fields/