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

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

      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.

        Acceptance criteria

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

                Created:
                Updated:
                Resolved: