Navigation: Form >

Data source in the form

Overview

This command will return forms that are using a certain data source.

Related tables

TABLE	Description	Primary key (PK)	Connection tables
GNDATASOURCE	Table to store ODBC data sources	PKGNDATASOURCE
GNWS	Webservice configuration table	PKGNWS
EFSTRUCTFORM	Form structure table	PKEFSTRUCTFORM
EFREVISIONFORM	Table that stores information regarding form revision	PKEFREVISIONFORM
GNREVISION	Revision table	PKGNREVISION

Oracle/Postgres/SQL Server

SELECT
   REV.IDFORM,
   REV.NMFORM,
   GNR.IDREVISION,
   EFS.NMLABEL
FROM
   GNDATASOURCE GND
   INNER JOIN GNWS WS ON GND.OID = WS.OIDWSDATASOURCE
   INNER JOIN EFSTRUCTFORM EFS ON WS.CDWS = EFS.CDWSCONFIG
   INNER JOIN EFREVISIONFORM REV ON EFS.OIDREVISIONFORM = REV.OID
   INNER JOIN GNREVISION GNR ON REV.CDREVISION = GNR.CDREVISION
WHERE
   GND.IDDATASOURCE = 'wf' /* NOTE 1 */

Notes

▪1: Data source ID #.

Fields used on the view screen

form-02

#	Field ID	Type	Description
1	IDDATASOURCE	VARCHAR(50)	Data source ID #