Glossary Item Box

Squirrelcart v6.1.0

Filtering Records

How Filtering Works - Examples
Simple column match

The filter feature allows you to narrow down the records shown, by matching existing column values. For example, suppose you are viewing a table with the following data:

Size Name Type
Large Godzilla Not real
Small Mickey Mouse Not real
Large King Kong Not real
Large Elephant Real
Tiny Ant Real
Large Gorilla Real

 

If you were to filter on the Size column, you could filter as follows:

Size Equals "Large"


This would result in a table containing the following rows:

Size Name Type
Large Godzilla Not real
Large King Kong Not real
Large Elephant Real
Large Gorilla Real

 

 

Multiple Column Match

You can filter on multiple columns simultaneously. For example, you could filter as follows:

Size Equals "Large" AND Type Equals "Real"

 

This would result in a table containing the following rows:

Size Name Type
Large Elephant Real
Large Gorilla Real

 

Filtering Records - Step by Step

In this example, we will demonstrate how to filter records to display only products with a base price greater than 199.99.

  1. View Records
    Choose a table to work with, and click it's link in the toolbar. In this example, we will use the Products table.



  2. Enable Filtering
    Click the  button at the top of the data grid. The page will reload, and the blue filter row should appear above the record rows and below the column headers.



  3. Change Filter Operator
    The small symbol to the right of each funnel image shows how that column will be matched to the value in the drop down field. It is the "operator" for the filter. We will be matching as follows:
    Base Price Greater Than "199.99"

    The default operator is Equals. We need to change it to Greater Than. To do this, click the funnel icon in the Base Price column, and select Greater Than from the menu.



    The operator symbol to the right of the funnel will change to >.
  4. Change Filter Value
    Change the drop down field in the Base Price column to 199.99. When you change it, the page will refresh, and the data will now be filtered, as seen below.



 

 


© 2001-2017 Lighthouse Development. All Rights Reserved.