Create a filter

[Y]

Hi, I would like to create a filter with this SQL statement (which is working) project = yyy AND assignee = currentUser() AND component in (build-aa, build-bb, build-cc, build-dd, build-ee, build-ff) AND status = Resolved I would like to use for the component in (build-*) , I try to use LIKE , % without any success , please advice BR yossi

[Christian Czaia [Decadis AG] · Accepted solution]

Hey,

seems like wildcard search in JIRA JQL still seems to be limited to free text fields and is performed by the "CONTAINS" operator:

http://confluence.atlassian.com/display/JIRA043/Advanced+Searching#AdvancedSearching-CONTAINS

I guess (correct me if I'm wrong), that your issue relates to this open JIRA issue:

https://jira.atlassian.com/browse/JRA-24152

Cheers Christian

P.S. You can also check this post:

https://answers.atlassian.com/questions/30052/jql-wildcard-search-of-version-list-like-fixversion

[Christian Czaia [Decadis AG]]

On the right hand side next to an answer you find buttons where you can vote up or down an answer. Equally you find a button to accept an answer.

Cheers

[Y]

How to do it ?

Thanks

[Y]

Hi Christian,

Yes - marked as answered .

BR

Yossi

[Christian Czaia [Decadis AG]]

Hi yossi,

only you can accept an answer ;-)

[Christian Czaia [Decadis AG]]

Hey,

have you voted for the existing issue? I really hope they fix this pretty soon.

Cheers Christian

P.S. Can this post be marked as answered?

[Ramiro Pointis]

Hi Yossi, last week I was with the same problem and I found this page. But I didn't had the time to test it, you could give it a try! Hope this helps!

[Ramiro Pointis]

That must be what Christian mentioned in the other answer. I've been trying in so many ways to use the LIKE clause but it appears that doesn't existe in the JQL Query. We could vote into the JRA-24152 that Christian said, to make it count for another update.

[Y]

Hi Ramiro,

Thanks for your answer.

I knw this page - it is from help when writing a filter, but the examples are not working for components .

Br

Yossi