Create, update, delete, and query from groups table
Table Specific Information
The component 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 component.
For example, the following query is processed server side:
SELECT * FROM Groups WHERE Id = 100
Note: Only users with admin privileges can access this Table.
Name is a mandatory column for inserting into Groups table. For example:
INSERT INTO Groups (Name, Description, AutoTicketAssign) VALUES ('Example', 'Example Description...', false)
Following is an example of how to update a group:
UPDATE Groups SET Description = 'New description...' WHERE Id = 100
Following is an example of how to delete from Groups table:
DELETE FROM Groups WHERE Id = 786
IDs of the agents in the group.
Automatic ticket assignment enabled or not.
Unique ID of the business hour of the group.
Group created timestamp.
Description of the group.
ID of user to whom an escalation email is sent.
ID of the group.
Name of the group.
Time after which escalation email is sent.
Group updated timestamp.