Create advanced filters to find Pages with ShowQL – Showpad Help Center

All Pages created on Showpad are stored in your Pages library. As your library grows, you may need to use filters to find specific content.

To help you find exactly what you’re looking for, you can create advanced filters using the Showpad Query Language (ShowQL). ShowQL is a powerful and user-friendly query language that lets you define sophisticated criteria to precisely target Pages. Your filter is automatically applied as you build it.

See how it looks

Key features

Use filters based on one or more criteria to easily find relevant Pages
Use these filters to export a specific list of Pages

You need this to succeed

Plan: eOS Expert, eOS Advanced, eOS Professional

Legacy plan: Showpad Content Essential or higher

Permissions: Administrator, Promoted Member with Content permission

The quick way

Open the Libraries tab and select All Pages from the left menu to open the Pages library.
Click Advanced to the right of the search bar at the top of the library.
Click in the search bar and select one of the available attributes.
Choose a comparison operator.
Enter or select the value you want to find.
You can add another criterion to your search by clicking + add.
The list of Pages is updated as soon as you add new criteria.

Do this step by step

Understand advanced filtering logic
Create an advanced filter
List of available identifiers and operators

Understand advanced filtering logic

The Showpad Query Language (ShowQL) is a powerful and user-friendly query language that lets you define sophisticated criteria to precisely target content within your Pages library.

To create advanced filters using ShowQL, it's important to understand their construction and logic. There are two types of filters you can build:

Simple query: This is a filter that uses a single statement. You need to select an identifier, an operator, and a value. The identifier tells Showpad where to look, and the value defines what you're looking for. The operator determines how to compare the identifier and the value.
Combined queries: This is a more complex filter in which you can combine multiple statements by using one of the following logical operators:
- and: This operator returns content that matches both statements.
- or: This operator returns content that matches either statement.

Note: Manually entered text values are case-sensitive. This means that your results could be affected because "a" and "A" are treated as two distinct letters. However, this is not the case when using the contains (~) or does not contain (!~) operators. When using either of these operators, manually entered text values must be lowercase.

Create an advanced filter

Navigate to the Libraries tab.
If your organization uses multiple Divisions, select the desired Divison from the top-left dropdown menu.
Click Pages in the left menu to expand, and select All Pages to open the Pages library.
Click Advanced to the right of the search bar at the top of the library.
Click in the search bar and select one of the available attributes.
Select a comparison operator by clicking on the option presented in the search bar. This defines how the selected attribute is compared to the value. The available operators depend on the type of attribute selected.
Select or enter the value you want to find. Only values that correspond to the selected attribute are displayed.
Press Enter on your keyboard.
You can add another criterion to your search by clicking + add. This will add a logical operator between your search criteria. You can click on the displayed operator to change it.
- and: This operator is selected by default. Using it requires that any results returned must match both of your search criteria.
- or: This operator will return results that match either of the criteria.
The list of displayed Pages is updated as soon as you add new criteria.
To edit a filter statement, click the identifier, operator, or value and select the desired option.
You can remove statements individually by clicking the x next to each statement. You can also clear the search bar at any time by clicking Reset.

Showpad identifiers are grouped into five themes. The following table details the available identifiers and the operators that can be used with them.

Theme	Identifier	Operators	Description
Page	Page name	contains (~) does not contain (!~) is (=) is not (!=)	Notes: The value must: have at least 2 characters have no more than 64 characters be lowercase not include special characters
	Page content	contains (~) does not contain (!~)	Allows you to search the content inside documents that have indexed text. Notes: The value must: have at least 5 characters be a single word.
Data	Authors	contains (~) does not contain (!~)	Select one or more users from the displayed list.
	Languages	all any none	Select one or more languages from the displayed list.
	Countries	all any none	Select one or more countries from the displayed list.
	Permissions	is (=) is not (!=)	Select the permissions Can be shared.
	Tags	all any none	Select one or more tags from the displayed list. Type to search list.
