Previous Topic: Report GroupsNext Topic: Selection Criteria Coding Rules

Reporting › Running Reports › Selection Criteria

Selection Criteria

Reports will display all records in the CCDB unless additional selection criteria are given to limit the volume. Selection criteria are specified in the SYSIN data set according to standard CA Culprit conventions. Commonly used selection criteria are outlined below. Additionally, any field in the database may be used as a selector. Appendix B contains the record layout used by CA Endevor/DB reports.

Criteria

Description

LOG-DATE

Date of change log entries. Rules:

  • Specified as yyyymmdd
  • Must not be surrounded by single quotes

Example: LOG-DATE GT 19861201

ENTITY-NAME

Name of entity in change log entries. Rules:

  • 1-40 character name
  • Must be surrounded by single quotes

Example: ENTITY-NAME EQ 'ADSO-STAT'

ENTITY-VERSION

Version of entity in change log entries. Rules:

  • 4-digit number 0-9999
  • Must not be surrounded by single quotes

Example: ENTITY-VERSION NE 1

USER

User name in change log entries. Rules:

  • 1-32 character name
  • Must be surrounded by single quotes

Example: USER EQ 'JONES'

ACTION

Action in change log entries. Rules:

  • 1-character code: A, M, D, R, S, T, P, C (add, modify, delete, status, reset status set, status terminate, purged, and compressed)
  • Must be surrounded by single quotes

Example: ACTION EQ 'D'