Use GREATEST to get the most recent activity date

Change recent activity date as opposed to create date on ticket view