The Teans Table contains each project, project request, and workspace record in the system.
Query Examples
You may use the following examples as starter templates.
Please note that the below examples do not cover every possible column to select, join, filter, or order by. You may need to modify this query to suit your needs. Refer to the related Getting Started Guide for Database Queries article for how to identify your @BEIDInt or @BEID values (tenant ID).
Project Data
Select
Top 10
t.Teams_ID,
t.Teams_Name,
t.Teams_Desc,
t.Teams_InternalTypeID,
t.Teams_TypeID,
/* Account/Department */
t.Teams_ClientCode,
t.Teams_StatusID,
t.Teams_HealthID,
hc.HC_Name As HealthChoiceName,
t.Teams_ServiceID,
t.Teams_ServiceOfferingID,
/* Manager */
t.Teams_Admin,
/* Sponsor */
t.Teams_ClientContactUID,
t.Teams_CreatedByUID,
t.Teams_DateCreated,
t.Teams_ModifiedByUID,
t.Teams_DateModified,
t.Teams_StatusModifiedByUID,
t.Teams_DateStatusModified
/* Add or change selected columns as necessary. */
From
dbo.Teams t With (NOLOCK)
Inner Join dbo.HealthChoices hc With (NOLOCK) On t.Teams_HealthID = hc.HC_ID
Where
t.Teams_BEID = @BEID
/* Filter out project templates */
And t.Teams_IsTemplate = 0
/* Filter to project data only */
And t.Teams_InternalTypeID In ('project', 'closedproject')
Project Request Data
Select
Top 10
t.Teams_ID,
t.Teams_Name,
t.Teams_Desc,
t.Teams_InternalTypeID,
t.Teams_TypeID,
/* Account/Department */
t.Teams_ClientCode,
t.Teams_StatusID,
t.Teams_HealthID,
hc.HC_Name,
t.Teams_ServiceID,
t.Teams_ServiceOfferingID,
/* Sponsor */
t.Teams_ClientContactUID,
/* Requestor */
t.Teams_CreatedByUID,
t.Teams_DateCreated,
t.Teams_ModifiedByUID,
t.Teams_DateModified,
t.Teams_StatusModifiedByUID,
t.Teams_DateStatusModified
/* Add or change selected columns as necessary. */
From
dbo.Teams t With (NOLOCK)
Inner Join dbo.HealthChoices hc With (NOLOCK) On t.Teams_HealthID = hc.HC_ID
Where
t.Teams_BEID = @BEID
/* Filter out project templates */
And t.Teams_IsTemplate = 0
/* Filter to project request data only */
And t.Teams_InternalTypeID = 'request'
Workspace Data
Select
Top 10
t.Teams_ID,
t.Teams_Name,
t.Teams_Desc,
t.Teams_InternalTypeID,
t.Teams_TypeID,
/* Account/Department */
t.Teams_ClientCode,
t.Teams_StatusID,
t.Teams_HealthID,
hc.HC_Name,
t.Teams_ServiceID,
t.Teams_ServiceOfferingID,
/* Owner */
t.Teams_Admin,
/* Sponsor */
t.Teams_ClientContactUID,
t.Teams_CreatedByUID,
t.Teams_DateCreated,
t.Teams_ModifiedByUID,
t.Teams_DateModified,
t.Teams_StatusModifiedByUID,
t.Teams_DateStatusModified
/* Add or change selected columns as necessary. */
From
dbo.Teams t With (NOLOCK)
Inner Join dbo.HealthChoices hc With (NOLOCK) On t.Teams_HealthID = hc.HC_ID
Where
t.Teams_BEID = @BEID
/* Filter out project templates */
And t.Teams_IsTemplate = 0
/* Filter to workspace data only */
And t.Teams_InternalTypeID = 'workspace'