Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

Next challenges

Recent achievements

  • Global
  • Personal

Recognition

  • Give kudos
  • Received
  • Given

Leaderboard

  • Global

Trophy case

Kudos (beta program)

Kudos logo

You've been invited into the Kudos (beta program) private group. Chat with others in the program, or give feedback to Atlassian.

View group

It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

How can I search custom fields contains "A" character?

I found an interesting thing in JQL contains (~) search.

Let's say, I have a custom field called CRank. It is a text field.

Users may input A, A+, A-, B .... E .... into the text field.

I found we can search the issue contains B or C or ... ( CRank ~ C)

But, we got no result if we want to search for A (CRRank ~A)

 

I know I can change this field type to picklist but this will be a long list.

Just wondering if anyone experience this before?

 

Thanks

 

3 answers

1 accepted

1 vote
Answer accepted
Payne Community Leader Mar 21, 2019

A is likely a stopword (a word that is not indexed) in the Lucene index, due to its common usage as an article (a, an, the). The stopword list can be modified, but I'd be hesitant to do so unless you really need this functionality. https://confluence.atlassian.com/jirakb/how-to-remove-stop-words-in-jira-s-lucene-indexing-836111705.html

Thank you @Payne . It solved the myth 

Hi @SW 

One of the easiest way to search by word parts or combinations is to use regex expressions. You can try the add-on Power JQL.
And the request like:


issue in powerIssue("project=PSUP", "summary, description", ".*A.*")

Pay attention that the request may be heavy in terms of performance and you should always define subquery ("project=PSUP") to reduce regex checks.

0 votes
John Funk Community Leader Mar 21, 2019

Hi Swift - welcome to the Community!

I have not seen it where it would not work with a specific letter. You might try using a wildcard for the A. You can find information here:

https://confluence.atlassian.com/jiracoreserver/search-syntax-for-text-fields-939937723.html

Suggest an answer

Log in or Sign up to answer
TAGS
Community showcase
Posted in Jira Software

Presenting the "Best of 2020" Jira Software roundup!

Catch up with Atlassian Product Managers in our 2020 Demo Den round-up! From Advanced Roadmaps to Code in Jira to Next-Gen Workflows, check out the videos below to help up-level your work in the new ...

4,132 views 5 15
Join discussion

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you