CannedResponsesFolder

Query from CannedResponsesFolder table

Table Specific Information

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

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

Name is a mandatory columns for Inserting into CannedResponsesFolder table.

INSERT INTO CannedResponsesFolder (Name) VALUES (directoryA)

Following is an example to update CannedResponsesFolder:

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


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.