Searching, Filtering, and Sorting Data in a Database
Searching and filtering are fundamental features that empower users to efficiently navigate databases and extract valuable insights. These functionalities play a crucial role in enhancing productivity, supporting decision-making processes, and maintaining the integrity of stored data. Additionally, users have the flexibility to arrange data records in either ascending or descending order.
In this article, we'll guide you on how to search, filter, and sort data in a database.
Searching for Data
There are two approaches to locating data in a database:
1. Searching for Data by Entering a Search Term
To search for data records by entering a search term:
On the app homepage, go to the My Work tab on the left sidebar.
All the folders you have created, as well as those created by others, will be listed.
If you cannot locate the folder in the list, type in the folder name under Search Folders.
Click on the folder you wish to open.
Head to the Databases tab.
Search and click on the required database.
A spreadsheet view of your database will be opened in a new window.
Type in the search term in the Search box to search and filter rows.
2. Searching for Data by Entering a MongoDB Query
For those with advanced expertise, you have the option to input a MongoDB query directly into the search box or type it in the editor window.
On the app homepage, go to the My Work tab on the left sidebar.
All the folders you have created, as well as those created by others, will be listed.
If you cannot locate the folder in the list, type in the folder name under Search Folders.
Click on the folder you wish to open.
Head to the Databases tab.
Search and click on the required database.
A spreadsheet view of your database will be opened in a new window.
Type in the MongoDB query in the search box.
Instead, you can click the expand icon to enter the query in a editor window.
Filtering Data
Filtering data in a database involves narrowing down the dataset to only include records that meet certain requirements.
There are several ways to filter data records in your database view:
1. Filtering Records by Selecting Column Values
To filter data records by selecting specific column values:
On the app homepage, go to the My Work tab on the left sidebar.
All the folders you have created, as well as those created by others, will be listed.
If you cannot locate the folder in the list, type in the folder name under Search Folders.
Click on the folder you wish to open.
Head to the Databases tab.
Search and click on the required database.
A spreadsheet view of your database will be opened in a new window.
On the spreadsheet, click Filters & Options.
Under the Filters menu, click on the required database column to expand it.
Within each column, you'll find a list of column values.
Choose the specific column values within the column to apply the filtering and display the corresponding data in your spreadsheet view.
2. Filtering Records by Selecting Columns
To filter data records by selecting specific columns:
On the app homepage, go to the My Work tab on the left sidebar.
All the folders you have created, as well as those created by others, will be listed.
If you cannot locate the folder in the list, type in the folder name under Search Folders.
Click on the folder you wish to open.
Head to the Databases tab.
Search and click on the required database.
A spreadsheet view of your database will be opened in a new window.
On the spreadsheet, click Filters & Options.
Click Toggle Columns menu.
Select the Columns you are interested in.
Only the data related to the selected columns will be displayed in the spreadsheet view. In other words, rest of the columns will be hidden from the view.
Sorting Data
To sort data in ascending or descending order:
On the app homepage, go to the My Work tab on the left sidebar.
All the folders you have created, as well as those created by others, will be listed.
If you cannot locate the folder in the list, type in the folder name under Search Folders.
Click on the folder you wish to open.
Head to the Databases tab.
Search and click on the required database.
A spreadsheet view of your database will be opened in a new window.
On the view, click Filters & Options.
Choose the column from the list that you'd like to use for sorting the data.
Select the sorting order as either ASC (ascending) or DESC (descending).
Data will be sorted and displayed based on the selected column.
Here is a short video that shows how to search, filter, and sort data in a database to help you understand better.
Last updated
