Filter syntax in text field / field SUMMARY does not work 😏

[Rudolf Hirschbeck]

Colleagues, 

Within my project I have issues where the summary starts with the präfix „015FU_“ or with „0101“. For any reason my filter 

Project = „Service Desk“ AND type = Story“ AND summary ~ „015FU“

results in a message telling me that no issues were found to match my seach.

If I search for another text passage also contained within the summary I get a positiv result.

Example:

Summary = „015FU_TP13_V00_document location of requester“

Filter: Project = „Service Desk“ AND type = Story AND summary ~ „location of“ => WORKS 😊

Filter: Project = „Service Desk“ AND type = Story AND summary ~ „015FU“ => NOT WORKS 😔

What‘s wrong?

Please help.

Please send answer to r.hirschbeck@pro-opt-mbh.com

Regards

Rudolf

[Amrita Nair]

Try Project = "Service Desk“ AND type = Story AND summary ~ "015FU“ OR

Project = "Service Desk“ AND type = Story AND summary ~ "015FU%“

_ , - etc generally causes a parse error. 

[Payne]

Ah, you're on to something, but not quite right; I had forgotten about wildcards. But, the multicharacter wildcard is "*" rather than "%", and the single character wildcard is "?" So, this should work:

Project = "Service Desk“ AND type = Story AND summary ~ "015FU*“

[Payne]

I think the search is not finding matches because it is looking for whole "words", and you state that those two strings are prefixes.

e.g. If the summary were "015FU My Test", then "summary ~ 015FU" would work

[Danyal Iqbal]

It is not possible to make this work without writing custom code (scripted JQL function comes to mind but sounds like a suboptimal solution) or explore plugins. This is probably a technical limitation caused by using lucene index for searching.