Filter String grid

The Filter String grid feature allows you to use a filter from an inventory module to add multiple assets to a Work Order generated from the PM.  Because this is a grid it can contain multiple filter strings, potentially pulling in assets from several modules.

Example

When creating a PM for a drainage basin you could list all the pipes individually in the Assets grid.  However, this may be hard to keep updated.  It would be easier to use a filter created in the Pipe Inventory module. Alternatively, you can do both: add assets manually AND use a filter.  An example is shown in the Assets tab above.  In this tab, two assets have been manually added to the grid and a filter string has been created.  This will result in a work order that has these two assets AND all records that meet the filter.

A sample of the grid appears below. Sort records in each grid by clicking on the headings.  An up or down arrow (highlighted in orange below) will appear signifying ascending or descending order.

How To Add a Filter String

  1. Decide what asset type should be added to the work order.
  2. Go to the module for that asset type and create a filter for the assets that should be added to the work order.
  3. Save the filter with a distinct name.
  4. In the PM/Template module find the desired PM record and go to the Assets tab.
  5. Right-click in the FIlter String grid and select Add Record. The following pop-up will appear:

    filter_string

  6. Select a Category for the desired asset type. Click on the field name or press F9 within the field for a list of categories.
  7. Select the Filter Name from the asset module that was saved in step 3. Click on the field name or press F9 within the field for a list of saved filters.'
  8. Save and Close the record.
  9. The filter will be added to the grid. When the PM generates a Work Order the filter will run and the filtered assets will be added to the work order's asset grid.
  10. Repeat this process for any other desired asset filters.

See Also

Assets tab

Using the Grid

Adding an Asset

Create a Subset

Loading a Subset

Add Multiple

Add Assets from Map

View Asset Inventory Record

View Asset in Map

Stretch