Plugin installed incorrectly. Rename plugin directory 'swiftmail.backup' to 'swiftmail'.
en:software:dashboard:dashboard_tablestructure_v2
Differences
This shows you the differences between two versions of the page.
| Both sides previous revision Previous revision Next revision | Previous revision | ||
|
en:software:dashboard:dashboard_tablestructure_v2 [2018/07/11 15:14] Julian Le |
en:software:dashboard:dashboard_tablestructure_v2 [2021/07/01 09:52] (current) |
||
|---|---|---|---|
| Line 2: | Line 2: | ||
| Evaluations are defined by SQL statements. Therefore only the following predefined [[:software:dashboard:dashboard_views|database views]] can be used. | Evaluations are defined by SQL statements. Therefore only the following predefined [[:software:dashboard:dashboard_views|database views]] can be used. | ||
| - | |||
| - | <WRAP center round important 60%>\\ | ||
| - | The view "view_user" is only compatible with SQL Server 2017 and with MySQL v5.7 or higher!\\ | ||
| - | </WRAP>\\ | ||
| - | <note tip>Please take into account the explanations below!</note> | ||
| ---- | ---- | ||
| Line 217: | Line 212: | ||
| * **parentFolderId**: contains the primary key which points to itself and represents a subfolder in the documents | * **parentFolderId**: contains the primary key which points to itself and represents a subfolder in the documents | ||
| * **isArchiv**: | * **isArchiv**: | ||
| - | === view_user === | ||
| - | |||
| - | * **id**: | ||
| - | * **identityName**: | ||
| - | * **clientId**: | ||
| - | * **creationTime**: | ||
| - | * **creationUserId**: | ||
| - | * **displayName**: contains the full name and username (e.g. **Max Mustermann (M.Muster)**) | ||
| - | * **lastLogin**: contains the time when the user last logged in | ||
| - | * **identityType**: contains in this view only 'USER' | ||
| - | * **email**: e-mail adress of the user or group | ||
| - | * **firstname**: First Name of the user | ||
| - | * **lastname**: Last Name of the user | ||
| - | * **userProfileId**: contains the primary key that contains the userprofile | ||
| - | * **groups**: contains all group names (seperated with commas) in which the user is a member | ||
| - | * **teammanagerGroups: ** contains all group names (seperated with commas) in which the user is a team manager | ||
| - | * **isBlocked**: states if the process instance is blocked or not | ||
| - | * **isArchiv**: states if the process instance is archived or not | ||
en/software/dashboard/dashboard_tablestructure_v2.1531314846.txt.gz · Last modified: 2021/07/01 09:55 (external edit)
Except where otherwise noted, content on this wiki is licensed under the following license: 2013 T!M Solutions GmbH
