TicketFields
Query from ticketFields table
Table Specific Information
Note: Users whose credentials (identified by the API key) are used to access the Table should be authorised to either view the ticket fields or create a new ticket.
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 client side filtering with the following operators: =,>,<,<=,>=,AND,OR. The rest of the filter is executed server side within the connector.
For example, the following query is processed server side:
SELECT * FROM TicketFields WHERE Type = 'default_requester'
The Freshdesk API allows only the following column(s) to be used as filter criteria in the WHERE clause:
- Type
Insert
Label, LabelForCustomers and Type are mandatory columns for Inserting into TicketFields table.
INSERT INTO TicketFields (Label, LabelForCustomers, Type) VALUES ('labelA', 'labelA', custom_text)
Update
Following is an example to update TicketFields:
UPDATE TicketFields SET Label = 'updated label' WHERE Id = 100
Delete
Following is an example to delete a TicketFields:
DELETE FROM TicketFields WHERE Id = 100
Columns
Name | Type | ReadOnly | Description |
Id [KEY] | Bigint | True |
ID of the ticket field. |
Choices | String | False |
List of values supported by the field. |
CreatedAt | Datetime | True |
Ticket field creation timestamp. |
CustomersCanEdit | Boolean | False |
Set to true if the field can be updated by customers. |
Default | Boolean | True |
Set to true if the field is not a custom field. |
Description | String | True |
Description of the ticket field |
DisplayedToCustomers | Boolean | False |
Set to true if the field is displayed in the customer portal. |
Label | String | False |
Display name for the field (as seen by agents). |
LabelForCustomers | String | False |
Display name for the field (as seen in the customer portal). |
Name | String | True |
Name of the ticket field. |
NestedTicketFields | String | True |
Applicable only for dependent fields, this contain details of nested fields. |
PortalCc | Boolean | True |
Applicable only for the requester field. Set to true if customer can add additional requesters to a ticket. |
PortalCcTo | String | True |
Applicable only if portal_cc is set to true. Value will be 'all' when a customer can add any requester to the CC list and 'company' when a customer can add only company contacts to the CC list. |
Position | Integer | False |
Position in which the ticket field is displayed in the form. |
RequiredForAgents | Boolean | False |
Set to true if the field is mandatory for Agents. |
RequiredForClosure | Boolean | False |
Set to true if the field is mandatory for closing the ticket. |
RequiredForCustomers | Boolean | False |
Set to true if the field is mandatory in the customer portal. |
Type | String | False |
For custom ticket fields, type of value associated with the field will be given (Available values are: custom_text, custom_paragraph, custom_checkbox, custom_number, custom_date, custom_decimal, nested_field, custom_dropdown, encrypted_text, secure_text) |
UpdatedAt | Datetime | True |
Ticket field updated timestamp. |