FireDAC Components for FreshDesk

Build 21.0.7930

CannedResponsesFolder

Query from CannedResponsesFolder table

Table Specific Information

Note: Only users with admin privileges can access the following Table.

Select

Following is an example to select all entries from CannedResponsesFolder table:

SELECT * FROM CannedResponsesFolder

You can also select a specific entry from CannedResponsesFolder table:

SELECT * FROM CannedResponsesFolder WHERE Id = 100

Insert

Name is a mandatory columns for Inserting into CannedResponsesFolder table.

INSERT INTO CannedResponsesFolder (Name) VALUES (directoryA)

Update

Following is an example to update CannedResponsesFolder:

UPDATE CannedResponsesFolder SET Name = 'updated name' WHERE Id = 100

Columns

Name Type ReadOnly Description
Id [KEY] Bigint False

ID of the canned response folder.

Name String False

Name of the canned response folder.

Personal Boolean False

Set true if the folder can be accessed only by you.

ResponsesCount Int False

Number of canned responses in the folder.

CreatedAt Datetime True

Canned response folder creation timestamp.

UpdatedAt Datetime True

Canned response folder updated timestamp.

Copyright (c) 2021 CData Software, Inc. - All rights reserved.
Build 21.0.7930