Tags
Fetches all the tags present in a specific portal.
Select
You can use the below query to get all Tags:SELECT * FROM Tags
Insert
To create a new Tag you can specify the following fields:
INSERT INTO Tags (Name, ColorClass) VALUES ('New Tag', 'bg-tag16')
Update
To update a Tag specify the Id field.
UPDATE Tags SET Name = 'Updated Name', ColorClass = 'bg-tag99' WHERE Id = '123456000000043057'
Delete
Tags can be deleted by providing the Id and issuing a DELETE statement.
DELETE FROM Tags WHERE Id = '123456000000043057'
Columns
Name | Type | ReadOnly | Description |
Id [KEY] | String | False |
Tag Id. |
Name | String | False |
Tag Name. |
ColorClass | String | False |
Tag Color Class. |
CreatedBy | String | False |
Tag Created By. |
CreatedByName | String | False |
Tag Created By Name. |
CreatedByEmail | String | False |
Tag Created By Email. |
CreatedByFirstName | String | False |
Tag Created By First Name. |
CreatedByLastName | Unknown | False |
Tag Created By Last Name. |
CreatedByIsClientUser | Boolean | False |
Tag Created By Is Client User. |
CreatedByZpuid | String | False |
Tag Created By Zpuid. |
Pseudo-Columns
SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。
Name | Type | Description |
Tags | String |