Fetches all the tags present in a specific portal.

Select

• Status supports the following operator =.

For example, the following query is processed server side:

SELECT * FROM Events WHERE Status = 'open'

Insert

To create a new Event you can specify the following fields:

• Title
• DurationHour
• DurationMinutes
• Location
• Participants
• Reminder
• Repeat
• ScheduledOn
• RepeatTimes

INSERT INTO Events (Title, ScheduledOn, DurationHour, DurationMinutes, Participants, Reminder, Repeat, Location)
	VALUES ('SQL Event #2', '2022-03-20T18:00:00', '2', '30', '20081249448', '15 mins', 'only once', 'Test Location 2')

Update

To update an Event specify the Id field.

UPDATE Events
	SET title = 'Updated Title #1', DurationHour = '4', DurationMinutes = '10', ScheduledOn = '2022-05-01T23:12:00', Participants = '20081249448'
	WHERE Id = '123456000000045018'

Delete

Events can be deleted by providing the Id and issuing a DELETE statement.

DELETE FROM Events WHERE Id = '123456000000045018'  

Columns

Name	Type	ReadOnly	Description
Id [KEY]	String	False	Event Id.
Title	String	False	Event Title.
CreatedBy	String	False	Event Created By.
CreatedByZpuid	String	False	Event Created By ZPUID.
CreatedOn	Long	False	Event Created On.
DurationHour	String	False	Event Duration Hour.
DurationMinutes	String	False	Event Duration Minutes.
Location	String	False	Event Location.
Occurred	Integer	False	Event Occurred.
Occurrences	Integer	False	Event Occurrences.
Participants	String	False	Event Participants.
ProjectName	String	False	Event Project Name.
Reminder	String	False	Event Reminder. 使用できる値は次のとおりです。on time, 15 mins, 30 mins, 1 hour, 2 hours, 6 hours, 12 hours, 1 day
Repeat	String	False	Event Repeat. 使用できる値は次のとおりです。only once, everyday, everyweek, everymonth, everyyear
ScheduledOn	String	False	Event Scheduled On.
ScheduledOnLong	String	False	Event Scheduled On Long.
ScheduledOnTo	String	False	Event Scheduled On To.
ScheduledOnToLong	String	False	Event Scheduled On To Long.
RepeatTimes	String	False	Event Repeat Times. 使用できる値は次のとおりです。2, 3, 4, 5, 6, 7, 8, 9, 10

Pseudo-Columns

SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。

Name	Type	Description
Status	String	Event Status. 使用できる値は次のとおりです。open, closed