Issue Summary

• Adding any filter, global filter for a project, or only the filter for comment added skews the displayed issues. It shows all the history for a specific issue or even for a particular month only if the specified limit expands to the total number of comments available for that project.

Steps to Reproduce

1. One project with comments placed within a wide range of time.
2. Create an activity stream gadget with the following filters:
   • Project is PROJECT
   • Activity is Comment Added
   • Limit to X items The number need to be lower then the total comments on the project.
     
     

     SELECT (p.pkey || '-' || i.issuenum) AS issue, a.issueid, a.actionbody, a.created
     FROM jiraaction a
              join jiraissue i on i.id = a.issueid
              join project p on i.project = p.id AND a.actiontype = 'comment' AND p.pkey = 'SCRUMT'
     ORDER BY a.created desc, a.actionbody;
     

3. The gadget isn't showing some comments, and at first glance, there is no pattern.
   
   
4. If we set Limit to 38 Which is the total comments within the project, the missing comme ants appear.
   

Expected Results

• Even with the limit lower than the project's total comments, the gadget should display all the comments in order.

Actual Results

• As described on the steps to reproduce, random comments are being hidden when the total comments are above the gadget limit.

Workaround

Required, if there is no workaround, please state:
Currently, there is no known workaround for this behavior. A workaround will be added here when available.