Avensoft
Support
nService Queries

Using nService's query builder, you can list service requests that meet different criteria. Here are some examples.

1. Display the service requests submitted 30 days ago.

  • Sign in as a technician or system administrator.
  • Go to the Requests page and click the Find Service Requests link.
  • Enter this into the SQL Where text box:
    datediff(day, sr_submitted_on, getdate()) > 30
  • Click the Run button to run the query.