Searching and filtering data¶

AppGini applications allow users to search and filter data easily.

Quick search¶

Above the table view of each table in your app, you can find the quick search box, which allows you to enter keywords and filter the displayed records accordingly. This is a simple way to find specific records that contain a keyword in any field.

The screenshot below shows the results of a quick search for the word united, showing records where any field contains the word.

Filters provide a more advanced way to search and filter data by configuring and combining multiple conditions. The Filter button above the table view brings a filters page as shown below.

Filter groups and filter conditions¶

Filters are organized into groups, and each group can contain multiple conditions (up to 4 conditions per group). Conditions can be combined so that all or any of the conditions in a group must be met. Similarly, groups can be combined so that all or any of the groups must be met.

This makes it possible to create highly specific queries that can pinpoint exactly the records you want.

For example, if we wish to find all customers from France, Germany or Mexico, whose company names begin with A, M or P, the filters would look like this:

In the above example, we have two groups of conditions. The first group contains conditions for the country, while the second group contains conditions for the company name. The Match all filter groups option is checked, meaning that both groups must be satisfied for a record to be included in the results. Inside each group, the Match all above conditions option is unchecked, meaning that any condition within a group can be satisfied for the group to be considered a match.

Clicking Apply filters will execute the filter query and display the matching records. Here is an example of the results you might see:

The filter icon beside the company name and country column headers indicates that these columns are being filtered.

Comparison operators¶

Each filter condition is composed of:

A field (e.g., "Country", "Company Name")
A comparison operator (e.g., "Equal to", "Greater than", "Less than")
A value to compare against (e.g., "France", "Acme Corp")

There are several comparison operators available for filters:

Filter operator	Matches records where the field :
Equal to	exactly equals the specified value.
Not equal to	does not equal the specified value.
Greater than	is greater than the specified value (for numbers/dates).
Greater than or equal to	is greater than or equal to the specified value (for numbers/dates).
Less than	is less than the specified value (for numbers/dates).
Less than or equal to	is less than or equal to the specified value (for numbers/dates).
Like	contains the specified value. `%` can be optionally used as a wildcard. For example, `A%` will match any value starting with "A", `%A` will match any value ending with "A", and `A%Z` will match any value starting with "A" and ending with "Z".
Not like	does *not* contain the specified value. `%` can be optionally used as a wildcard. Examples: `A%` will match any value that doesn't start with "A", `%A` will match any value that doesn't end with "A", and `A%Z` will match any value that doesn't start with "A" and end with "Z".
Is empty	is empty (i.e., has no value). When this operator is specified, the value box is ignored.
Is not empty	is not empty (i.e., has a value). When this operator is specified, the value box is ignored.

Sorting search results¶

You can sort the search results by one or more fields (up to 4) from the Order by panel in the filters page. The example screenshot below shows the Order by panel with several fields selected for sorting: Country (ascending), then Company Name (ascending), then Total Sales (descending).

Limiting search results by record owner¶

The Records to display panel in the filters page allows users to limit the search results to only those records they own, or to records owned by their group, or to all records. This is a very handy feature to allow users to quickly access their own data without having to sift through records owned by others.

This panel won't be displayed if the current user's permissions don't allow access to records they do not own.

Simplified filtering using the Search Page Maker plugin ¶

The Search Page Maker plugin enhances the filtering capabilities of your AppGini project by allowing you to build custom search pages with advanced filtering options via a simple drag-and-drop interface. With this plugin, you can:

Create dedicated search pages for specific tables.
Add more friendly filters. For example:
- Date fields can be easily filtered using a date range picker, saving users the need to manually define 2 filter conditions, and correctly handling date formats.
- Lookup and option list fields can be filtered using a dropdown list of available options, making it easier for users to select the desired value.
Users can still use the standard filters alongside the enhanced ones, providing flexibility in how they search for records.

Learn more about the Search Page Maker plugin

Filter before showing the table view¶

You can configure specific tables in your AppGini project to show users the filters page first before displaying the table view. This is useful for ensuring that users can refine their search criteria before viewing potentially large datasets. To configure this option, open your project in AppGini, click on the table you want to modify, and then check the Filter before showing table view option under Table view settings.

Excluding fields from filters¶

You can exclude specific fields from being used in filters. For example, you might want to exclude a field like "Notes" from the filters to simplify the search interface or avoid too many matches for fields that are not relevant to your users search use cases.

To configure this option, open your project in AppGini, navigate to the table you want to modify, then click the field you want to exclude from filters and check the Do not filter option.