We have several custom fields and we are trying to search one particular field that contains values that look like TP001, TP150 etc. I am trying to do an advance search on the field using !~ "TP" so that I dont get records that have those values but the search still produces records that contatin the "TP" value. Any ideas?
If you use !~ "TP" the exact word TP will be searched for (without any characters in front or behind) hence something like TP001 does not match (thus still appears in the search result). You should use !~ "TP*" instead so that the query will search for all phrases starting with TP and exclude them accordingly.
I think you're not consistent with what you want to achieve hence it's very hard for us to understand and help you with your request.
At first you said you'd like to exclude values starting with TP so I believe CCSDItemNum !~ "TP*" should work.
Later you said you want empty values so, as Udo suggested, CCSDItemNum is Empty should work. If I'm not mistaken, however, what you really want is values not starting with TP or empty values. If that's the case, CCSDItemNum !~ "TP*" OR CCSDItemNum is Empty will work.
Just now you said you only want values starting with TP, then I think CCSDItemNum ~ "TP*" should be enough. If you still want empty values, then just append OR CCSDItemNum is Empty.
I know you may want to experiment with different JQL queries but, if you change your request all the time, we may be confused and cannot follow. Please be consistent with one request first and we'll work out the others. For your information, the only operators available for Text Field (single line) are ~ (text), !~ (text), is (empty), and is not (empty). You may use * or ? to enhance the queries but remember not to put them at the beginning of the text parameters.
All the best,
Hey Atlassian Community! Today we are launching a bunch of customer stories about the amazing work teams, like Dropbox and Twilio, are doing with Jira. You can check out the stories here. The thi...
Connect with like-minded Atlassian users at free events near you!Find a group
Connect with like-minded Atlassian users at free events near you!
Unfortunately there are no AUG chapters near you at the moment.Start an AUG