Example config file for querying on part inventory within Dovetail Agent

inventory.filter.config

<filter name="Inventory" entity="Inventory"  allowAdhocQueries="true">

  <query from="parts_view">
    <addFacet key="partNumber" field="part_number" dataType="string" >
            <addSort ascending="true" index="0" />
    </addFacet>
    <addFacet key="revision" field="mod_level" dataType="string" />
    <addFacet key="description" field="part_descr" dataType="string" />
    <addFacet key="serialNumber" field="part_serial_no" dataType="string" />
    <addFacet key="location" field="location_name" dataType="string" />
    <addFacet key="goodQuantity" field="part_good_qty" dataType="int" />
    <addFacet key="badQuantity" field="part_bad_qty" dataType="int" />
    <addFacet key="goodQuantityReserved" field="good_res_qty" dataType="int" />
    <addFacet key="badQuantityReserved" field="bad_res_qty" dataType="int" />

    <!-- exclude serial tracked part instance, and empty serial tracked header instance -->
    <addField key="hdr_ind" field="hdr_ind" dataType="int" >
          <where>
            <notEqual value="0" />
            <notEqual value="3" />
          </where>
    </addField>

    <!-- exclude expense GL accounts -->
    <addField key="inv_class" field="inv_class" dataType="int" >
          <where>
            <notEqual value="2" />
          </where>
    </addField>

  </query>

  <values>

    <addTransform key="inv_class">
      <mapValues>
        <addMap from="0" to="inventory location" />
        <addMap from="1" to="capital GL account" />
        <addMap from="2" to="expense GL account" />
      </mapValues>
    </addTransform>

    <addTransform key="hdr_ind">
      <mapValues>
        <addMap from="0" to="serial tracked part instance" />
        <addMap from="1" to="serial tracked header instance" />
        <addMap from="2" to="quantity tracked part instance" />
        <addMap from="3" to="empty serial tracked header instance" />
      </mapValues>
    </addTransform>

  </values>


  <columns>
    <addColumn key="partNumber" template="string" />
    <addColumn key="revision" template="string" width="80"/>
    <addColumn key="description" template="string" />
    <addColumn key="serialNumber" template="string" />
    <addColumn key="location" template="string" />
    <addColumn key="inv_class" template="int" label="Inventory Class" width="140"/>
    <addColumn key="goodQuantity" template="int" label="Good Quantity" width="120"/>
    <addColumn key="goodQuantityReserved" template="int" label="Good Quantity Reserved"/>
    <addColumn key="badQuantity" template="int" label="Bad Quantity" width="120"/>
    <addColumn key="badQuantityReserved" template="int" label="Bad Quantity Reserved"/>
    <addColumn key="hdr_ind" template="int" label="Header Type" width="240"/>
  </columns>

</filter>