Creating Sub-Work Areas of Records

Use

As well as processing individual records, you can also group a selection of records for processing. All records which satisfy the specified selection conditions are displayed and can be processed. As well as processing individual records, you can also group a selection of records for processing.

Procedure

Selection by Field Contents

Choose Selection By Contents in the maintenance screen. You get a list of all fields used.
Select the desired field or fields.
Choose Continue. You get another screen, in which you can enter the comparison value for the field or fields.
Enter the comparison value.

Note

The compare operator has the default value "=" (equality). You can display the possible compare operators for values or character strings with F4.
If you want to extend the selection, display the field list again with the function Append, select the desired field or the fields and choose Continue.

If you want to add a selection condition, position the cursor on the line before the one where you want to make a selection. With the function Insert you get the field list, from which you can select the desired field.

You can link the selections with a logical "AND" or a logical "OR". Each OR operator forms a logical search block, which can consist of several AND statements. These search blocks are visually separated when you select ENTER.

Example

Field1 = 001 AND (Color1)

Field2 = xyz OR (Color1)

Field1 = 002 AND (Color2)

Field2 = abc (Color2)

Note

You can edit the selection conditions, such as move or delete. To do this, select the affected rows and call the corresponding function. You can see the available processing functions by pressing the right-hand mouse key in the dialog box.

You delete a single condition e.g., by selecting it and then choosing Delete.

You can delete all conditions via the function New Selection.
The function Choose displays all records which satisfy the specified selection conditions, for maintenance.

Note

The escape symbol "#" can be used for case-sensitive searches (for example, #z.#B. for "e.g.").

Select Functions

You can select single records, all records or a block of records. You can display all selected records together ( Start of the navigation path Choose Next navigation step All Selected End of the navigation path ) and process them.

You can select any number of entries on the overview screen. If you are in a detail screen, this record is handled like a selected record.

You can select several records in the following ways:

Select single records

Select the desired records by mouse click on the select box or F9.

You can get an overview of all selected records with the menu function Choose All Selected.
Select All Records of the entire work area or sub-work area (for example, all changed records).

Choose Process Selecting Select All.
Selecting a block of records

Firstly, position the cursor on the first entry of the block and choose Edit Selections Select Block. Next, position the cursor on the final entry of the block and choose Select Block again.

To delete a selection, use one of the two following possibilities:

Delete single selection

Position the cursor on the selected record and repeat the select function (see above).
Delete all selections

Use the menu option Edit Selections Delete All Selections.

You can perform all maintenance or display functions with the selected records (see the relevant topics below).

Select Processed Records

All processed records are stored in an internal buffer until they are saved, and they can be changed and retrieved at will. This functionality includes all inserted and deleted records. You can display processed records in this way, to check, and reverse if necessary, their changes.

You can choose the following record selections in the Selection menu:

all changed
all inserted
all deleted
all in a task (only in transport mode)

This selection is not affected by saving.
all not in a task (only in transport mode)

This selection is not affected by saving.

Your entries and changes are only written to the database when you save. They are then, with the exception of the last two selections (transport mode) no longer available to the selection functions.