Measurement List Edit
    • 02 Aug 2022
    • PDF

    Measurement List Edit

    • PDF

    Article summary

    This page allows you to create new data lists for your measurements. Following is an explanation of each field on this page. Click OK or Apply when you've finished to save your work.

    If you have not already, please read our measurements overview to understand how this screen fits into the other components of SLA.

    MeasurementListEditfilesNewmeasurementlistNewmeasurementlist.jpg

    Title : This is where you give your measurement list its name.
    Field Name : This is the database field that is used for the generating the list. You can also create a custom DB query (see below).

    Note
     If you will be using this list with either the Count or Ratio measurement formulas, it doesn't matter which field name you choose, as neither of those functions looks at the contents of the field. They both simply count the number of entries in the list.

    Date based on : This determines the date assigned to the data value when running the measurement. Request time is the time the service record was opened and Close time is the time the service record was closed. If you select Close time, SysAid will ignore open service records when generating the list.
    Status Class : Only service records whose status falls into the chosen status class will be included in this list.

    Statuses and their corresponding status classes
    MeasurementListEditfilesSLAstatusclassSLAstatusclass.jpg

    Include Statuses : Only service records with exactly the status(es) you specify will be included in the measurement list you're building. This allows you to be more specific than just choosing a status class. Leave this field blank to include all statuses in the status class you've chosen.

    • To add statuses to this field, click on the ellipses button. This will pop up a list of your statuses. Check off the ones you would like, then scroll to the bottom of the list and click OK.

    Service Record Types : Choose which service record type or types to include in your list. To select multiple entries, hold Ctrl and click on each desired entry. To deselect a selected entry, hold Ctrl while clicking on it.
    Filter Expression : This allows you to specify even further which service records will be in your list. After the list has been filtered by status class, status, and request type, SysAid will further filter the list by the criteria you supply here. For instructions on using the Expression Builder, please see here.

    Custom SQL queries

    To create a custom SQL query:

    1. Select Field Name Custom SQL.
      Using a custom SQL query for a measurement list
      MeasurementListEditfilesCustomSQLfieldCustomSQLfield.jpg
    2. Type your query into the text field next to the Expression Builder button.
    3. Fill out the rest of the page according to your needs.
    4. Click OK or Apply to save the new list.

    Custom SQL Example
    The following query will display a list of all service records that have a corresponding task and the progress % of that task:

    select ServiceRequest.id,Task.progress from service_req ServiceRequest,task Task where ServiceRequest.task_id=Task.id


    What's Next