UDF Signature and Output Format

The UDF signature is as follows:

def igrafxCaseEvents(caseId: String, projectId: String, workgroupId: String, workgroupKey: String, host: String, port: String): util.List[Struct]

The output is an array of structs with the structure:

STRUCT<START_DATE VARCHAR(STRING), END_DATE VARCHAR(STRING), VERTEX_NAME VARCHAR(STRING)>
  • START_DATE corresponds to the __time column.
  • END_DATE corresponds to the enddate column.
  • VERTEX_NAME corresponds to the vertex_name column.

An array of these structs is returned to provide information for each row associated with the specified caseId.

Furthermore, the SQL query executed by this UDF is as follows:

SELECT __time AS startdate, enddate, vertex_name AS vertexName
FROM "projectId_vertex"
WHERE vertex_name is not NULL AND caseid = 'caseIdParam'

In this query: - projectId corresponds to the iGrafx project ID. - caseIdParam is the caseId parameter provided to the UDF.