OpenOffice.org 2.x Guía de usuario descargar pdf (Pagina 425)

Chapter 7: Databases and Data Sources

Command/Operator Result

='Ms.' returns records with the field content “Ms.”

LIKE 'g?ve' returns records with field contents such as “give” and “gave”

LIKE 'S*' returns records with field contents such as “Sun” or “Stop”.

BETWEEN 10 AND 20 returns records with field contents between the values 10 and 20.

(The fields can be either text fields or number fields).

IN(1; 3; 5; 7) returns records with the values 1, 3, 5, 7.

NOT IN ('Smith') returns records that do not contain “Smith”.

In the form view, click the Apply Filter icon to change to the filtered view.

The filters that have been set can be removed by clicking on the icon

Remove Filter/Sort.

If several filter conditions are to be connected with OR, click the Filter

Navigation icon on the Form Filter toolbar. The Filter Navigator window

appears.

The filter conditions that are set appear in the Filter Navigator. As soon as a filter is set, at

the bottom of the Filter Navigator notice a blank filter level in which Or can be selected by

clicking on it. Once the blank filter level is selected, enter other filter conditions in the form.

These conditions are linked by Boolean OR to the previously defined conditions.

The context menu can be called for every entry in the Filter Navigator. Edit the filter

conditions in this area directly as text. In addition users can also select the filter conditions (

SQL: “Is Null” or (SQL: “Is not Null”) to check if a field has content or not. It is

also possible to delete the entry by using the context menu.

Filter conditions can also be moved within a form in the Filter Navigator by Drag&Drop or

copy them by holding down the Ctrl Key.

While designing a form, set the Filter proposal property for each text box in the Data tab of

the corresponding Properties dialog. These fields allow subsequent searches in the filter

mode, selections via a pull-down list all the summarized information contained in such fields.

The field contents can also be easily selected using the AutoComplete function. Please note

however, that this function requires a lot of memory space especially when used in large

databases and should, therefore, be used sparingly.

OpenOffice.org User Guide for 2.x 391

1 2 ... 420 421 422 423 424 425 426 427 428 429 430 ... 507 508

Sin comentarios

OpenOffice.org 2.x Guía de usuario Pagina 425