[magnolia-dev] [JIRA] (TASKMGMT-23) Wrong SQL for pending tasks when user belongs to multiple groups

2016-03-09 Thread on behalf of Robert Šiška 
Title: Message Title
 
 
 
 
 
 
 
 
 
 
  
 
 Robert Šiška updated an issue 
 
 
 
 
 
 
 
 
 
 

 
 
 
 
 
 
 
 Task Management /  TASKMGMT-23 
 
 
 
  Wrong SQL for pending tasks when user belongs to multiple groups  
 
 
 
 
 
 
 
 
 

Change By:
 
 Robert Šiška 
 
 
 

Fix Version/s:
 
 1.1.2 
 
 
 

Fix Version/s:
 
 1.1.x 
 
 
 
 
 
 
 
 
 
 
 
 

 
 Add Comment 
 
 
 
 
 
 
 
 
 
 

 
 
 
 
 
 
 
 
 
 

 This message was sent by Atlassian JIRA (v6.4.12#64027-sha1:e3691cc) 
 
 
 
 
  
 
 
 
 
 
 
 
 
   




For list details, see: http://www.magnolia-cms.com/community/mailing-lists.html
Alternatively, use our forums: http://forum.magnolia-cms.com/
To unsubscribe, E-mail to: 

[magnolia-dev] [JIRA] (TASKMGMT-23) Wrong SQL for pending tasks when user belongs to multiple groups

2016-03-08 Thread on behalf of Robert Šiška 
Title: Message Title
 
 
 
 
 
 
 
 
 
 
  
 
 Robert Šiška updated an issue 
 
 
 
 
 
 
 
 
 
 

 
 
 
 
 
 
 
 Task Management /  TASKMGMT-23 
 
 
 
  Wrong SQL for pending tasks when user belongs to multiple groups  
 
 
 
 
 
 
 
 
 

Change By:
 
 Robert Šiška 
 
 
 

Comment:
 
 Consider current (wrong) SQL:{code}SELECT * FROM [mgnl:task] WHERE (actorId IS NULL AND groupIds = 'publishers' OR groupIds = 'fooers' OR groupIds = 'third_group' AND status LIKE '%Created%') [...]{code}Resulting clause of groupIds must be closed in parenthesis, otherwise it lazily evaluates to True ignoring the status condition. 
 
 
 
 
 
 
 
 
 
 
 
 

 
 Add Comment 
 
 
 
 
 
 
 
 
 
 

 
 
 
 
 
 
 
 
 
 

 This message was sent by Atlassian JIRA (v6.4.12#64027-sha1:e3691cc) 
 
 
 
 
  
 
 
 
 
 
 
 
 
   




For list details, see: http://www.magnolia-cms.com/community/mailing-lists.html
Alternatively, use our forums: http://forum.magnolia-cms.com/
To unsubscribe, E-mail to: 

[magnolia-dev] [JIRA] (TASKMGMT-23) Wrong SQL for pending tasks when user belongs to multiple groups

2016-03-07 Thread on behalf of Robert Šiška 
Title: Message Title
 
 
 
 
 
 
 
 
 
 
  
 
 Robert Šiška updated an issue 
 
 
 
 
 
 
 
 
 
 

 
 
 
 
 
 
 
 Task Management /  TASKMGMT-23 
 
 
 
  Wrong SQL for pending tasks when user belongs to multiple groups  
 
 
 
 
 
 
 
 
 

Change By:
 
 Robert Šiška 
 
 
 

Labels:
 
 selected-for-backlog support 
 
 
 

Account:
 
 
 
 
 
 
 
 
 
 
 
 
 
 

 
 Add Comment 
 
 
 
 
 
 
 
 
 
 

 
 
 
 
 
 
 
 
 
 

 This message was sent by Atlassian JIRA (v6.4.12#64027-sha1:e3691cc) 
 
 
 
 
  
 
 
 
 
 
 
 
 
   




For list details, see: http://www.magnolia-cms.com/community/mailing-lists.html
Alternatively, use our forums: http://forum.magnolia-cms.com/
To unsubscribe, E-mail to: 

[magnolia-dev] [JIRA] (TASKMGMT-23) Wrong SQL for pending tasks when user belongs to multiple groups

2016-03-07 Thread on behalf of Robert Šiška 
Title: Message Title
 
 
 
 
 
 
 
 
 
 
  
 
 Robert Šiška updated an issue 
 
 
 
 
 
 
 
 
 
 

 
 
 
 
 
 
 
 Task Management /  TASKMGMT-23 
 
 
 
  Wrong SQL for pending tasks when user belongs to multiple groups  
 
 
 
 
 
 
 
 
 

Change By:
 
 Robert Šiška 
 
 
 

Affects Version/s:
 
 1.1.1 
 
 
 
 
 
 
 
 
 
 
 
 

 
 Add Comment 
 
 
 
 
 
 
 
 
 
 

 
 
 
 
 
 
 
 
 
 

 This message was sent by Atlassian JIRA (v6.4.12#64027-sha1:e3691cc) 
 
 
 
 
  
 
 
 
 
 
 
 
 
   




For list details, see: http://www.magnolia-cms.com/community/mailing-lists.html
Alternatively, use our forums: http://forum.magnolia-cms.com/
To unsubscribe, E-mail to: 

[magnolia-dev] [JIRA] (TASKMGMT-23) Wrong SQL for pending tasks when user belongs to multiple groups

2016-03-07 Thread on behalf of Robert Šiška 
Title: Message Title
 
 
 
 
 
 
 
 
 
 
  
 
 Robert Šiška updated an issue 
 
 
 
 
 
 
 
 
 
 

 
 
 
 
 
 
 
 Task Management /  TASKMGMT-23 
 
 
 
  Wrong SQL for pending tasks when user belongs to multiple groups  
 
 
 
 
 
 
 
 
 

Change By:
 
 Robert Šiška 
 
 
 
 
 
 
 
 
 
 1) When publisher has 3 or more groups assigned, in pulse on tasks item he see number for new tasks that include not only new tasks, but also the resolved ones.How to reproduce:- Login to https://demoauthor.magnolia-cms.com- Publish two pages- Approve & publish only one of them- Add "travel-demo-editors" and "travel-demo-pur" to the user "Peter" (it will have total of 3 groups)!add-groups-peter.png|thumbnail!- Login as "Peter" and on tasks indicator you will see "2" instead of "1"!tasks.png|thumbnail!- Login as "superuser", indicator correctly show "1" 2) Non refreshing numbers of Tasks - the corresponding values are displayed after re-logingExample how to reproduce:- Login to https://demoauthor.magnolia-cms.com- Publish several pages- Go to Pulse - Tasks  (in "New" tab is no number)!Befor re-logging.png|thumbnail!- Re-log and numbers are refreshed!After re-logging.png|thumbnail! 
 
 
 
 
 
 
 
 
 
 
 
 

 
 Add Comment 
 
 
 
 
 
 
 
 
 
 

 
 
 
 
 
 
 
 
 
 

 This message was sent by Atlassian JIRA (v6.4.12#64027-sha1:e3691cc) 
 
 
 
 
  
 
 
 
 
 
 
 
 
   




For list details, see: http://www.magnolia-cms.com/community/mailing-lists.html
Alternatively, use our forums: http://forum.magnolia-cms.com/
To unsubscribe, E-mail to: 

[magnolia-dev] [JIRA] (TASKMGMT-23) Wrong SQL for pending tasks when user belongs to multiple groups

2016-03-07 Thread on behalf of Robert Šiška 
Title: Message Title
 
 
 
 
 
 
 
 
 
 
  
 
 Robert Šiška updated an issue 
 
 
 
 
 
 
 
 
 
 

 
 
 
 
 
 
 
 Task Management /  TASKMGMT-23 
 
 
 
  Wrong SQL for pending tasks when user belongs to multiple groups  
 
 
 
 
 
 
 
 
 

Change By:
 
 Robert Šiška 
 
 
 

Story Points:
 
 3 2 
 
 
 
 
 
 
 
 
 
 
 
 

 
 Add Comment 
 
 
 
 
 
 
 
 
 
 

 
 
 
 
 
 
 
 
 
 

 This message was sent by Atlassian JIRA (v6.4.12#64027-sha1:e3691cc) 
 
 
 
 
  
 
 
 
 
 
 
 
 
   




For list details, see: http://www.magnolia-cms.com/community/mailing-lists.html
Alternatively, use our forums: http://forum.magnolia-cms.com/
To unsubscribe, E-mail to: 

[magnolia-dev] [JIRA] (TASKMGMT-23) Wrong SQL for pending tasks when user belongs to multiple groups

2016-03-07 Thread on behalf of Robert Šiška 
Title: Message Title
 
 
 
 
 
 
 
 
 
 
  
 
 Robert Šiška updated an issue 
 
 
 
 
 
 
 
 
 
 

 
 
 
 
 
 
 
 Task Management /  TASKMGMT-23 
 
 
 
  Wrong SQL for pending tasks when user belongs to multiple groups  
 
 
 
 
 
 
 
 
 

Change By:
 
 Robert Šiška 
 
 
 

Fix Version/s:
 
 1.1.x 
 
 
 
 
 
 
 
 
 
 
 
 

 
 Add Comment 
 
 
 
 
 
 
 
 
 
 

 
 
 
 
 
 
 
 
 
 

 This message was sent by Atlassian JIRA (v6.4.12#64027-sha1:e3691cc) 
 
 
 
 
  
 
 
 
 
 
 
 
 
   




For list details, see: http://www.magnolia-cms.com/community/mailing-lists.html
Alternatively, use our forums: http://forum.magnolia-cms.com/
To unsubscribe, E-mail to: 

[magnolia-dev] [JIRA] (TASKMGMT-23) Wrong SQL for pending tasks when user belongs to multiple groups

2016-03-07 Thread on behalf of Robert Šiška 
Title: Message Title
 
 
 
 
 
 
 
 
 
 
  
 
 Robert Šiška updated an issue 
 
 
 
 
 
 
 
 
 
 

 
 
 
 
 
 
 
 Task Management /  TASKMGMT-23 
 
 
 
  Wrong SQL for pending tasks when user belongs to multiple groups  
 
 
 
 
 
 
 
 
 

Change By:
 
 Robert Šiška 
 
 
 

Project:
 
 Magnolia UI Task Management 
 
 
 

Key:
 
 MGNLUI TASKMGMT - 3801 23 
 
 
 

Security:
 
 Public 
 
 
 

Component/s:
 
 messages app 
 
 
 

Affects Version/s:
 
 5.4.3 
 
 
 

Affects Version/s:
 
 5.4.4 
 
 
 
 
 
 
 
 
 
 
 
 

 
 Add Comment 
 
 
 
 
 
 
 
 
 
 

 
 
 
 
 
 
 
 
 
 

 This message was sent by Atlassian JIRA (v6.4.12#64027-sha1:e3691cc)