Overview
This command will list the meeting data in the scheduling, scheduling confirmation, and minutes steps.
Related tables
TABLE
|
Description
|
Primary key (PK)
|
Connection tables
|
GNMEETING
|
Stores the meeting data
|
CDMEETING
|
GNMEETINGUSERS
|
GNMEETINGUSERS
|
Stores the meeting participants
|
CDMEETING
CDUSER
|
GNMEETING
ADALLUSERS
|
ADALLUSERS
|
Stores the meeting participants data
|
CDUSER
|
|
Oracle/Postgres/SQL Server
SELECT
GNMEETING.IDMEETING,
GNMEETING.NMMEETING,
GNMEETING.DTSCHEDULEDST,
GNMEETING.TMSCHEDULEDST,
GNMEETING.DTSCHEDULEDEND,
GNMEETING.TMSCHEDULEDEND,
GNMEETING.DTACTST,
GNMEETING.TMACTST,
GNMEETING.DTACTEND,
GNMEETING.TMACTEND,
GNMEETING.FGPHASE,
ADALLUSERS.NMUSER
FROM
GNMEETING
INNER JOIN
GNMEETINGUSERS ON GNMEETINGUSERS.CDMEETING = GNMEETING.CDMEETING
INNER JOIN
ADALLUSERS ON ADALLUSERS.CDUSER = GNMEETINGUSERS.CDUSER
WHERE
GNMEETING.FGPHASE IN (1,2,3) /* NOTE 1 */ AND ADALLUSERS.IDUSER = 'USER_ID' /* NOTE 2 */
|
Notes
▪1: The FGPHASE = 1, 2 or 3 field determines that only meetings in the scheduling, scheduling confirmation, and minutes steps will be displayed. ▪2: User ID to be filtered in the search.
Fields used on the view screen
#
|
Field ID
|
Type
|
Description
|
1
|
GNMEETING.IDMEETING
|
VARCHAR(50) NULL
|
|
2
|
GNMEETING.NMMEETING
|
VARCHAR(255) NULL
|
|
3
|
GNMEETING.DTSCHEDULEDST
|
DATE TIME NULL
|
|
4
|
GNMEETING.TMSCHEDULEDST
|
VARCHAR(8) NULL
|
|
5
|
GNMEETING.DTSCHEDULEDEND
|
DATE TIME NULL
|
|
6
|
GNMEETING.TMSCHEDULEDEND
|
VARCHAR(8) NULL
|
|
7
|
GNMEETING.DTACTST
|
DATE TIME NULL
|
|
8
|
GNMEETING.TMACTST
|
VARCHAR(8) NULL
|
|
9
|
GNMEETING.DTACTEND
|
DATE TIME NULL
|
|
10
|
GNMEETING.TMACTEND
|
VARCHAR(8) NULL
|
|
11
|
GNMEETING.FGPHASE
|
NUMERIC(2,0) NULL
|
1- Scheduling
2- Scheduling confirmation
3- Minutes
|
12
|
ADALLUSERS.NMUSER
|
VARCHAR(255) NULL
|
|
|