Database Reference
In-Depth Information
Column criteria
Three criteria columns are provided by default. This section discusses the options
we have for editing their criteria. These include options for selecting fields, sorting
individual columns, entering conditions for individual columns, and so on.
Field selector: Single-column or all columns
The
Field
selector contains all the individual columns for the selected tables, plus
a special choice ending with an asterisk (
*
)
for each table, which means that all the
fields are selected.
To display all the fields in the
author
table, we would choose
`author`.*
and check
the
Show
checkbox, without entering anything in the
Sort
and the
Criteria
boxes.
In our case, we select
`author`.`name`
, as we want to enter some criteria for the
author's name.
Sorts
For each selected individual column, we can specify a sort (in
Ascending
or
Descending
order), or let this line remain intact (no sorting). If we choose more
than one sorted column, the sorting will be carried out from left to right.
When we ask for a column to be sorted, we normally check the
Show
checkbox. But this is not necessary, as we might want to do just the
sorting operation without displaying this column.
Search WWH ::
Custom Search