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

Next challenges

Recent achievements

  • Global
  • Personal


  • Give kudos
  • Received
  • Given


  • 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

advance search -fuzzy search falied

I create two custom fields(multiline text) ,one is remarks ,the other is contractNo,but the contractNo cannot  fuzzy query by "~".

When i  do advanced search "project = DZRJKF AND contractNo ~ F000Z200109M03",i cannot search out  the  issues  which contractNo  is "F000Z200109M03/F9993200424H03".

But  i do advance search "project = DZRJKF AND remark ~ 批量",i can search out the issues which remark is "程序批&量/新\建 F 0Z181217M02".

1 answer

1 accepted

0 votes
Answer accepted
John Funk Community Leader Nov 17, 2020

Hi @lucia  - Welcome to the Atlassian Community!

No, short text fields cannot use the ~ search function. But you would copy the contract number into the Remarks or Description field using Automation for Jira or ScriptRunner or another add-on and do a search on that. 

No,the contractNo is long text fields,which is multiline text.

The interested  thing is another same custom field - remarks  can support  the ~ search.

John Funk Community Leader Nov 18, 2020

Some of the standard systems fields come built in to do that. That's why I think you need to copy the value of the contractNo field into the Remarks or Description field that supports the search. 

I tried,but not work.

I copy the value of the contracNo into the Remarks or Description field field ,but issues are not searched out.For example i copy  the value "FE10Z200507M03" into the Description field , issues that the contractNo is FE10Z200507M03  are searched out ,while issues that the contractNo is FE10Z200507M03/F4405200602H06 are not searched out.

John Funk Community Leader Nov 19, 2020

Maybe put a space on each side of the / - FE10Z200507M03 / F4405200602H06/

ok,I will try.

Another custom filed-remark supports fuzzy search.When i copy "批量“ into the field ,the issues that the value of the remarks  filed   is "程序批&量/新\建 F 0Z181217M02" will be searched out .

The filed type ot the  contractNo field an the remark field are same ,bothe are the Multiline text.

Why the remark  field supports fuzzy search ,but the other field-contractNo does  not supprot fuzzy search ?  why will that happens?

John Funk Community Leader Nov 20, 2020

Maybe it will work if you have a space on each side of the value. 

Yes,it works.Thanks a lot.

Like John Funk likes this
John Funk Community Leader Dec 10, 2020

Can you click on the Accept Answer button above so we can close this one out? Thanks!

Suggest an answer

Log in or Sign up to answer
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 ...

7,184 views 8 28
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