Could some one kindly help in providing a query to generate a report containing the following fields:
Request ID
Subject
Description
Resolution
Time of first assignment to a technician
Time of first reply by the technician
First reply sent by the technician
From date x to date y
The DB is PGSQL and the build is
9.0
Build
9035