ArchivelogDetails
| The content of this website is last updated to F2 version 11. cBrain are working hard on supplying you with the newest documentation of F2. |
The ArchivelogDetails dataset contains data regarding events that took place in F2.
Importing to a BI database
The dataset is a log, which means there are no retroactive changes to the data. Periodic runs will continuously add new data to the table.
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 |
|---|---|---|---|---|---|
Id |
The ID of the action. |
bigint identity |
12 96 |
||
archiveLogId |
The ID of the action as logged in Archivelog. |
bigint |
73 64868 |
||
objecttype |
The type of object affected by the action. |
nvarchar |
100 |
F2Dossier NodeParty |
|
attributename |
The field of the object affected by the action. |
nvarchar |
2048 |
Title AccessType |
|
FROM |
The value in the field prior to the action. |
nvarchar |
2000 |
InProgress 08-01-2021 FALSE |
|
To |
The value in the field after the action. |
nvarchar |
2000 |
Closed 17-01-2021 TRUE |