OpenShifts

Stores reusable shift templates created by managers in the Teams Shifts app, used to build individual shift schedules.

テーブル固有の情報

Select

チームからすべてを取得するか、GroupId を'=' とIN 演算子で指定することでOpenShifts テーブルをクエリします。デフォルトでは、自身がメンバーであるグループのチームの空のシフトのみ返されます。組織の全グループのチームの空のシフトアイテムを取得するには、IncludeAllGroups プロパティをtrue に設定してください。本製品は Microsoft Teams API を使用して、以下のカラムと演算子で作成されたWHERE 句条件を処理します。その他のフィルタはクライアントサイドで本製品内部で処理されます。

TeamId は、'=' およびIN 演算子をサポートします。
Id は、'=' 演算子をサポートします。

例えば、次のクエリはサーバーサイドで処理されます。

SELECT * FROM OpenShifts WHERE TeamId IN ('da838338-4e77-4c05-82a6-79d9f0274511', 'da834568-4df7-4c05-82a6-79d9f0274515')
SELECT * FROM OpenShifts WHERE Id = 'OPNSHFT_2d49e6dd-d965-4ea2-a399-37f2a082852c' AND TeamId = 'da838338-4e77-4c05-82a6-79d9f0274511'

Insert

チームスケジュールに空のシフトを挿入するにはTeamId と、startDateTime およびendDateTime を含むDraftOpenShift またはSharedOpenShift の情報の、どちらか1つを含む必要があります。

INSERT INTO OpenShifts (TeamId, draftopenshift_openslotcount, draftopenshift_startDateTime, draftopenshift_endDateTime) VALUES ('da838338-4e77-4c05-82a6-79d9f0274511', 4, '2020-09-16T10:00:00.000Z', '2020-09-16T18:00:00.000Z')

Update

空のシフトを更新するには、WHERE 句にレコードId とTeamId が必要です。TeamId、Id、CreatedDateTime 以外のすべてのフィールドを更新できます。

UPDATE OpenShifts SET draftOpenShift_theme = 'blue' WHERE Id = 'OPNSHFT_2d49e6dd-d965-4ea2-a399-37f2a082852c' AND TeamId = 'da838338-4e77-4c05-82a6-79d9f0274511'

Delete

シフトレコードを削除するには、WHERE 句にId とTeamId が必要です。

DELETE FROM OpenShifts WHERE TeamId = 'da838338-4e77-4c05-82a6-79d9f0274511' AND Id = 'OPNSHFT_2d49e6dd-d965-4ea2-a399-37f2a082852c'

Columns


Name	Type	ReadOnly	Description
Id [KEY]	String	False	The unique identifier for the scheduling group that this open shift is associated with.
CreatedDateTime	Datetime	False	The date and time when the open shift was initially created.
IsStagedForDeletion	Bool	False	Indicates whether the open shift is marked for future deletion but has not yet been removed.
LastModifiedBy_application_displayName	String	False	The name of the application that most recently modified the open shift record.
LastModifiedBy_application_id	String	False	The unique application ID of the system or app that last updated the open shift.
LastModifiedDateTime	Datetime	False	The timestamp of the most recent update to the open shift.
DraftOpenShift_openSlotCount	Int	False	The number of available slots for the draft version of the open shift, which has not yet been shared with the team.
SchedulingGroupId	String	False	The unique identifier for the scheduling group under which this open shift is organized.
SharedOpenShift_openSlotCount	Int	False	The number of available slots in the shared version of the open shift, visible to team members.
TeamId	String	False	The identifier of the Microsoft Team where the open shift is being managed.
DraftOpenShift_displayName	String	False	The label or title assigned to the draft version of the open shift for display purposes.
DraftOpenShift_notes	String	False	Optional notes associated with the draft open shift, such as instructions or shift context.
DraftOpenShift_StartDateTime	Datetime	False	The start time of the draft open shift, before it has been published.
DraftOpenShift_EndDateTime	Datetime	False	The end time of the draft open shift, before it has been published.
SharedOpenShift_displayName	String	False	The label or title assigned to the shared version of the open shift for display to users.
SharedOpenShift_notes	String	False	Optional notes for the shared open shift, visible to team members when selecting shifts.
SharedOpenShift_StartDateTime	Datetime	False	The start time of the shared open shift, which is published and available for team use.
SharedOpenShift_EndDateTime	Datetime	False	The end time of the shared open shift, which is published and available for team use.