AttributeValues
Returns attribute values, where each value represents a skill associated with an agent that determines the agent's suitability to solve a ticket.
Table-Specific Information
Select
The following queries are processed server-side while other filters are processed client-side within the provider.SELECT * FROM AttributeValues WHERE AttributeId = 'd5e889c8-6364-11ee-8493-6361d728a3c9'
SELECT * FROM AttributeValues WHERE AttributeId = 'd5e889c8-6364-11ee-8493-6361d728a3c9' AND Id = '5943809a-6f5d-4f6e-8669-e8a65bd3583b'
Insert
The AttributeId and Name columns are required to insert. This operation is allowed for logged-in users with the "admins" role.
INSERT INTO AttributeValues (AttributeId, Name) VALUES ('d5e889c8-6364-11ee-8493-6361d728a3c9', 'TestValue')
Update
You must specify the AttributeId and Id of the attribute value to update. This operation is allowed for logged-in users with the "admins" role.
UPDATE AttributeValues SET Name = 'CData' WHERE AttributeId = 'd5e889c8-6364-11ee-8493-6361d728a3c9' AND Id = '5943809a-6f5d-4f6e-8669-e8a65bd3583b'
Delete
You must specify the AttributeId and Id of the attribute value to delete it. This operation is allowed for logged-in users with the "agents" role.
DELETE FROM AttributeValues WHERE AttributeId = 'db70666a-6364-11ee-bfc8-7f3b952deb2c' AND Id = '5943809a-6f5d-4f6e-8669-e8a65bd3583b'
Columns
| Name | Type | ReadOnly | References | Description |
| Id [KEY] | String | True |
The unique Id of the attribute value, automatically assigned when the record is created. | |
| AttributeId | String | False |
Attributes.Id |
The Id of the attribute associated with this attribute value. |
| Name | String | False |
The name of the attribute value. | |
| url | String | True |
The URL of the attribute value. | |
| CreatedAt | Datetime | True |
The date and time when this record was created. | |
| UpdatedAt | Datetime | True |
The date and time when this record was last updated. |