Create advanced filters to find Pages with ShowQL Updated October 31, 2024 16:26 Note: This article is about the new beta Admin App, which is still in development. Changes may occur. Please provide feedback directly in the beta app. All Pages created to 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 The beta Admin App enabled Showpad Enterprise package Showpad Administrator or Promoted Member account with Content Management permissions The quick way Open the Libraries tab and select All Pages from the left menu. Click the search icon in the top right of the library. Then, click Advanced. 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. 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. Select the relevant Library/Division in the top left menu if your organization uses them. Go to All Pages in the left menu. Click the search icon in the top right of the library. Then, click Advanced. Click in the search bar and select one of the available attributes. Note: The available filters vary depending on where you're searching (e.g., Files or Pages). 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. Click in the search bar to select or enter the value you want to find. Only values that correspond to the selected attribute are displayed. 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 assets is updated as soon as you add new criteria. You can clear the search bar at any time by clicking on Reset in the search bar. List of available identifiers and operators 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 before (<) is after (>) is on or before (<=) is on or after (>=) is between (>=, <=) Select a date from the date picker. Last uploaded is (=) is before (<) is after (>) is on or before (<=) is on or after (>=) is between (>=, <=) Select a date from the date picker. Last updated is (=) is before (<) is after (>) is on or before (<=) is on or after (>=) is between (>=, <=) Select a date from the date picker. Expired is (=) is before (<) is after (>) is on or before (<=) is on or after (>=) is between (>=, <=) Select a date from the date picker. Released is (=) is before (<) is after (>) is on or before (<=) is on or after (>=) is between (>=, <=) Select a date from the date picker. 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. Views less than or equals (<=) greater than (>) greater than or equals (>=) Enter a number. 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. Learn how this feature works in the current Online Platform. Related articles API actions in HTML content Create advanced filters to find content in your library