Constrain any fields, choose the fields to display, and order the records

The form to set constraints, and choose which parameters to display, needs some expertise... It is powerful, but we recommend to read the following introduction before getting discouraged by the lack of success.

Constrain the parameters

The constraints have to be written directly in SQL, the language of the database server. Some of the most common constraints you may like to use are:
SQL statementExampleExplanation
= = 'HR' equality, note the single quote around the character string.
= = 15 equality, numrical values are not quoted.
!= != 'not public' not equal
IS NULL IS NULL does not have a value
IS NOT NULL IS NOT NULL has a value
IN IN ('F8', 'G0') is in a list of values
< < 200 less than, also ≤
> > 300 greater than, also ≥
BETWEEN BETWEEN -10 AND 10 in a range of values
LIKE LIKE 'G2%' pattern matching, % is a wildcard

Choose the parameters to display

By default, only a selection of the most useful parameters are displayed but the form exposes all the parameters from the table. You can use the checkboxes to unselect some defaulted fields you want to hide, or at the contrary select others.

Combination of the different constraints

All the constraints on individual fields set on this form are combined together with a logical AND.
They are also ANDed with other constraints set on the same quey, for example with a Skysearch.

The ELODIE Archive © OHP / INSU-CNRS / OSU Pytheas Remember to acknowledge Elodie
Contact: Database team Date of execution: