CaseRelations

The CaseRelations dataset contains data regarding related cases.

Importing to a BI database

Case relations can change continuously. This makes it necessary to ensure during periodic runs that the latest changes are included and that obsolete data is deleted. Delete the existing table in your BI database and import the latest version.

Column overview

The following table describes the columns available in the dataset. The table includes the following information about each column:

  • Dataset name: The column’s name in the dataset.

  • Description: Describes the column’s content and function.

  • Reference to other dataset: Specifies references to other datasets, if any.

  • Format: Specifies the format of the returned values.

  • Length: Specifies the length of the returned values, if any.

  • Examples: Examples of returned values.

Dataset name Description Reference to other dataset Format Length Examples

InternalCase RelationId

The internal database ID of the case relation.

bigint identity

6

98

InternalCaseId

The internal database ID of the case.

Cases

bigint

5112

2065

RelatedInternal CaseId

The internal database ID of the related case.

Cases

bigint

19729

8698

RelationType

The type of relation between two cases.

varchar

10

Related

Parent

Duplicated