Hello,
I would like to create a filter to show those issues whose custom field "Name" starts by a specific letter, let's say, "A".
I am currently using:
Name ~ "A*"
But it is returning wrong results (issues where Name does not start with "A")
Does anybody have any clue about how to perform that search?
Thanks a lot,
Marc
You should be able to use issueFieldExactMatch from the same plugin...
issueFunction in issueFieldMatch(
""
,
"Name"
,
"A.*"
)
Hello Jamie,
Thanks for your answer.
However, I am receiving an error:
The JIRA server could not be contacted. This may be a temporary glitch or the server may be down.
When performing the following query:
issueFunction in issueFieldMatch("project=XXX", "Nom", "^[a-eA-E]")
If I change and use the field "Assignee" instead of the custom field "Nom" (Text Field (< 255 characters)), it works fine.
Do you know what may be happening?
Regards,
Marc
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Logs, in case they may help:
2013-03-08 08:21:48,804 http-8080-2 DEBUG bignoan 501x5364x2 nda8qa 158.166.147.59,158.167.133.6,127.0.0.1 /rest/issueNav/1/issueTable/ [jira.groovy.jql.AbstractScriptedJqlFunction] Subquery (project=PMOCONTACT) took 30 ms 2013-03-08 08:21:48,823 http-8080-2 ERROR bignoan 501x5364x2 nda8qa 158.166.147.59,158.167.133.6,127.0.0.1 /rest/issueNav/1/issueTable/ [common.error.jersey.ThrowableExceptionMapper] Uncaught exception thrown by REST service java.lang.NullPointerException at java.util.regex.Matcher.getTextLength(Matcher.java:1140) at java.util.regex.Matcher.reset(Matcher.java:291) at java.util.regex.Matcher.<init>(Matcher.java:211) at java.util.regex.Pattern.matcher(Pattern.java:888) at sun.reflect.GeneratedMethodAccessor1519.invoke(Unknown Source) <+1> (DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:597) at org.codehaus.groovy.runtime.callsite.PojoMetaMethodSite$PojoCachedMethodSite.invoke(PojoMetaMethodSite.java:189) at org.codehaus.groovy.runtime.callsite.PojoMetaMethodSite.call(PojoMetaMethodSite.java:53) at org.codehaus.groovy.runtime.callsite.AbstractCallSite.call(AbstractCallSite.java:116) at com.onresolve.jira.groovy.jql.EntityMatch$_getQuery_closure1.doCall(script1362578899598384340786.groovy:107) <+2> (DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:597) at org.codehaus.groovy.reflection.CachedMethod.invoke(CachedMethod.java:90) at groovy.lang.MetaMethod.doMethodInvoke(MetaMethod.java:233) at org.codehaus.groovy.runtime.metaclass.ClosureMetaClass.invokeMethod(ClosureMetaClass.java:272) at groovy.lang.MetaClassImpl.invokeMethod(MetaClassImpl.java:877) at groovy.lang.Closure.call(Closure.java:412) at org.codehaus.groovy.runtime.DefaultGroovyMethods.eachWithIndex(DefaultGroovyMethods.java:1368) at org.codehaus.groovy.runtime.dgm$206.invoke(Unknown Source)
There are more lines, but characters are limited here.
Thanks!
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Oh... it's a bug in my code. Can you modify the input query to be "project = XXX and Nom is not empty". Check that query works on its own before feeding to the function.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Thanks Jamie! Here the results of the tests:
project= XXX AND Nom is not EMPTY
Returns apropriate issues.
issueFunction in issueFieldMatch("project= XXX AND Nom is not EMPTY", "Nom", "^[a-eA-E]")
Does not return any issue (it should). No errors are logged.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
"^[a-eA-E].*"
worked for me... although I think yours should have worked too.
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.
Hi Jamie,
I have a similar issue, looking for issues with lables starting with "c/" (as in c/something). Unfortunately, the qurey I am using also returns results like "asc/something" etc, i.e. not starting with but containing "c/".
My query: issueFunction in issueFieldMatch("", labels, "c/.*")
Could you please advise?
Thanks,
Ondrej
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Not sure if you solved yet, but you have to use % instead of *
eg: summary ~ "Frontend:%"
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
If you got to this question and are wanting to match against a project's name, this works for me:
project IN projectMatch("project name prefix.+")
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Should be: "^c.*"
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You could also use:
Name LIKE 'A%'
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
This is not possible without writing you own jql function as a plugin (or using Script Runner to script this jql).
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Thanks for you answer, Henning.
However, I have one doubt: I have not been able to find where to define a new JQL function within Script Runner.
Even if I follow Jamie Echlin's instructions, I cannot find the described options: Admin -> Script JQL Functions
Any clue would be appreciated! Thanks
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Yes, scripted JQL is currently only in the beta version.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
For me it's the last point of the Plugins menu and a link on the main admin page in the plugin section under Other.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Do you use the current BETA version?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
No, I am currently using 2.0.7. Should I update to 2.1-BETA-8? to use these options?
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.