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