Navigation: Meeting >

Meeting subjects

Overview

This command will list the subjects of a certain meeting.

Related tables

TABLE	Description	Primary key (PK)	Connection tables
GNMEETING	Stores the meeting data	CDMEETING	GNMEETINGSUBJECT
GNMEETINGSUBJECT	Stores the meeting subjects	CDMEETING CDSUBJECT	GNMEETING ADALLUSERS SERICHTEXT
ADALLUSERS	Stores the data of those responsible for meeting subjects	CDUSER
SERICHTEXT	Stores data of the Comments and Meeting subject decision fields	OID	SETEXT
SETEXT	Stores the content of the Comments and Meeting subject decision fields	OID

Oracle/Postgres/SQL Server

SELECT
   GNMEETING.IDMEETING,
   GNMEETING.NMMEETING,
   GNMEETINGSUBJECT.NMSUBJECT,
   ADALLUSERS.NMUSER,
   TEXTOBSERVATION.TXDATA,
   TEXTDECISION.TXDATA AS DATADECISION
FROM
   GNMEETING
INNER JOIN
   GNMEETINGSUBJECT ON GNMEETINGSUBJECT.CDMEETING = GNMEETING.CDMEETING
LEFT JOIN
   ADALLUSERS ON ADALLUSERS.CDUSER = GNMEETINGSUBJECT.CDRESPONSIBLE
LEFT JOIN
   SERICHTEXT ON SERICHTEXT.OID = GNMEETINGSUBJECT.OIDOBSERVATION
LEFT JOIN
   SETEXT TEXTOBSERVATION ON TEXTOBSERVATION.OID = SERICHTEXT.OIDTEXTCONTENT
LEFT JOIN
   SERICHTEXT DECISION ON DECISION.OID = GNMEETINGSUBJECT.OIDDECISION
LEFT JOIN
   SETEXT TEXTDECISION ON TEXTDECISION.OID = DECISION.OIDTEXTCONTENT
WHERE
   GNMEETING.IDMEETING = 'MEETING_ID' /* NOTE 1 */ ORDER BY GNMEETINGSUBJECT.CDSUBJECT /* NOTE 2 */

Notes

▪1: ID # of the meeting to be filtered in the search.

▪2: Sorting the search by the subjects.

Fields used on the view screen

meeting-03

#	Field ID	Type	Description
1	GNMEETING.IDMEETING	VARCHAR(50) NULL
2	GNMEETING.NMMEETING	VARCHAR(255) NULL
3	GNMEETINGSUBJECT.NMSUBJECT	VARCHAR(255) NULL
4	ADALLUSERS.NMUSER	VARCHAR(255) NULL
5	TEXTOBSERVATION.TXDATA	VARCHAR(MAX) NULL
6	TEXTDECISION.TXDATA AS DATADECISION	VARCHAR(MAX) NULL