Filters and Searching Data

To search for specific records in your database, use the Select Records button on the sidebar of the Data Editor page. This will cause the Select Records box to pop up.

The first option, under Entire Category, allows you to set all products in the current category as either active or inactive.

The other options in the box, under Selected Records, allow you to search and filter your data. First, select which column in the current category you want to search. Then, next to Selection, choose the qualifier you want to search by, and the text you want to use in your search.

The Matches qualifier will only find records that contain only the same text as what you enter, while the Contains qualifier will match records that contain both the entered text and additional text. Does Not Contain will match all records that do not contain the entered text. If the record contains both the entered text and additional text, it will not be selected.

The Is Empty qualifier will match all rows that do not contain data in the specified column, while the Is Not Empty qualifier matches all rows that do contain data.

The Is Less Than, Is Greater Than, and Equals qualifiers should only be used with columns that contain numbers, such as a price. All rows that fit the qualifier will be matched.

After you have chosen the qualifier you want to search by, click the Find Records button. The category will be searched, and it will return how many rows matched the parameters.

After this you may use the Set Records button to set all matched records as either active or inactive. Remember that only active records will print in your catalog.

To filter your data, click Set Filter. This will cause only matched records to display in the database. The non-matched records will not be modified, they just will not display on the Data Editor page. To clear all filters, use the Clear Filter button.

Return to Tutorial Selection