Filtering and Sorting Tables
In Arctype's Table view, you can easily filter and sort through data stored in your tables.
Filtering and sorting are foundational SQL operations, with a wide world of applications. In this document, we’ll show you how to sort and filter your table data with Arctype. We’ll also learn about some advanced Arctype features, like multi-sort and query creation.
To sort a table in Arctype, navigate to the
Tableview and select a table. Then, select the
Add sortbutton to create a sort. This button will open a menu that will allow you to configure your sort. You can choose a column to sort by and configure the sort to be ascending or descending. Select
Applyto sort your table.
Applying a sort to the "year" column
To remove a sort, simply select the
Xnext to the sort.
Arctype allows you to add multiple sorts to a table. To use the multi-sort ability, simply click the sort button each time you wish to layer on a new sort. You can also reorder your sorts by dragging them.
Applying multiple sorts
To filter a table in Arctype, navigate to your desired table and select the
Add filterbutton to create a filter. Just like sorting, this button will open a menu that will allow you to configure your filter. You can choose a column to filter by and configure the filter with the criteria you desire. Arctype intelligently displayed filter options that correspond to the type of data contained in the column.
Applying a filter
When you’re happy with your filter, you can select
Applyto filter your data. You can also add additional filters and remove them as shown below. You will notice this behavior is very similar to Arctype’s sort function, described above.
Applying multiple filters
Arctype allows you to both filter and sort a table at the same time. To do this, simply click on the
Add filtericons as needed to layer in a sequence of sorts and filters. You can configure each sort and filter to match your needs, as shown below. Additionally, you can reorder these operations by dragging them.
Filtering and sorting together
If you make a mistake, you can modify them or delete them by pressing the corresponding “X.” Pressing
Applywill update the table data to reflect the sort and filter criteria you chose.
Arctype can convert your sorts and filters directly into queries with the touch of a button. Simply select the
Create querybutton in the top right part of the table view to create a new query with the sort and filter parameters you chose. You can then choose to run or save the query, and put it to use as you see fit.
Turning your filters and sorts into a query