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. The allowed values are on time, 15 mins, 30 mins, 1 hour, 2 hours, 6 hours, 12 hours, 1 day.
Repeat	String	False	Event Repeat. The allowed values are 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. The allowed values are 2, 3, 4, 5, 6, 7, 8, 9, 10.

Pseudo-Columns

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

Name	Type	Description
Status	String	Event Status. The allowed values are open, closed.