Fixes for task email notifications - main
Targets #1409 (closed)
Summary
Same changes as MR !975 (merged). Please refer to summary points 3 & 4 and the note for SQL query.
Targets #1409 (closed)
Same changes as MR !975 (merged). Please refer to summary points 3 & 4 and the note for SQL query.