Uploaded image for project: 'Kogito'
  1. Kogito
  2. KOGITO-5569

Data index query limit is not working

    XMLWordPrintable

Details

    • 2021 Week 31-33 (from Aug 2)
    • Hide

      1) Consider a data index installation with more than 100 user task instances created.

      2) Execute the following query:

       

      {
      UserTaskInstances (where: {state: {in: ["Ready", "Completed"]}}, orderBy : {started: ASC}, pagination: {offset: 0, limit: 100}) {
       id,
       started
      }
      }
      

      100 Tasks are returned.

       

      3) Now change the limit to a value higher than 100, e.g.

       

      {
      UserTaskInstances (where: {state: {in: ["Ready", "Completed"]}}, orderBy : {started: ASC}, pagination: {offset: 0, limit: 200}) {
       id,
       started
      }
      }
      

       

      4) The same set of 100 tasks are returned, however we know that the DB has more than 100 tasks.

       

      This worked well before.

      Show
      1) Consider a data index installation with more than 100 user task instances created. 2) Execute the following query:   { UserTaskInstances (where: {state: {in: [ "Ready" , "Completed" ]}}, orderBy : {started: ASC}, pagination: {offset: 0, limit: 100}) { id, started } } 100 Tasks are returned.   3) Now change the limit to a value higher than 100, e.g.   { UserTaskInstances (where: {state: {in: [ "Ready" , "Completed" ]}}, orderBy : {started: ASC}, pagination: {offset: 0, limit: 200}) { id, started } }   4) The same set of 100 tasks are returned, however we know that the DB has more than 100 tasks.   This worked well before.
    • Documentation (Ref Guide, User Guide, etc.), Release Notes

    Description

      It looks like the data index query limit is fixed in 100, it worked well some weeks ago, so maybe there was a change on that regard.

       

      The issue is produced at least in Infinispan, in other repositories I don't know.

      Attachments

        Issue Links

          Activity

            People

              cnicolai@redhat.com Cristiano Nicolai
              wmedvede@redhat.com Walter Medvedeo
              Tristan Radisson Tristan Radisson
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: