List/Report Selection Panel (Option 1)

Introduction

This section describes the fields in the List/Report Selection panel and illustrates how you can use these panels to select lists.

Navigation

From the "Primary Selection Menu", choose:

  • Option 1

    The "Select Lists/Reports" panel is displayed, where you can enter your selection criteria. "Select Lists/Reports" has 2 pages.

Required and optional fields

You must specify time selection criteria. All the other fields are optional.

To select lists by start and end date, leave the value field under Select from Last blank and specify a start and end date. Optionally, you can also specify a start and end time.

To select the lists from the last n hours or days, enter a value n in the value field under Select from Last and specify Hours or Days in the following field.

Using wildcards

You can enter a name or a mask in the following fields: Form, Extension, Report, and Jobname.

Valid wildcards are:

  • % (percent), which represents any single character
  • * (asterisk), which represents any sequence of characters (including a zero string)

Read-in date vs. list date

The date displayed in Adabas Audit Data Retrieval can be one of the following:

  • The Adabas Audit Data Retrieval read-in date of the list
  • A date that has been set at read-in time
  • A date that has been extracted from the list

Selecting matching lists

Pressing ENTER on page 1 or page 2 of the List/Report Selection panel will start the selection of lists in the Adabas Audit Data Retrieval database.

All matching lists will be displayed in the List/Report Selection table.

List/Report Selection panel (Page 1)

PE97BR00 -------------------------------------------------------- Page 1 of 2
 Command ===> __________________________________________________________________

 Select Lists/Reports

 Select from Last ===> 2. Hours 01-99, (H)ours, (D)ays
 or blank to define Start/End
 Start Date (MM/DD/YYYY) ===> 03/09/2009 Start Time ===> _____
 End Date (MM/DD/YYYY) ===> TODAY_____ End Time ===> _____

 Optional Selection Criteria:

 Form ===> REJ_____ String in Title ===> *_______________
 Extension ===> *_______________ from Column ===> 0_ (0 - 80)
 Report ===> *_______________
 Jobname ===> *_______ Browser Notes ===> ___ (Y)es,(N)o or
 Folder ===> *_______________________________ blank




 Press ENTER to display the lists/reports. Press DOWN to display the next page.
 Press END to return to the previous menu.

Fields (Page 1)

Field

Description

Select from Last

Enter a value n between 1 and 99 and specify Hours or Days to select lists of the last n hours or n days

Or leave the value field blank to select lists by the start/end date and start/end time specified in the following fields

Start Date/
End Date

Enter any of the following in these fields to select lists between this start and end date:

  • A date using the displayed date mask
  • A day of the week (MONDAY through SUNDAY)
  • The keywords TODAY or YESTERDAY

Note: The value field under Select from Last must be blank to select lists using the specified start and end date.

Start Time/
End Time

Enter a start and end time in the format hh:mm

Start and end time are based on the 24-hour clock. The default start time is 00:00 and the default end time is 23:59 (which corresponds to 11:59 P.M.).

Form/
Extension/
Report

To select lists by name, enter a name or mask in one or more of these fields

Jobname

To select lists by the job that created the list (creating jobname), enter a name or a mask

Folder

To select lists by the folder that the list has been assigned to, enter a name or a mask.

Note: Whether it is possible to enter a mask in this field is determined by your system administrator.

String in Title
  from Column

To select lists via the title, enter a string (max. 16 characters) that must be contained in the title. Optionally you can enter a column number to start the search at the specified column. from Column=0 means that the complete title is searched.

Note on wildcards: You can use the mask characters % or ? to denote any single character within the search string. An * (asterisk) is interpreted as the end of the search string. Characters following the asterisk are not evaluated.

Browser Notes

Enter one of the following:

Yes

to select only lists with browser notes (only public notes and your own private notes will be taken into account)

No

to select only lists without browser notes

blank

to ignore browser notes during the selection

List/Report Selection panel (Page 2)

PE97BR01 --------------------------------------------------------- Page 2 of 2
 Command ===> __________________________________________________________________

 Select Lists/Reports

 Optional Selection Criteria:

 Layout ===> LIST__ (J)ob,(L)ist,(S)tatus,(U)ser
 Display with Title ===> NO_ (Y)es,(N)o
 Select by Type ===> ALL___ (L)ist,(R)eport,(A)ll
 Select by Online ===> ___ (Y)es,(N)o
 Select by Archive ===> ___ (Y)es,(N)o,archive (P)ending
 Marked for Viewable ===> YES (Y)es,(N)o,(A)ll
 Marked for Reload ===> ___ (Y)es,(N)o
 Marked for Delete ===> ___ (Y)es,(N)o
 Sort Order ===> DESCENDING (A)scending,(D)escending
 By Primary Key ===> DATE_____ (D)ate and Time, (J)obname,
 Secondary Key ===> JOBNAME__ (F)orm,(E)xtension,(R)eport,(T)itle
 Execute the Macro ===> NO_ (Y)es,(N)o


 Press ENTER to display the lists/reports. Press UP to display the previous
 page. Press END to return to the previous menu.

Fields (Page 2)

Field

Description

Layout

Here you can enter the layout type for the "List/Report Selection Table":

  • User
    The user defined layout is used for the "List/Report Selection Table" display when you select User. In case the message MEPMI242 - User Layout not defined appears, you have not yet defined a layout.
  • other values
    Whether the options Job, List or Status cause the display of the layout of the same name depends on the configuration of your system.

Display with Title

This is not a selection criterion. Enter Yes to use a two-line display for each list in the List/Report Selection table, which includes the list title.

Select by Type

Valid entries are:

List

limits the selection to lists

Report

limits the selection to reports

All

lists as well as reports are selected

Select by Online

Enter one of the following:

Yes

to select online lists only

No

to select offline lists only

blank

to select both online and offline lists

Select by Archive

Enter one of the following:

Yes

to select only lists that have been archived

No

to select only lists that are not archived

Pend

to select only lists marked for archiving

blank

to ignore archive status during the selection

Marked for Viewable

Enter one of the following:

Yes or blank

to select only lists that are viewable

No

to select only lists that have been marked 'not viewable'

All

to select lists that are viewable (View = Yes) and lists that are 'not viewable' (View = No)

Marked for Reload

Enter one of the following:

Yes

to select only lists that have been marked for reloading

No

to select only lists that have not been marked for reloading

blank

to ignore this criterion during the selection

Marked for Delete

Enter one of the following:

Yes

to select only lists that have been marked for deleting

No

to select only lists that have not been marked for deleting

blank

to ignore this criterion during the selection

Sort Order/
By Primary Key/
Secondary Key

This is not a selection criterion. By default, lists are sorted by date/time in descending order, that is, the most recent lists are displayed at the top of the table.

You can change the sort order from descending to ascending or you can change the sort criteria by specifying one of the following under primary and secondary key:

  • (D)ate and Time
  • (J)obname
  • (F)orm
  • (E)xtension
  • (R)eport
  • (T)itle

Execute the macro

Enter one of the following:

No

No views/macros are executed

Yes

When displaying hit pages or the entire list, Adabas Audit Data Retrieval checks whether there are views/macros for this list and this user.

The Beta Browser reacts as follows if Yes:

  • If no view/macro exists, the first (hit) page is displayed.
  • If one view/macro exists, the list or hit pages are displayed in the Browser and the commands contained in the view are executed.
  • If several views/macros exist, the views/macros are displayed in a table for selection.

Note on generic folder selection

The following LST parameter determines whether it is possible to enter a mask in the Folder field:

  • B97_FOLDER_SELECTION_GENERIC

Note on Autoselection

If the Autoselect field in the user profile (option P.3) or in the user definition (option C.1) contains Yes, choosing option 1 (BROWSE) will not display the List/Report Selection panel and choosing option I (INDEX) will not display the List/Report Selection via Indexes panel. Instead, it will carry out the selection automatically and display the List/Report Selection table.

For more information on Autoselection, see "Jobcard and auto-selection (Option P.3)" and "User profiles defined by the administrator".

For information on how Adabas Audit Data Retrieval must be called in order to process the user profiles defined under option C.1, see the corresponding section in the Adabas Audit Data Retrieval Installation and System Guide.