nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Create a filter

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

Accepted answers

Christian Czaia [Decadis AG]

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

All comments

Ramiro P

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!

Christian Czaia [Decadis AG]

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

Ramiro P

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.

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 .

Yossi

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?

Christian Czaia [Decadis AG]

Hi yossi,

only you can accept an answer ;-)

Hi Christian,

Yes - marked as answered .

Yossi

How to do it ?

Thanks

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

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

sql

jira

jql

wildcard