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
2 - Examples
In this example we are going to use a spreadsheet which lists colors and their nuances. We want to display only red color and gradients of red color in the Awesome Table view. If you want to do so go to the Advanced parameters -> Query when you are in the settings panel, here you can write some queries like this: select * where C = "Red".
You can filter by text, dates, numbers,... Here are a few examples of queries:
select * where L >= 50
select * where I contains 'Script'
select L where dateDiff(A, now()) + 30 > 0 order by A desc
select L where (month(now()) = month(A)) AND (year(now()) = year(A))