<?xml version="1.0" encoding="utf-8"?>
<savedquery>
  <IsCustomizable>1</IsCustomizable>
  <CanBeDeleted>1</CanBeDeleted>
  <isquickfindquery>0</isquickfindquery>
  <isprivate>0</isprivate>
  <isdefault>0</isdefault>
  <returnedtypecode>112</returnedtypecode>
  <savedqueryid>{607c95b6-8a3c-e611-8120-127b25dcbde7}</savedqueryid>
  <layoutxml>
    <grid name="resultset" object="112" jump="title" select="1" preview="1" icon="1">
      <row name="result" id="incidentid">
        <cell name="vhacrm_daysopen_number" width="75" />
        <cell name="ticketnumber" width="150" />
        <cell name="vhacrm_typeintersectionid" width="100" />
        <cell name="statuscode" width="100" />
        <cell name="customerid" width="100" />
        <cell name="ownerid" width="100" />
        <cell name="createdon" width="100" />
      </row>
    </grid>
  </layoutxml>
  <querytype>0</querytype>
  <fetchxml>
    <fetch version="1.0" output-format="xml-platform" mapping="logical" distinct="true">
      <entity name="incident">
        <attribute name="ticketnumber" />
        <attribute name="ownerid" />
        <attribute name="vhacrm_daysopen_number" />
        <attribute name="createdon" />
        <attribute name="customerid" />
        <attribute name="vhacrm_typeintersectionid" />
        <attribute name="statuscode" />
        <order attribute="vhacrm_daysopen_number" descending="false" />
        <filter type="and">
          <filter type="and">
            <condition attribute="statecode" operator="eq" value="0" />
            <condition attribute="vhacrm_daysopen_number" operator="ge" value="3" />
          </filter>
        </filter>
        <link-entity name="systemuser" from="systemuserid" to="owninguser" alias="aa">
          <link-entity name="teammembership" from="systemuserid" to="systemuserid" visible="false" intersect="true">
            <link-entity name="team" from="teamid" to="teamid" alias="ab">
              <filter type="and">
                <condition attribute="teamid" operator="eq" uiname="Help Desk Tier II" uitype="team" value="{0CF11BB0-3BF8-E511-9419-0050568DC724}" />
              </filter>
            </link-entity>
          </link-entity>
        </link-entity>
        <attribute name="incidentid" />
      </entity>
    </fetch>
  </fetchxml>
  <IntroducedVersion>1.1.0.6</IntroducedVersion>
  <LocalizedNames>
    <LocalizedName description="Active Requests for Tier 2 Agents" languagecode="1033" />
  </LocalizedNames>
  <Descriptions>
    <Description description="List of Active Requests assigned to Tier 2 Agents that are 3 days old or older" languagecode="1033" />
  </Descriptions>
</savedquery>