Duplicate IDs

When an interviewer’s browser terminates because of an error or a crash of some type, interviewers still display in the Interview Monitoring page. This results in duplicate IDs being listed. To avoid this issue, the following configuration is in the Web.config file:

<add key="GetLatestInterviewers" value="false"/>
<add key="GetLatestInterviewersSqlText"
     value="select a.* from CatiInterviewerSession a,
              ApplicationSession d
            where a.ApplicationSessionId = d.ApplicationSessionId
            and a.lastupdated >= (select lastupdated from
            (select c.username as username, max(b.lastupdated) as
            lastupdated
            from CatiInterviewerSession b, ApplicationSession c
            where b.ApplicationSessionId = c.ApplicationSessionId
            and c.username = d.username
            group by c.username) temp
            where temp.username = d.username
            )"/>