-
Bug
-
Resolution: Fixed
-
Highest
-
7
-
Severity 3 - Minor
-
Summary
The operator 'changed' is not supporting fields in JIRA Cloud JQL (For example: 'status', 'assignee' fields)
How to replicate
- Go to JIRA
- Go to JIRA Issue Navigator
- Click on Advanced search
- Paste this status changed DURING (-1, now())
Actual Result
This error message will appear The operator 'changed' is not supported by the '...' field.
Expected Result
It will show you some result.
com.querydsl.core.QueryException: Caught PSQLException for insert into oauth_service_provider_token_ecd6b3 (type, consumer_key, token_secret, token, properties, auth, username, verifier, creation_time, time_to_live, callback, version, session_handle, session_creation_time, session_last_renewal, session_time_to_live) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) at com.querydsl.sql.DefaultSQLExceptionTranslator.translate(DefaultSQLExceptionTranslator.java:50) at com.querydsl.sql.Configuration.translate(Configuration.java:451) at com.querydsl.sql.dml.SQLInsertClause.execute(SQLInsertClause.java:396) at com.atlassian.oauth.serviceprovider.sal.DefaultServiceProviderTokenStore.lambda$put$4(DefaultServiceProviderTokenStore.java:202) at com.atlassian.sal.core.rdbms.DefaultTransactionalExecutor.executeInternal(DefaultTransactionalExecutor.java:88) at com.atlassian.sal.core.rdbms.DefaultTransactionalExecutor$1.execute(DefaultTransactionalExecutor.java:42) at com.atlassian.jira.internal.sal.rdbms.JiraHostConnectionAccessor.lambda$borrowConnectionAndExecute$0(JiraHostConnectionAccessor.java:62) at com.atlassian.jira.database.DatabaseAccessorImpl.executeQuery(DatabaseAccessorImpl.java:36) at com.atlassian.jira.internal.sal.rdbms.JiraHostConnectionAccessor.borrowConnectionAndExecute(JiraHostConnectionAccessor.java:50) at com.atlassian.jira.internal.sal.rdbms.JiraHostConnectionAccessor.execute(JiraHostConnectionAccessor.java:40) at com.atlassian.sal.core.rdbms.DefaultTransactionalExecutor.execute(DefaultTransactionalExecutor.java:39) at com.atlassian.oauth.serviceprovider.sal.DefaultServiceProviderTokenStore.put(DefaultServiceProviderTokenStore.java:144) at sun.reflect.GeneratedMethodAccessor3657.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:498) at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:302) at org.eclipse.gemini.blueprint.service.importer.support.internal.aop.ServiceInvoker.doInvoke(ServiceInvoker.java:56) at org.eclipse.gemini.blueprint.service.importer.support.internal.aop.ServiceInvoker.invoke(ServiceInvoker.java:60) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179) at org.springframework.aop.support.DelegatingIntroductionInterceptor.doProceed(DelegatingIntroductionInterceptor.java:133) at org.springframework.aop.support.DelegatingIntroductionInterceptor.invoke(DelegatingIntroductionInterceptor.java:121) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179) at org.eclipse.gemini.blueprint.service.util.internal.aop.ServiceTCCLInterceptor$1.run(ServiceTCCLInterceptor.java:61) at org.eclipse.gemini.blueprint.util.internal.PrivilegedUtils.executeWithCustomTCCL(PrivilegedUtils.java:130) at org.eclipse.gemini.blueprint.service.util.internal.aop.ServiceTCCLInterceptor.invokePrivileged(ServiceTCCLInterceptor.java:58) at org.eclipse.gemini.blueprint.service.util.internal.aop.ServiceTCCLInterceptor.invoke(ServiceTCCLInterceptor.java:50) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179) at org.eclipse.gemini.blueprint.service.importer.support.LocalBundleContextAdvice.invoke(LocalBundleContextAdvice.java:57) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179) at org.springframework.aop.support.DelegatingIntroductionInterceptor.doProceed(DelegatingIntroductionInterceptor.java:133) at org.springframework.aop.support.DelegatingIntroductionInterceptor.invoke(DelegatingIntroductionInterceptor.java:121) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179) at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:208) at com.sun.proxy.$Proxy1385.put(Unknown Source) at com.atlassian.oauth.serviceprovider.internal.DelegatingTokenStoreImpl.put(DelegatingTokenStoreImpl.java:31) at com.atlassian.oauth.serviceprovider.internal.servlet.RequestTokenServlet.doPostInTransaction(RequestTokenServlet.java:109) at com.atlassian.oauth.serviceprovider.internal.servlet.TransactionalServlet$2.serve(TransactionalServlet.java:48) at com.atlassian.oauth.serviceprovider.internal.servlet.TransactionalServlet$3.doInTransaction(TransactionalServlet.java:57) at com.atlassian.oauth.serviceprovider.internal.servlet.TransactionalServlet$3.doInTransaction(TransactionalServlet.java:54) at com.atlassian.sal.core.transaction.HostContextTransactionTemplate$1.doInTransaction(HostContextTransactionTemplate.java:21) at com.atlassian.jira.DefaultHostContextAccessor.doInTransaction(DefaultHostContextAccessor.java:34) at com.atlassian.sal.core.transaction.HostContextTransactionTemplate.execute(HostContextTransactionTemplate.java:18) at sun.reflect.GeneratedMethodAccessor408.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:498) at com.atlassian.plugin.util.ContextClassLoaderSettingInvocationHandler.invoke(ContextClassLoaderSettingInvocationHandler.java:26) at com.sun.proxy.$Proxy632.execute(Unknown Source) at sun.reflect.GeneratedMethodAccessor408.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:498) at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:302) at org.eclipse.gemini.blueprint.service.importer.support.internal.aop.ServiceInvoker.doInvoke(ServiceInvoker.java:56)
... more
com.atlassian.jira.issue.search.SearchException: Attempted to perform non-db capable search in Vertigo mode at com.atlassian.jira.issue.search.providers.SearchModeExecutor.performPrimarySearch(SearchModeExecutor.java:270) at com.atlassian.jira.issue.search.providers.SearchModeExecutor.lambda$getTimedResults$3(SearchModeExecutor.java:199) at com.atlassian.jira.issue.search.providers.SearchModeExecutor.searchThrowableToEither(SearchModeExecutor.java:369) at com.atlassian.jira.issue.search.providers.SearchModeExecutor.getTimedResults(SearchModeExecutor.java:198) at com.atlassian.jira.issue.search.vsearch.VDualSearchProvider.runDualSearch(VDualSearchProvider.java:152) at com.atlassian.jira.issue.search.vsearch.VDualSearchProvider.aggregate(VDualSearchProvider.java:285) at com.atlassian.jira.issue.search.vsearch.AggregationBuilderImpl$TerminalUngroupedAggregationImpl.execute(AggregationBuilderImpl.java:568) at com.atlassian.greenhopper.web.rapid.work.ETagService.performIssueCountAndUpdatedSearch(ETagService.java:231) at com.atlassian.greenhopper.web.rapid.work.ETagService.lambda$getWorkDataIssueCountAndLastUpdated$3(ETagService.java:180) at com.atlassian.greenhopper.service.util.ServiceOutcomeHelper.toServiceOutcome(ServiceOutcomeHelper.java:39) at com.atlassian.greenhopper.web.rapid.work.ETagService.getWorkDataIssueCountAndLastUpdated(ETagService.java:179) at com.atlassian.greenhopper.web.rapid.work.ETagService.lambda$generateWorkModeETag$0(ETagService.java:106) at com.atlassian.greenhopper.service.util.ServiceOutcomeHelper.toServiceOutcome(ServiceOutcomeHelper.java:39) at com.atlassian.greenhopper.web.rapid.work.ETagService.generateWorkModeETag(ETagService.java:104) at com.atlassian.greenhopper.web.rapid.work.WorkDataFactory.lambda$getAllData$0(WorkDataFactory.java:164) at com.atlassian.greenhopper.service.util.ServiceOutcomeHelper.toServiceOutcome(ServiceOutcomeHelper.java:39) at com.atlassian.greenhopper.web.rapid.work.WorkDataFactory.getAllData(WorkDataFactory.java:158) at com.atlassian.greenhopper.web.rapid.PageLoadBigPipeWorkContextService.getData(PageLoadBigPipeWorkContextService.java:104) at com.atlassian.greenhopper.web.rapid.PageLoadBigPipeWorkContextService.lambda$getWorkContextFutureFromParams$0(PageLoadBigPipeWorkContextService.java:89) at com.atlassian.workcontext.api.WorkContextFunctionWrapper.lambda$withContext$10(WorkContextFunctionWrapper.java:139) at com.atlassian.workcontext.api.WorkContextFunctionWrapper.lambda$withContext$7(WorkContextFunctionWrapper.java:117) at com.atlassian.workcontext.api.WorkContextFunctionWrapper.lambda$withContext$11(WorkContextFunctionWrapper.java:143) at java.util.concurrent.CompletableFuture$AsyncSupply.run(CompletableFuture.java:1590) at java.util.concurrent.CompletableFuture$AsyncSupply.exec(CompletableFuture.java:1582) at java.util.concurrent.ForkJoinTask.doExec(ForkJoinTask.java:289) at java.util.concurrent.ForkJoinPool$WorkQueue.runTask(ForkJoinPool.java:1056) at java.util.concurrent.ForkJoinPool.runWorker(ForkJoinPool.java:1692) at java.util.concurrent.ForkJoinWorkerThread.run(ForkJoinWorkerThread.java:157)
Workaround
This is the temporary workaround if the filter is used in the board and the board is not loading:
- From the top navigational menu, go to Issues > Manage Filters
- Find the filter that is used in the board and click on it
- Edit the JQL to remove the was and changed
- Save the JQL
Note
Software boards are not loading the issues if the filter contains 'changed' or 'was'. After removing 'changed' or 'was', the issues will be loaded.
- is cloned from
-
JRACLOUD-65520 The operator 'changed' and 'was' are not supporting fields in JIRA Cloud JQL
-
- Closed
-
- has action
-
HOT-79817 Loading...