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

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

    XMLWordPrintable

Details

    Description

      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.

      Attachments

        Issue Links

          Activity

            People

              Unassigned Unassigned
              cteh Ting (Chiou Ting Teh)
              Votes:
              26 Vote for this issue
              Watchers:
              44 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: