Roles
Query from roles table
Table Specific Information
Select
The connector will use the Freshdesk API to process WHERE clause conditions built with the following columns and operators. Most of the columns support server side filtering with the following operators: =,>,<,<=,>=,AND,OR. The rest of the filter is executed client side within the connector.
For example, the following query is processed server side:
SELECT * FROM Roles WHERE Id = 100
Note: Only users with admin privileges can access the following Table. Following is an example of selecting a role:
Columns
| Name | Type | ReadOnly | Description |
| Id [KEY] | Bigint | False |
Role ID. |
| Description | String | False |
Description of the role. |
| Name | String | False |
Name of the role. |
| Default | Boolean | False |
Indicates if role is default. |
| CreatedAt | Datetime | True |
Role creation timestamp. |
| UpdatedAt | Datetime | True |
Role updated timestamp. |