# AssignedWorkflowAllowedTransitionssByEmployerId Workflows assigned to the user __Activity name:__ GetAssignedWorkflowsByEmployerId Get the list workflows that are assigned to the user or the role of the user. This is a read-only table function. The Loket.nl REST API may not support changing the data, or the Invantive UniversalSQL driver for Loket.nl REST does not support it. In the latter case, use the table NativePlatformScalarRequests to upload data to the Loket.nl REST API. - Catalog: `LoketNlRest` - Schema: `Workflows` ## Parameters of Table Function | Name | Data Type | Required | Default Value | Documentation | |---|:---:|:---:|:---:|---| | `employerId` | `guid` | ☑ | | The unique identifier of the employer | ## Columns The columns of the table `AssignedWorkflowAllowedTransitionssByEmployerId` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `assignee_role_description` | `string` | | ☐ | A description of the role. | | `assignee_role_id` | `guid` | Assigned Person Role ID | ☐ | The unique identifier of an object (GUID/UUID) | | `assignee_user_formattedName` | `string` | | ☐ | preformatted user name for displaying. \<lastname\>\", \"\<initials\>\" \"\<prefix\> | | `assignee_user_id` | `guid` | Assigned User ID | ☐ | The unique identifier of an object (GUID/UUID) | | `assignee_user_initials` | `string(6)` | Assigned User Initials | ☐ | The initials of the user | | `assignee_user_lastName` | `string(25)` | Assigned User Last Name | ☐ | The last name of the user | | `assignee_user_prefix` | `string(10)` | Assigned User Name Prefix | ☐ | The prefix of the user | | `data` | `string` | Data | ☐ | A JSON representation of the mutation/data regarding this workflow | | `description` | `string(256)` | Description | ☐ | The description of the transition (task) | | `href` | `string` | HREF | ☐ | | | `httpVerb` | `string` | HTTP Verb | ☐ | | | `id` | `guid` | ID | ☐ | The unique identifier of an object (GUID/UUID) | | `initiatedBy_formattedName` | `string` | Initiated By Name | ☐ | preformated user name for displaying. \<lastname\>\", \"\<initials\>\" \"\<prefix\> | | `initiatedBy_id` | `guid` | Initiated By ID | ☐ | The unique identifier of an object (GUID/UUID) | | `initiatedBy_initials` | `string(6)` | Initiated By Initials | ☐ | The initials of the user | | `initiatedBy_lastName` | `string(25)` | Initiated By Last Name | ☐ | The last name of the user | | `initiatedBy_prefix` | `string(10)` | Initiated By Name Prefix | ☐ | The prefix of the user | | `initiatedOn` | `datetime` | Initiated On | ☐ | | | `lastModifiedBy_formattedName` | `string` | | ☐ | preformated user name for displaying. \<lastname\>\", \"\<initials\>\" \"\<prefix\> | | `lastModifiedBy_id` | `guid` | | ☐ | The unique identifier of an object (GUID/UUID) | | `lastModifiedBy_initials` | `string(6)` | | ☐ | The initials of the user | | `lastModifiedBy_lastName` | `string(25)` | | ☐ | The last name of the user | | `lastModifiedBy_prefix` | `string(10)` | | ☐ | The prefix of the user | | `lastModifiedOn` | `datetime` | | ☐ | date and time on which the last modification on the workflow was performed. This can be either by the system or a user. | | `status_key` | `int32` | Status Code | ☐ | The unique identifier | | `status_value` | `string` | Status Value | ☐ | | | `trigger_description` | `string` | Trigger Description | ☐ | | | `trigger_id` | `guid` | Trigger ID | ☐ | The unique identifier of an object (GUID/UUID) | | `workflowTemplate_description` | `string(256)` | | ☐ | | | `workflowTemplate_id` | `guid` | | ☐ | The unique identifier of an object (GUID/UUID) | | `workflowTemplate_version` | `int32` | | ☐ | The version of the workflow template this workflow was based on. Changes to a workflow template do not affect existing workflows. |