1. Querying specific rows of the spreadsheet
*** This page is deprecated. Please click here for the new version ***
Use the Google Visualization Query Language to show only a specific subset of your data in the table.
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
Note: Beware, for now, queries doesn't work if you use the Proxy feature.
Note 2: Column IDs in spreadsheets are always letters; the column heading text shown in the published spreadsheet are labels, not IDs. You must use the ID, not the label, in your query string. This also applies to Awesome Table queries.
Example
In this example we going to use a spreadsheet which list colors and their nuance. We want to display only red color and gradient of red color in the Awesome Table view. If you want to do this 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 dayOfWeek(H) = 2
select * where L >= 50
select * where dateDiff(H, now()) > 0
select * where dateDiff(H, now()) > 0 or H is null
select * where I contains 'Script'
select * where dateDiff(H, now()) + 30 > 0
select L order by A desc limit 20
select L where dateDiff(A, now()) + 30 > 0 order by A desc
select L where (month(now()) = month(A)) AND (year(now()) = year(A)) order by A desc