Case Activities Filter Config. Allows for querying case activities within Dovetail Agent

case.activities.filter.config

<filter name="Case Activities" entity="Cases"  allowAdhocQueries="true">

  <privileges>
    <addPrivilege value="Admin" />
  </privileges>

  <query from="case_alst">
    <addFacet key="activity_name" field="act_name" dataType="string"  >
      <values>
        <!-- Make sure this list has a default value! -->
        <addList name="Activity Name" />
      </values>
    </addFacet>

    <!-- Limit to recent activities -->
    <addFacet key="entry_time" field="entry_time" dataType="dateTime" >
      <where>
          <after value="1/1/2016" />
      </where>
    </addFacet>

    <addFacet key="login_name" field="login_name" dataType="string" />
    <addFacet key="additional_info" field="add_info" dataType="string" />

    <addJoin adhoc="true" from="parent_objid" to="objid" table="case">
      <addFacet key="caseId" field="id_number" dataType="string" />
    </addJoin>

  </query>
  
  <columns>
    <addColumn key="entry_time" template="dateTime" width="100" label="Activity Time"/>
    <addColumn key="activity_name" template="string" label="Activity" width="150"/>
    <addColumn key="login_name" template="string" entity="Employee" idField="login_name" width="100" />
    <addColumn key="caseId" template="entityLink" entity="Case" idField="caseId" width="100" label="Case ID"/>
    <addColumn key="additional_info" template="string" width="300" label="Details"/>
  </columns>

</filter>