Grid records of the form of an instance

Table	Description	Primary key (PK)	Connection tables
WFPROCESS	Workflow table	PKWFPROCESS	GNASSOCFORMREG
GNASSOCFORMREG	Table of the association of form records with workflows	PKGNASSOCFORMRE	WFPROCESS
DYNTABELAP	Pivot table of the form in which the grid is added.
DYNTABELAG	Grid form pivot table.

Oracle/Postgres/SQL Server

SELECT
   GRID.ATIVID
   ,GRID.RESPONSAVEL
   ,GRID.DATA01
FROM
   WFPROCESS WFP
   INNER JOIN GNASSOCFORMREG GNA ON WFP.CDASSOCREG = GNA.CDASSOC
   INNER JOIN DYNTABELAP DYNP ON GNA.OIDENTITYREG = DYNP.OID /* NOTE1 */
   INNER JOIN DYNTABELAG GRID ON DYNP.OID = GRID.OIDABCX8N5X6FJXLGO /*NOTE2 */
WHERE
   WFP.IDPROCESS='001154' /* NOTE3 */

Notes

▪NOTE1: INNER JOIN will take the information on the GNASSOCFORMREG table with DYNTABELAP, which would be the pivot table related to the form to which the grid is added. To know the name of the pivot table in the database, simply take the form table ID # and add the prefix DYN. For example: The main form table ID # is TABELAP; with the prefix, it becomes DYNTABELAP. The relationship between the GNASSOCFORMREG table and the DYNTABELAP table is performed through the OIDENTITYREG column on the GNASSOCFORMREG table with the OID column on the DYNTABELAP table. For example: GNASSOCFORMREG. OIDENTITYREG = DYNTABELAP.OID.

▪NOTE2: INNER JOIN will take the information on the DYNTABELAP table with DYNTABELAG, which has the information of the records that were added to the grid. The relationship between the DYNTABELAP table and the DYNTABELAG table is performed through the OID column on the DYNTABELAP table with the OIDABCX8N5X6FJXLGO column on the DYNTABELAG table. For example: DYNTABELAP.OID = DYNTABELAG.OIDABCX8N5X6FJXLGO. OIDABCX8N5X6FJXLGO refers to the relationship created between both tables to know which record from DYNTABELAG belongs to the record of the DYNTABELAP table, to know which is the OID of the relationship of your grid.

Fields used on the view screen

#	Field ID	Type	Description
1	ATIVID*	VARCHAR(255)	Fields of the DYNTABELAG pivot table; the type will depend on the configured field.
2	RESPONSAVEL*	VARCHAR(255)	Fields of the DYNTABELAG pivot table; the type will depend on the configured field.
3	DATA01*	Date	Fields of the DYNTABELAG pivot table; the type will depend on the configured field.
4	IDPROCESS	VARCHAR(50)	Field of the WFPROCESS table

Grid records of the form of an instance

Overview

Related tables

Oracle/Postgres/SQL Server

Notes

Fields used on the view screen