Example Filter Config File

employees.filter.config.xml

<filter name="Employees" entity="Employee"  allowAdhocQueries="true">
  <privileges>
    <addPrivilege value="Query Employee"/>
  </privileges>

  <query from="employee">
    <addFacet key="firstName" field="first_name" dataType="string" />
    <addFacet key="lastName" field="last_name" dataType="string" >
      <addSort isAscending="true" index="0" />
    </addFacet>
    <addFacet key="phone" field="phone" dataType="string" />
    <addFacet key="email" field="e_mail" dataType="string" />
    <addFacet key="workGroup" field="work_group" dataType="string" >
      <values>
        <addValue key="{{MyWorkgroup}}" value="{{MyWorkgroup}}" />
        <addList name="WORKGROUP" />
      </values>
    </addFacet>

    <addJoin relationship="employee2user">
      <addFacet key="status" field="status" dataType="string">
        <values>
          <addValue key="1" value="Active" />
          <addValue key="0" value="Inactive" />
        </values>
      </addFacet>

      <addFacet key="loginName" field="login_name" dataType="string"/>

      <addJoin relationship="user_access2privclass">
        <addFacet key="privilegeClass" field="class_name" dataType="string"/>
      </addJoin>
    </addJoin>

    <addJoin relationship="supp_person_off2site">
      <addFacet key="siteName" field="name" dataType="string"/>
      <addFacet key="siteId" field="site_id" dataType="string"/>
    </addJoin>
  </query>

  <values>
    <addTransform key="status">
      <mapValues>
        <addMap from="1" to="Active" />
        <addMap from="0" to="Inactive" />
      </mapValues>
    </addTransform>
  </values>

  <columns>
    <addColumn key="firstName"      template="entityLink" idField="loginName" width="200"/>
    <addColumn key="lastName"       template="entityLink" idField="loginName" width="200"/>
    <addColumn key="loginName"      template="string" />
    <addColumn key="siteId"         template="string"     width="100" />
    <addColumn key="siteName"       template="string"     label="SITE" />
    <addColumn key="phone"          template="string"     width="150" />
    <addColumn key="email"          template="string" />
    <addColumn key="status"         template="string"     width="100"/>
    <addColumn key="workGroup"      template="string" />
    <addColumn key="privilegeClass" template="string" />
  </columns>
</filter>