Navigation: Workflow >

Data source in the workflow

Overview

This command will list workflow activities that are using a certain data source.

Related tables

Table	Description	Primary key (PK)	Connection tables
GNDATASOURCE	Data source table	PKGNDATASOURCE
GNWS	Web Service configuration table	PKGNWS
WFSTRUCT	Workflow flowchart item table	PKWFSTRUCT
WFPROCESS	Workflow table	PKWFPROCESS

Oracle/Postgres/SQL Server

SELECT
   WFP.IDPROCESS,
   WFP.NMPROCESS,
   WFS.IDSTRUCT,
   WFS.NMSTRUCT
FROM
   GNDATASOURCE GND
   INNER JOIN GNWS WS ON GND.OID = WS.OIDWSDATASOURCE
   INNER JOIN WFSTRUCT WFS ON WS.CDWS = WFS.CDWSCONFIG
   INNER JOIN WFPROCESS WFP ON WFS.IDPROCESS = WFP.IDOBJECT
WHERE
   GND.IDDATASOURCE = 'Workflow' /* NOTE1 */

Notes

▪1: : Data source ID # obtained according to the image below:

wf-004

Fields used on the view screen

#	Field ID	Type	Description
1	IDPROCESS	VARCHAR(50)	Field of the WFPROCESS table
2	NMPROCESS	VARCHAR(255)	Field of the WFPROCESS table
3	IDSTRUCT	VARCHAR(50)	Field of the WFSTRUCT table
4	NMSTRUCT	VARCHAR(255)	Field of the WFSTRUCT table