Follow

Creating a Filter & Query Builder

Overview:

This article will walk you through the process of creating a query Filter.

Example:

You can filter a list to show only certain results. e.g. 

  • Only show Active products,
  • Only show Customers living in Texas,
  • Only show Orders placed after New Years Eve. 

You can also create a powerful combination of filter queries.  And if you're an advanced user, you can use regular expressions to build a query.

To learn how to create a filter follow the steps below:

1. From the Acenda dashboard navigate to a Product, Order or Customer list page
 You can select, edit, or delete a default filter from the list e.g. Active
2. From the header section of the screen click Filter
3. Then click Create New Filter

The QUERY BUILDER page displays. The default tab is Query, click another tab to toggle between the different query builder functions.

Enter a Name for your query in the Name field.

Query Tab
This is an advance feature.  Use regular expressions to query the database.
Build Tab

Design your own Filter query with Acenda's easy to use query builder.  

You can add AND and OR expressions, and drag and drop to make nested rules.

 We suggest experimenting with the query builder. Don't worry, you won't break anything.

You can return to the Query tab to view the regular expression of the query you built in the builder.

Test Tab
After you create your query, click the Test tab test to see the results.
Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request

0 Comments

Please sign in to leave a comment.
Powered by Zendesk