OpenShifts

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

Table Specific Information

Select

Query the OpenShifts table by retrieving everything from teams or by specifying TeamId with = and IN operators. By default only the open shifts for teams of the groups you are a member of will be returned. To retreive open shift items for teams of all groups in your organization, set IncludeAllGroups property to true. The provider will use the Microsoft Teams API to process WHERE clause conditions built with the following columns and operators. The rest of the filter is executed client side within the provider.

TeamId supports the '=' and IN operators.
Id supports the '=' operator.

For example, the following queries are processed server side:

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

To insert an open shift into the team schedule, you need to specify TeamId, at least one of the DraftOpenShift or SharedOpenShift information including the startDateTime and endDateTime.

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

To update an open shift record Id and TeamId are required in WHERE clause. You can update any other field other than TeamId, Id and CreatedDateTime.

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

Delete

To delete a shift record Id and TeamId are required in WHERE clause.

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.