Glossary Item Box
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 |
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 |
In this example, we will demonstrate how to filter records to display only products with a base price greater than 199.99.
© 2001-2017 Lighthouse Development. All Rights Reserved.