action #118186

Updated by livdywan over 1 year ago

## Motivation 
 #108413#note-14 shows multiple reminder comments for an urgent ticket but the ticket is blocked by subtasks so should not have received any comments. 

 ## Acceptance criteria 
 * **AC1:** SLO checker only look at tickets with no open subtasks 
 * **AC2:** **AC1:** Queries in only show tickets adhering to *AC1* 
 * **AC3:** **AC1:** Tickets still receive reminder comments based on SLO periods 

 ## Suggestions 
 * Queries in need to be adjusted, same as we have queries in tools team like 
 * Check existing examples 
 * Modify the query/queries with additional filters e.g. subtasks: none