Uploaded image for project: 'Jira Platform Cloud'
  1. Jira Platform Cloud
  2. JRACLOUD-67404

Recurring - The operator 'changed' and 'was' are not supporting fields in JIRA Cloud JQL

XMLWordPrintable

      Summary

      The operator 'changed' is not supporting fields in JIRA Cloud JQL (For example: 'status', 'assignee' fields)

      How to replicate

      1. Go to JIRA
      2. Go to JIRA Issue Navigator
      3. Click on Advanced search
      4. 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:

      1. From the top navigational menu, go to Issues > Manage Filters
      2. Find the filter that is used in the board and click on it
      3. Edit the JQL to remove the was and changed
      4. 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.

              Unassigned Unassigned
              cteh Ting
              Votes:
              26 Vote for this issue
              Watchers:
              44 Start watching this issue

                Created:
                Updated:
                Resolved: