Details
-
Bug
-
Resolution: Fixed
-
Highest
-
7
-
Severity 3 - Minor
-
Description
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.
Attachments
Issue Links
- is cloned from
-
JRACLOUD-65520 The operator 'changed' and 'was' are not supporting fields in JIRA Cloud JQL
- Closed
- has action
-
HOT-79817 Loading...