Awesome Table provides a query system allowing users to specify which columns and rows to use and (sequentially) display.
1 - What is a Query?
Here is a non-exhaustive list of the benefits of using a query:
- Show only some columns
- Change the column's order
- Select rows using a condition
- Sort your data
2 - How to use queries
In this example, we are going to use a spreadsheet which lists colors and their details. We only want to display the color red and its gradients in Awesome Table view. To do this from the Awesome Table's sidebar menu, go to ADVANCED PARAMETERS > Query > then manually enter your Query statement (e.g. select * where C = "Red").
You can filter by text, dates, numbers, ... Here are a few examples:
|select * where L >= 50||Select elements where the value L is superior or equal to 50.|
|select * where I contains 'Script'||Select elements where the value I contains Script.|
|select L where dateDiff(A, now()) + 30 > 0 order by A desc||Select elements where the value the date A is from less than 30 days.|
|select L where (month(now()) = month(A)) AND (year(now()) = year(A))||Select elements the month and the year from A is the same as the current date.|
|Select only the B, D, E, L, R columns and display the columns in this order.|
select * Order by C desc
|Select all columns but order them with column C.|