CData JDBC Driver for Garoon 2019J - Online Help

Events

CData JDBC Driver for Garoon 2019J - Build 19.0.7404

Query, create, modify, and delete regarding events.

Select

本製品 は Garoon API を使用して、以下のカラムと演算子で構築されたWHERE 句条件を処理します。その他のフィルタはクライアント側で本製品 内部で処理されます。

  • DateTime <、<=、=、>= および > 演算子をサポートします。
例えば、次のクエリはサーバー側で処理されます。
SELECT *  FROM Events WHERE DateTime>='2019-11-22 00:00:00.0'
SELECT *  FROM Events WHERE DateTime>'2019-11-22 00:00:00.0'
SupportEnhancedSQL をfalse に設定すると、クライアント側の実行をオフにできます。その場合、その他のカラムを参照する検索条件でエラーが発生します。

Update

ReadOnly がfalse のカラムを更新できます。

UPDATE Events 
SET EventMenu='test', Subject='test', Notes='TEMPORARY', visibilityType='PRIVATE', useAttendanceCheck=false, CompanyInfoName='CompanyName',CompanyInfoZipCode='CompanyZipCode',
 CompanyInfoAddress='CompanyAddress', CompanyInfoRoute='CompanyRoute', CompanyInfoRouteTime='2020', CompanyInfoRouteFare='223', CompanyInfoPhone='24342232342' , 
 StartDateTime='2019-01-28T06:51:24Z', StartTimeZone='Asia/Tokyo', EndDateTime='2019-01-28T06:51:24Z', EndTimeZone='Asia/Tokyo', isAllDay=true, isStartOnly=false, AdditionalItemsItemValue='test'  
 WHERE Id=35

テンポラリテーブルの使用:

INSERT INTO Watchers#TEMP (Code,Type) VALUES('User1','USER')
INSERT INTO Watchers#TEMP (Code,Type) VALUES('User2','USER')
INSERT INTO Watchers#TEMP (Code,Type) VALUES('User3','USER')
UPDATE Events SET Watchers='Watchers#TEMP' WHERE Id=35

集計の使用:

UPDATE Events SET Watchers='[
    {
      "type": "USER",
      "code": "c000001"
    }
  ]', visibilityType='SET_PRIVATE_WATCHERS' WHERE Id=35
UPDATE Events SET Attendees='[
    {
      "type": "USER",
      "code": "c000001"
    }
  ]' WHERE Id=35
  UPDATE Events SET facilities='[
    {
      "code": "F001"
    }
  ]' WHERE Id=35

Insert

Event を追加するには、次のカラムの組み合わせの少なくとも1つを指定する必要があります。
a) EventType、StartDateTime、StartTimeZone、EndDateTime、EndTimeZone およびFacilities カラム。
b) EventType、StartDateTime、StartTimeZone、EndDateTime、EndTimeZone およびAttendees カラム。
c) EventType、StartDateTime、StartTimeZone、IsStartOnly(true) およびFacilities カラム。
d) EventType、StartDateTime、StartTimeZone、IsStartOnly(true) およびAttendees カラム。

テンポラリテーブルの使用:

INSERT INTO EventAttendees#TEMP (Code,Type) VALUES('User','USER')
INSERT INTO Events (EventType, StartDateTime, StartTimeZone, IsStartOnly, Attendees) VALUES ('REGULAR', '2020-09-27T14:00:00+09:00', 'Asia/Tokyo', true, 'EventAttendees#TEMP')

INSERT INTO EventFacilities#TEMP (Code) VALUES('FacilityGroupsFacility1')
INSERT INTO Events (EventType, StartDateTime, StartTimeZone, EndDateTime, EndTimeZone, Facilities) VALUES ('REGULAR', '2020-09-17T14:00:00', 'Asia/Tokyo', '2020-09-17T15:00:00', 'Asia/Tokyo', 'EventFacilities#TEMP')

添付ファイル付きのイベントを挿入します。(添付ファイルのコンテンツにはBase64 エンコードが必要です。)

INSERT INTO EventAttendees#TEMP (Code,Type) VALUES('Endri','USER')
INSERT INTO EventAttachments#TEMP (name,contentType,content) VALUES('test1.txt','plain/text','dGVzdA==')
INSERT INTO EventAttachments#TEMP (name,contentType,content) VALUES('test2.txt','plain/text','dGVrdrdr33zdA==')
INSERT INTO Events (EventType,StartDateTime,StartTimeZone,isStartOnly, Attendees, Attachments ) VALUES ('REGULAR','2020-09-27T14:00:00+09:00','Asia/Tokyo', true,'EventAttendees#TEMP', 'EventAttachments#TEMP')

集計の使用:

INSERT INTO Events (EventType, StartDateTime, StartTimeZone, EndDateTime, EndTimeZone, IsStartOnly, Facilities) VALUES ('REGULAR', '2020-09-27T14:00:00', 'Asia/Tokyo', '2020-09-27T15:00:00', 'Asia/Tokyo', false, '[
    {
      "code": "F001"
    }
  ]')

Delete

イベントのId を指定することでイベントを削除できます。

DELETE FROM Events WHERE Id = 34

Columns

Name Type ReadOnly Description
Id [KEY] String True

Composed id of the event.

EventId Int True

Id of the event.

CreatorId Int True

Id of the creator.

CreatorCode String True

Code of the creator.

CreatorName String True

Name of the creator.

CreatedAt Datetime True

Created time.

UpdaterId Int True

Id of the updater.

UpdaterCode String True

Code of the updater.

UpdaterName String True

Name of the updater.

UpdatedAt Datetime True

Updated time.

EventType String False

Type of the event.

EventMenu String False

Menu of the event.

Subject String False

Subject of the event.

Notes String False

Notes of the event.

VisibilityType String False

Type of visibility.

UseAttendanceCheck Boolean False

Use attendance check.

Attachments String True

Attachments of the event.

Attendees String False

Attendees of the event.

AttendeesCandidate String True

Attendees candidate of the event.

CompanyInfoName String False

Name of company.

CompanyInfoZipCode String False

Zip code of company.

CompanyInfoAddress String False

Address of company.

CompanyInfoRoute String False

Route of company.

CompanyInfoRouteTime String False

Route time of company.

CompanyInfoRouteFare String False

Route fare of company.

CompanyInfoPhone String False

Phone number of company.

StartDateTime Datetime False

Time when event started.

StartTimeZone String False

Starting time zone.

EndDateTime Datetime False

Time when event ends.

EndTimeZone String False

Ending time zone.

IsAllDay Boolean False

When set to true, event is all day.

IsStartOnly Boolean False

When set to true,event is start only.

OriginalStartTimeZone String True

Original start time zone.

OriginalEndTimeZone String True

Original end time zone.

Watchers String False

Watchers of the event.

WatchersCandidate String True

Watchers candidate of the event.

Facilities String False

Facilities of the event.

FacilitiesCandidate String True

Facilities candidate of the event.

FacilityUsingPurpose String False

Facility using purpose

FacilityReservationInfo String True

Facility reservation info.

FacilityUsageRequests String True

Facility usage requests.

RepeatInfo String True

Repeat info.

TemporaryEventCandidates String True

Temporary event candidates.

AdditionalItemsItemValue String False

Additional items.

RepeatId String True

Repeat id.

Pseudo-Columns

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

Name Type Description
DateTime Datetime

Specify the date and time of the search target in RFC3339 format. Supported operators are =,<,>,<=,>=.

 
 
Copyright (c) 2020 CData Software, Inc. - All rights reserved.
Build 19.0.7404.0