Roles
Query from roles table
Table Specific Information
Select
The add-in 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 add-in.
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. |