Navigation: Process >

Data source in the process

Overview

This command will list processes 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
PMSTRUCT	Process structure table (Process items)	PKPMSTRUCT
PMACTREVISION	Process revision table	PMACTREVISION
GNREVISION	Revision table	PKGNREVISION

Oracle/Postgres/SQL Server

SELECT
   REV.IDACTIVITY,
   REV.NMACTIVITY,
   GNR.IDREVISION,
   PMS.IDACTIVITY AS IDSTRUCT,
   PMS.NMACTIVITY AS NMSTRUCT
FROM
   GNDATASOURCE GND
   INNER JOIN GNWS WS ON GND.OID = WS.OIDWSDATASOURCE
   INNER JOIN PMSTRUCT PMS ON WS.CDWS = PMS.CDWSCONFIG
   INNER JOIN PMACTREVISION REV ON PMS.CDPROC = REV.CDACTIVITY AND PMS.CDREVISION =REV.CDREVISION
   INNER JOIN GNREVISION GNR ON REV.CDREVISION = GNR.CDREVISION
WHERE
   GND.IDDATASOURCE = 'wf' /*NOTE1*/

Notes

▪1: Process ID #.

Fields used on the view screen

processo-02

#	Field ID	Type	Description
1	IDACTIVITY	VARCHAR(50)	Field of the PMACTREVISION table
2	NMACTIVITY	VARCHAR(255)	Field of the PMACTREVISION table
3	IDREVISION	VARCHAR(50)	Field of the GNREVISION table
4	NMDEPARTMENT	VARCHAR(50)	Field of the PMSTRUCT table
5	NMACTIVITY	VARCHAR(255)	Field of the PMSTRUCT table