Filtering on the interview finish time

When data is collected using UNICOM Intelligence Interviewer - Server, the DataCollection.StartTime and DataCollection.FinishTime system variables store the date and time that the interview started and finished. You can use these variables to filter the case data records according to the time the interview started or finished. For example, the following WHERE clause selects interviews that finished in the last 24 hours. (It uses the DateAdd function to subtract 24 hours from the date and time returned by the function.)

The DataCollection.StartTime and DataCollection.FinishTime system variables store the times in coordinated universal time (UTC). (UTC was formerly referred to as Greenwich Mean Time or GMT.) To return the current date and time in UTC, use the UTC parameter for the Now function.

This example shows how to use the OnNextCase Event section for a similar result. Case data records whose finish time does not meet the criteria are filtered out of the export by using the Job.DropCurrentCase method.

Event(OnJobStart)
dmgrGlobal.Add("Last24hrs", DateAdd(Now("UTC"), "h", -24))
End Event

Event(OnNextCase)
If DataCollection.FinishTime < dmgrGlobal.Last24hrs Then
dmgrJob.DropCurrentCase()
End If
End Event

Generally, using a WHERE clause to select case data records is faster than using mrScriptBasic code in the OnNextCase Event section.

The code in this example is in the mrInterviewSelectOnFinishTime.dms sample DMS file in the UNICOM Intelligence Developer Documentation Library. For more information, see Sample DMS files for exporting UNICOM Intelligence Interviewer data.