Sort, find and filter records

Sort kits by unit cost, filter a price range and find records in DB Studio without changing the stored data.

Watch
2:40 · English narration; English captions are on by default.
What you'll learn

What you'll learn

You will sort Tool kits by Unit cost, filter values from 30 to 60, search for one kit and find another. You will then restore the full table. Datasheet sorts and filters change the view without changing stored data.

Before you begin

Before you begin

Open https://db.pyroom.app/ on a desktop or tablet to follow the video. It uses the English version of Prototype workshop, a fictional teaching sample.

Make sure the interface is in English before you create the sample: open the Application menu and choose English under Language. The sample is created in the interface language.

Phones can filter and search records too, with a different layout. The phone library has no samples button, so create the sample on a larger screen for this lesson.

Steps

Steps

  1. In My databases, click All samples and choose Prototype workshop. When it opens, open Tool kits under Tables. Check that the full table has 24 records.
  2. Open the column menu beside Unit cost and choose Sort descending. Prototype kit P-124 appears first, with a unit cost of 104.75.
  3. Reopen the Unit cost menu and choose Sort ascending. Prototype kit P-101 appears first, with a unit cost of 17.35. The count remains 24.
  4. Open the Unit cost menu again. In the Filter by list, choose Between. Enter 30 in the first value box and 60 in the second, then click Apply filter. Eight records match the range, including its endpoints.
  5. Click Clear all filters. All 24 records return; the price sort remains active.
  6. Type P-107 in the search box above the table (it shows Search in “Tool kits”). One matching kit remains visible. Empty the search box to show all 24 records again.
  7. Click Find and Replace, enter P-118 in Find and click Find Next. Wait for the message that a match was found in Kit, then click Close. Inspect the selected kit; all 24 records remain in the table.
  8. Open the Unit cost menu and choose Clear sort. Check that the full inventory is visible without the price sort, range filter or search text.
Expected result / Common mistakes

Expected result

Tool kits still contains 24 records with the same stored values. You saw eight records with Unit cost between 30 and 60, narrowed the table with a quick search and located a record with Find Next without narrowing the table.

Common mistakes

  • Sort the numeric Unit cost field when comparing prices. Sorting Kit compares names as text.
  • Clearing filters does not empty the search box or remove a sort. Clear each control used in the lesson.
  • A filter hides records from the view; deleting a record changes the database.
  • This lesson uses only the find controls in Find and Replace. Replacing values would change stored data.
Try it in DB Studio
Try it in DB StudioStart with a sample database
Open DB Studio
Related tutorials