Navigation:  Meeting >

Created meetings

 Previous  Top  Next

Overview

This command will list the data displayed in the fields of the meeting data screen.

 

Related tables

TABLE

Description

Primary key (PK)

Connection tables

GNMEETING

Stores the meeting data

CDMEETING

SERICHTEXT

GNMEETINGTYPE

GNMEETINGUSERS

SERICHTEXT

Stores data of the Comments field of the meeting

OID

SETEXT

SETEXT

Stores the content of the Comments field of the meeting

OID

GNGENTYPE

Stores the meeting type data

CDGENTYPE

GNMEETINGUSERS

Stores the meeting participants

CDMEETING

CDUSER

GNMEETING

ADALLUSERS

ADALLUSERS

Stores the meeting participants data

CDUSER

GNMEETINGEXTERNALUSERS

Stores the external meeting participants

CDEXTERNALUSER

GNMEETING

 

Oracle/Postgres/SQL Server

SELECT
   GNMEETING.IDMEETING,
   GNMEETING.NMMEETING,
   GNGENTYPE.IDGENTYPE,
   GNGENTYPE.NMGENTYPE,
   RESP.IDUSER,
   RESP.NMUSER,
   GNMEETING.DSPLACE,
   GNMEETING.DTSCHEDULEDST,
   GNMEETING.TMSCHEDULEDST,
   GNMEETING.DTSCHEDULEDEND,
   GNMEETING.TMSCHEDULEDEND,
   GNMEETING.DTACTST,
   GNMEETING.TMACTST,
   GNMEETING.DTACTEND,
   GNMEETING.TMACTEND,
   SETEXT.TXDATA,
   ADALLUSERS.IDUSER,
   ADALLUSERS.NMUSER,
   GNMEETINGUSERS.FGRELATER,
   GNMEETINGEXTERNALUSERS.NMEXTERNALUSER
FROM GNMEETING
INNER JOIN ADALLUSERS RESP ON RESP.CDUSER = GNMEETING.CDUSER
LEFT JOIN SERICHTEXT ON SERICHTEXT.OID = GNMEETING.OIDNOTES
LEFT JOIN SETEXT ON SETEXT.OID = SERICHTEXT.OIDTEXTCONTENT
LEFT JOIN GNGENTYPE ON GNMEETING.CDMEETINGTYPE = GNGENTYPE.CDGENTYPE
LEFT JOIN GNMEETINGUSERS ON GNMEETINGUSERS.CDMEETING = GNMEETING.CDMEETING
LEFT JOIN ADALLUSERS ON ADALLUSERS.CDUSER = GNMEETINGUSERS.CDUSER
LEFT JOIN GNMEETINGEXTERNALUSERS ON GNMEETINGEXTERNALUSERS.CDMEETING = GNMEETING.CDMEETING

 

Fields used on the view screen

 

meeting-01

 

#

Field ID

Type

Description

1

GNMEETING.IDMEETING

VARCHAR(50) NULL

2

GNMEETING.NMMEETING

VARCHAR(255) NULL

3

GNGENTYPE.IDGENTYPE

GNGENTYPE.NMGENTYPE

VARCHAR(50) NULL

VARCHAR(255) NULL

4

RESP.IDUSER

RESP.NMUSER

VARCHAR(50) NULL

VARCHAR(255) NULL

5

GNMEETING.DSPLACE

TEXT NULL

6

GNMEETING.DTSCHEDULEDST

DATE TIME NULL

7

GNMEETING.TMSCHEDULEDST

VARCHAR(8) NULL

8

GNMEETING.DTSCHEDULEDEND

DATE TIME NULL

9

GNMEETING.TMSCHEDULEDEND

VARCHAR(8) NULL

10

GNMEETING.DTACTST

DATE TIME NULL

11

GNMEETING.TMACTST

VARCHAR(8) NULL

12

GNMEETING.DTACTEND

DATE TIME NULL

13

GNMEETING.TMACTEND

VARCHAR(8) NULL

14

SETEXT.TXDATA

VARCHAR(MAX) NULL

15

ADALLUSERS.IDUSER

ADALLUSERS.NMUSER

VARCHAR(50) NULL

VARCHAR(255) NULL

16

GNMEETINGUSERS.FGRELATER

NUMERIC(2,0) NULL

1- Reporter

2– Participant

17

GNMEETINGEXTERNALUSERS.NMEXTERNALUSER

VARCHAR(255) NULL