Uploaded image for project: 'Task Management'
  1. Task Management
  2. TASKMGMT-30

TasksStoreImpl.findPendingTasksByUser if user have no group assigned, the query is incorrect and returns all open tasks

    XMLWordPrintable

Details

    • Bug
    • Resolution: Outdated
    • Neutral
    • None
    • 1.2.2

    Description

      Please reference to linked ticket for more detail, basically this is affected:

      Query with groups:
      SELECT * FROM [mgnl:task] WHERE ((actorId IS NULL AND (groupIds = 'publishers') OR (actorIds = 'superuser')) AND status LIKE '%Created%') OR ((actorId = 'superuser' OR actorIds = 'superuser' ) AND status LIKE '%Failed%')
      Query without groups:
      SELECT * FROM [mgnl:task] WHERE ((actorId IS NULL OR (actorIds = 'bos-test-technical')) AND status LIKE '%Created%') OR ((actorId = 'bos-test-technical' OR actorIds = 'bos-test-technical' ) AND status LIKE '%Failed%')
      

      This count value is used to generate small red icon above pulse app, anyway then user can't see them.

      Checklists

        Acceptance criteria

        Attachments

          Activity

            People

              Unassigned Unassigned
              viet.nguyen Viet Nguyen
              AuthorX
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Checklists

                  Bug DoR
                  Task DoD