Date	Added	is (=) Is not (!=) is before (<) is after (>) is on or before (<=) is on or after (>=) is between (>=, <=) custom	Select a date from the calendar. With the is (=) or is not (!=) operator, you can select Empty. Choose custom for relative date options: Within: Set a number of days before today. Set a number of weeks before today. Set a number of months before today. More than: Set a number of days before today. Set a number of weeks before today. Set a number of months before today. In the range: Set a time span before and after today (example: `-1m` to `1w`). See format details.
	Last Updated	is (=) Is not (!=) is before (<) is after (>) is on or before (<=) is on or after (>=) is between (>=, <=) custom	Select a date from the calendar. With the is (=) or is not (!=) operator, you can select Empty. Choose custom for relative date options: Within: Set a number of days before today. Set a number of weeks before today. Set a number of months before today. More than: Set a number of days before today. Set a number of weeks before today. Set a number of months before today. In the range: Set a time span before and after today (example: `-1m` to `1w`). See format details.
	Expired	is (=) Is not (!=) is before (<) is after (>) is on or before (<=) is on or after (>=) is between (>=, <=) custom	Select a date from the calendar. With the is (=) or is not (!=) operator, you can select Empty. Choose custom for relative date options: Within: Set a number of days before or after today. Set a number of weeks before or after today. Set a number of months before or after today. More than: Set a number of days before or after today. Set a number of weeks before or after today. Set a number of months before or after today. In the range: Set a time span before and after today (example: `-1m` to `1w`). See format details.
	Released	is (=) Is not (!=) is before (<) is after (>) is on or before (<=) is on or after (>=) is between (>=, <=) custom	Select a date from the calendar. With the is (=) or is not (!=) operator, you can select Empty. Choose custom for relative date options: Within: Set a number of days before or after today. Set a number of weeks before or after today. Set a number of months before or after today. More than: Set a number of days before or after today. Set a number of weeks before or after today. Set a number of months before or after today. In the range: Set a time span before and after today (example: `-1m` to `1w`). See format details.
	Last buyer activity	is (=) Is not (!=) is before (<) is after (>) is on or before (<=) is on or after (>=) is between (>=, <=) custom	The date of the latest buyer activity. This includes views of emails, links, Shared Spaces, and downloads. To see Pages with no buyer activity, select Empty. Select a date from the calendar. With the is (=) or is not (!=) operator, you can select Empty. Choose custom for relative date options: Within: Set a number of days before today. Set a number of weeks before today. Set a number of months before today. More than: Set a number of days before today. Set a number of weeks before today. Set a number of months before today. In the range: Set a time span before and after today (example: `-1m` to `1w`). See format details.
	Last seller activity	is (=) Is not (!=) is before (<) is after (>) is on or before (<=) is on or after (>=) is between (>=, <=) custom	The date of the latest seller activity. This includes in-app views, Shares, downloads, and adding to Shared Spaces. To see Pages with no seller activity, select Empty. Select a date from the calendar. With the is (=) or is not (!=) operator, you can select Empty. Choose custom for relative date options: Within: Set a number of days before today. Set a number of weeks before today. Set a number of months before today. More than: Set a number of days before today. Set a number of weeks before today. Set a number of months before today. In the range: Set a time span before and after today (example: `-1m` to `1w`). See format details.
Analytics	Comments	less than (<) less than or equals (<=) greater than (>) greater than or equals (>=)	Enter a number.
	Likes	less than (<) less than or equals (<=) greater than (>) greater than or equals (>=)	Enter a number.
	Buyer views	less than (<) less than or equals (<=) greater than (>) greater than or equals (>=)	The total number of views by external recipients. Updated once per day. Enter a number.
	Seller views	less than (<) less than or equals (<=) greater than (>) greater than or equals (>=)	The total number of views by internal sellers. Updated once per day. Enter a number.
	Buyer interest	is (=) is not (!=)	The buyer engagement performance grade. It is measured over the last 3 months, using percentiles to rank Pages from A (Top Performing) to E (Underperforming) based on recipient views. Select a value: Top Performing (A) Strong (B) Solid (C) Limited (D) Underperforming (E)
	Seller interest	is (=) is not (!=)	The seller engagement performance grade. It is measured over the last 3 months, using percentiles to rank Pages from A (Top Performing) to E (Underperforming) based on in-app views. Select a value: Top Performing (A) Strong (B) Solid (C) Limited (D) Underperforming (E)
Other	Description	contains (~) does not contain (!~)	Notes: The value must: have at least 5 characters be a single word.
	External ID	is (=) is not (!=)	Note: The value must have at least 5 characters.
	Slug	is (=) is not (!=)	Note: The value must have at least 5 characters.

Date range format:

When using the custom option with date-based filters (like Added, Updated, or Completed on), you can define a relative time range.

For In the range specifically, each field (before and after today) must follow this format:

One value per field: a single number + a unit (d for days, w for weeks, m for months).
Use - for past dates, + or no sign for future dates.
The left value must be earlier than the right value.

Examples:

-1m to 1w = from one month ago to one week from today.

-7d to 0d = from seven days ago to today.

Pages