YOU CAN DISPLAY RECORDS FROM A TABLE THAT MATCHES CERTAIN CRITERA IN A 1 REPORT 2 TABLE 3 QUERY
Answers
Follow mee
Apply a Query using the Query expression syntax
Let's start with the basics: Language clauses. The syntax of the Query language is composed of clauses. Each clause starts with one or two keywords. All clauses are optional. Clauses are separated by spaces. The order of the clauses must be as indicated in the table below.
info This is a non-exhaustive list of clauses that are applicable in Awesome Table.
1
select
Selects which columns to return, and in what order. If omitted, all of the table's columns are returned, in their default order (from top to bottom).
2
where
Returns only rows that match a condition. If omitted, all rows are returned.
3
order by
Sorts rows by values in columns.
4
limit
Limits the number of returned rows.
5
label
Rename column headers.
Example using all five clauses listed above, following the prescribed sequence or order:
select * where C >= 90 order by C desc limit 10 label C 'Top 10'
Translation:
select * - use all columns in the data source
where C >= 90 - only display entries in column C whose value is greater than or equal to 90
order by C desc - sort the numeric entries on column C in descending order (highest to lowest)
limit 10 - then display only the first 10 items
label C 'Top 10' - fnally, label column C as Top 10
How to use Queries
In the Awesome Table editor:
1. In the sidebar, open the Advanced parameters section.
2. Enter your Query in the Query field.