Excel Add-In for Zoho Projects

Build 23.0.8839

Events

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

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 23.0.8839