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

Question

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

Payne · Answer

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*“

Amrita Nair · Answer

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 · Answer

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