How To Use The Filter Builder

Use the Filter Builder panels in Reports, Views and Queries, as follows:

      Expand a Data Category in the left panel. Then, one field at a time, click-drag or double-click them over to the Filter Builder panel. Note: The Data Categories are set by the type of Conquest Object Type that is using the Filter Builder

      For each field in the right-hand panel, choose an Operator then select or enter the criteria value

      You can group fields in the right panel by click-dragging them together

Example 1 - Operators for a criteria line. Pick the one most suitable for the field being filtered then enter a value to go with it; in this case ‘Like’:

      A value with a % on the right means “Find all instances of the specified field that start with the value”

      A value with a % on the left means “Find all instances of the specified field that end with the value”

      A value with a % on the left and the right means “Find all instances of the specified field that contain the value”

      This will produce a list of all Assets with “Falcon” somewhere in the Asset Description:

Note: The list of Operators varies, depending on the field’s data type:

      Text

      Number

      True or False

      Hierarchy

Example 2 - Shorten the list by retrieving Assets containing “Falcon” and “Sedan” and that are of the “Light Vehicles” Asset Type. Note: in this example the use of ‘Type Code’, which is a Hierarchical data type, adds ‘A descendant of’ and ‘Not a descendant of’ to the list of Operators:

Criteria lines can be grouped by drag-dropping them together, usually for tests on the same Field, so that their effect is as if they were just one line. For grouped criteria items, unless their Operator has a “Not” in it, you should usually change the ‘and’ to ‘or’ between the items.

Example 3 - Retrieve Assets containing “Falcon” and also containing either “Sedan” or “Utility” and that are of the “Light Vehicles” Asset Type:

Example 4 - It is possible to Group things in a Filter, which might make it easier to understand:

Example 5 - When using a ‘True or False’ field there are no Operators. For ‘Valuation Item’ it is a tick for ‘Yes’ or un-tick for ‘No’:

Example 6 - Delete a Filter item by hovering the mouse-pointer over it until a red “X” button appears to the right then click on the button, or drag-drop the item to the “Rubbish Bin” in the top-right corner of the panel:

Example 7 - Delete a Group or un-Group it by hovering the mouse-pointer over a “pink” part until a red “X” button appears to the right then click on the button, or drag-drop the item onto the “Rubbish Bin” in the top right corner of the panel. You can un-Group items in a Group by hovering the mouse-pointer over a “pink” part until a black “Group icon” button appears to the right, then click on the button: