Overview

This command will list the event logs associated with a collection.

Related tables

TABLE	Description	Primary key (PK)	Connection tables
SCCOLLECTEVENTLOG	Sample event log record	CDCOLLECT CDCHARACTERISTIC CDSAMPLE NRSEQUENCESAMPLE CDEVENTLOG	SCCHARACITEMCOLL SCEVENTLOG SCOCCURRENCE
SCCHARACITEMCOLL	Data collection characteristics record	CDCOLLECT CDCHARACTERISTIC	SCCOLLECTEVENTLOG SCCOLLECT
SCCOLLECT	Data collection configuration record	CDCOLLECT	SCCHARACITEMCOLL
SCEVENTLOG	Reasons for opening event log	CDEVENTLOG	SCCOLLECTEVENTLOG
SCOCCURRENCE	Occurrence record	CDOCCURRENCE	SCCOLLECTEVENTLOG

Oracle/Postgres/SQL Server

SELECT
   SCLOG.NRSEQUENCESAMPLE,
   OCC.NMOCCURRENCE,
   SCLOG.DTOCCURRENCE
FROM
   SCCOLLECTEVENTLOG SCLOG
   INNER JOIN SCCHARACITEMCOLL SCCHARITCOLL ON (SCLOG.CDCOLLECT = SCCHARITCOLL.CDCOLLECT AND SCLOG.CDCHARACTERISTIC = SCCHARITCOLL.CDCHARACTERISTIC)
     INNER JOIN SCCOLLECT COL ON (SCCHARITCOLL.CDCOLLECT = COL.CDCOLLECT)
   LEFT JOIN SCEVENTLOG SCE ON (SCLOG.CDEVENTLOGCALL = SCE.CDEVENTLOG)
   LEFT JOIN SCOCCURRENCE OCC ON (SCLOG.CDOCCURRENCE = OCC.CDOCCURRENCE)
WHERE
   COL.IDCOLLECT = 'COLLECTION ID' /* NOTE1 */
   AND SCCHARITCOLL.IDCHARACTERISTIC = 'CHAR ID' /* NOTE2 */
ORDER BY
   SCLOG.NRSEQUENCESAMPLE

Notes

▪1: Collection ID #.

▪2: Characteristic ID #.

Fields used on the view screen

cep-03

#	Field ID	Type	Description
1	NRSEQUENCESAMPLE	NUMERIC(10)	Sample #
2	NMOCCURRENCE	VARCHAR(255)	Occurrence
3	DTOCCURRENCE	DATETIME	Occurrence date

Event logs

Overview

Related tables

Oracle/Postgres/SQL Server

Notes

Fields used on the view screen