Hi,
I'm wondering if it is possible in JIRA to search JIRA text fields.
e.g. a JQL query to "Text Field A" ~ "%es%"
This would return any issues containing es anywhere within that field, whether its test, estonia, compress, etc.
Thanks.
Community moderators have prevented the ability to post new answers.
As far as i know you can search for start of the word:
"Text Field A" ~ "es*"
and this will return only estonia.
Thanks.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You can search a text value as text ~ "\"text_to_be_searched\""
To search XYZ use text ~ "\"XYZ\""
Hope this helps.
Thank You
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
No you can't. Out of the box only * can be used, but only at the end of an string, like
"Text Field A" ~ "es*"
all issue with a word which starts with es like estonia
But you can use scriptrunner
issueFunction in issueFieldMatch("project = ABC", "Text Field A", "es")
That should work.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Thanks.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Just to confirm, the issuefunction using the script runner plugin, is run like a normal JQL query, and behaves like one too? In terms of filter, and dashboard gadget usage? Thanks.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
The query doesn't seem to be working as its not picking up any issues
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Yes, it is just an extension to the normal jql. Did you set the first subquery (project = ABC) according to your needs? It was working for me.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Yes I did, It seems to only work with full words
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
It found on my side issue where the only "es" was in business and yes. Maybe you need to adapt the regular expression. Do you have capital letters?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
I've created a test issue, with the word "test" Using this query; issueFunction in issueFieldMatch("project = TESTPROJECT", "Project Status", "es") returns 0 results but using this query; issueFunction in issueFieldMatch("project = TESTPROJECT", "Project Status", "test") Returns the test issue I had created with the word "test" in project status.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
As I said it works for me . Used issueFunction in issueFieldMatch("project = stt", description, "estfallma") and found only issues having "Testfallmatrix" in description. I'm using scriptrunner 3.0.10 - what version are you using?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Ah that's probably why.. I'm using v2.1.17
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
So I've tested it further and have realised that the query you have given works only for JIRA's own fields, e.g. summary, description etc. but NOT custom fields that have been created.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
I've tested it on the summary field and it is doing as stated. searching through back and forth for those characters.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hmm, custom field is also working fine on my instance.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Maybe this is related to : https://jamieechlin.atlassian.net/browse/GRV-385
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Possibly a bug then, I'll give it another few goes. Thanks for that Udo.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Just to update, I have now upgraded my Scriptrunner to v 3.0 and the JQL query is working now.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.