Navigation: Document >

Users with publication acknowledgment

Overview

This command will display the list of users with publication acknowledgment for a certain document and the date of the acknowledgment.

Related tables

Table	Description	Primary key (PK)	Connection tables
DCDOCUMENTUSER	Users with publication acknowledgment and/or training	CDDOCUMENT CDREVISION CDUSER	DCDOCREVISION ADUSER
DCDOCREVISION	Document	CDDOCUMENT CDREVISION	DCDOCUMENTUSER
ADUSER	User	CDUSER	DCDOCUMENTUSER

Oracle/Postgres/SQL Server

SELECT NMUSER , DTKNOWLEDGE
   FROM ADUSER U, DCDOCUMENTUSER DU, DCDOCREVISION DR
   WHERE U.CDUSER = DU.CDUSER
   AND DU.CDREVISION = DR.CDREVISION
   AND DU.FGKNOWLEDGE = 1 /*NOTE1*/
   AND DR.FGCURRENT = 1 /*NOTE2*/
   AND DR.IDDOCUMENT = 'Document ID' /*NOTE3*/
ORDER BY NMUSER

Notes

▪1: The DU.FGKNOWLEDGE indicates whether the user must acknowledge the document (value =1 needs acknowledgment).

▪2: The DR.FGCURRENT field indicates whether the revision is current. In this case, a value = 1 returns only from the current revision of the document. To return from all revisions, simply remove this condition from the instruction.

▪3: To return the result of a document, it is necessary to enter its ID #, exactly as displayed in the data screen, between single quotation marks.

Fields used on the view screen

document-01

#	Field ID	Type	Description
1	U.NMUSER	VARCHAR(255)
2	DU.DTKNOWLEDGE	DATETIME NULL	If it returns blank, it indicates that the user has yet to execute the publication acknowledgment task.
3	DR.IDDOCUMENT	VARCHAR(50)	ID # that must be entered in the SQL command.