Groovy - jql issue search with current week

[Sanu Soman]

Hi All,

Could you please suggest additionally how I can add "issue created within this week" parameter to below jql query (groovy script)?

Query query=builder.project().eq("DEMO").and().customField(cf1.getIdAsLong()).eq(cf1Value.getValue()).and().customField(cf2.getIdAsLong()).eq(cf2Value.getValue()).buildQuery();

Please ask if you need more info.

[Bharadwaj Jannu · Accepted solution]

I didn't tried but once you can check

Query query=builder.project().eq("DEMO").and().customField(cf1.getIdAsLong()).eq(cf1Value.getValue()).and().customField(cf2.getIdAsLong()).eq(cf2Value.getValue()).and().created().gtEqFunc("startOfWeek").buildQuery();

you just go through the gtEqFunc(String funcName)

[Sanu Soman]

Yes.. it's worked. thanks :)

[Sanu Soman]

createdAfter("-1w") is working, but want to find specifically from start of this week like, created >= startOfWeek() (in jql). Please suggest.

[Sanu Soman]

Any suggestions?

[Sanu Soman]

Getting below error while trying with,

Query query=builder.project().eq("DEMO").and().customField(cf1.getIdAsLong()).eq(cf1Value.getValue()).and().customField(cf2.getIdAsLong()).eq(cf2Value.getValue()).and().createdAfter(startOfWeek()).buildQuery();

Error,

Caused by: javax.script.ScriptException: groovy.lang.MissingMethodException: No signature of method: org.codehaus.groovy.jsr223.GroovyScriptEngineImpl.startOfWeek() is applicable for argument types: () values: []
at org.codehaus.groovy.jsr223.GroovyScriptEngineImpl.eval(GroovyScriptEngineImpl.java:318)
at org.codehaus.groovy.jsr223.GroovyScriptEngineImpl.eval(GroovyScriptEngineImpl.java:111)
... 146 more
Caused by: groovy.lang.MissingMethodException: No signature of method: org.codehaus.groovy.jsr223.GroovyScriptEngineImpl.startOfWeek() is applicable for argument types: () values: []
at org.codehaus.groovy.jsr223.GroovyScriptEngineImpl.callGlobal(GroovyScriptEngineImpl.java:389)
at org.codehaus.groovy.jsr223.GroovyScriptEngineImpl.access$000(GroovyScriptEngineImpl.java:72)
at org.codehaus.groovy.jsr223.GroovyScriptEngineImpl$2.invokeMethod(GroovyScriptEngineImpl.java:301)
at org.codehaus.groovy.runtime.callsite.PogoMetaClassSite.callCurrent(PogoMetaClassSite.java:66)
at org.codehaus.groovy.runtime.callsite.CallSiteArray.defaultCallCurrent(CallSiteArray.java:46)
at org.codehaus.groovy.runtime.callsite.AbstractCallSite.callCurrent(AbstractCallSite.java:133)
at org.codehaus.groovy.runtime.callsite.AbstractCallSite.callCurrent(AbstractCallSite.java:137)

[JamieA]

See com.atlassian.jira.jql.builder.JqlClauseBuilder#addFunctionCondition.

[Sanu Soman]

createdAfter("-7d") is working but need something like created >= -1w. Please suggest.