Searching all tasks that have "Inherit+" in summary

[Martin Rohner]

Hi community

I'm trying to get a filter working since quite some time now. I have certain tasks that have the term "Inherit+" in the Summary (usually at the beginning). I tried to set the JQL filter to the following:

issuetype = Task AND summary ~ "Inherit\"\\+\"" ORDER BY key ASC, created DESC

This works almost, since I also got the tasks starting only with "Inherit", and no +-sign in the summary. I thought I had the masking of the +-sign correct, but obviously not, can anyone help me with this? 

[Martin Rohner]

Ok, I got the error, it was - as usual - on my side. One cannot search for one of the special characters (which the +-sign obviously is), since this character is not indexed.

Now I got to find out all the tasks that belong to a certain filter, is this possible? The filter is built on a custom field.

[Hannes Obweger - JXL for Jira]

Hi @Martin Rohner

regarding your original question, you are correct that this is related to how Jira indexing works. IIRC, Atlassian is working on better full-text search support for Jira Cloud, but I haven't heard anything about Data Center or Server.

I understand that this problem may not justify a Marketplace app by itself, but just to put it out there: My team and I work on an app named JXL for Jira, in which your use case would be easy to do. JXL is a full-fledged spreadsheet/table view for your issues that allows viewing, inline-editing, sorting, and filtering by all your issue fields, much like you'd do in e.g. Excel or Google Sheets. Since JXL uses a different technology for searching through issues, you can use any special character, like so:

Needless to say that JXL can do much more than that :) As it looks like you're on Jira Server: While Atlassian doesn't allow new apps to be listed for Jira Server, JXL is perfectly compatible; it's just that we need to generate a license for you. If the above looks interesting, just let me know and I'll create a free trial for you.

Regarding your second question, if I understand correctly, you can do

filter = "Name of your filter"

or

filter = <filterID> 

- or am I missing something?

Best,

Hannes

[Martin Rohner]

Hi @Hannes Obweger - JXL for Jira 

Thanks much for your answer. I will certainly have a thought about your solution, though since I'm working in a larger company, this is not that easy to add some more applications.

With your solution about the filter, this works perfect, if I just take the filter as a search query, but I meant to have the filter as a criteria for the tasks I'm looking for. Maybe I misunderstood how to use it (and I'll certainly play around a bit with this knowledge).

Thanks and regards

Martin

[Hannes Obweger - JXL for Jira]

Ah, I think I understand - you would want to use the result of one query as an input for another query, like you'd do a join or sub-query in SQL? To the best of my knowledge, you can't do that in "plain" JQL - but you could have a look into Marketplace apps that extend JQL, like Scriptrunner or JQL Search Extensions.