Avensoft Help Desk - Use RowStyle pseudo column to color code records

Use RowStyle pseudo column to color code records

Create a SQL report in Requests, Reports. Use this as the SQL statement:

SELECT DISTINCT TOP 200
      CASE
         WHEN sr_assigned_to <> sr_updated_by THEN 'background-color: red'
         ELSE ''
      END AS RowStyle, sr_id, sr_subject, sr_assigned_to, sr_updated_by
FROM ns4_service_request

You would see records that were updated by a person other than the assigned to.