Avensoft Help Desk
Submit Service Request
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
WHEN sr_assigned_to <> sr_updated_by THEN 'background-color: red'
END AS RowStyle, sr_id, sr_subject, sr_assigned_to, sr_updated_by
You would see records that were updated by a person other than the assigned to.
Updated On: 9/20/2011
Was this article helpful?
© 2017 Avensoft
| help desk software and service management software
Auto Detect Language
English (United States)
English (United Kingdom)
English (New Zealand)