Retrieves a list of dashboards and details for a specific dashboard.

Table Specific Information

Select

The component uses the Azure DevOps API to process WHERE clause conditions built with the following columns and operators:

• Id supports the '=' operator.
• ProjectId supports the '=' operator.
• TeamId supports the '=' operator.

The rest of the filter is executed client-side in the component.

For example:

	SELECT * FROM Dashboards WHERE ProjectId = '837ccd31-8159-4db3-b8ce-de0c36d2a0bf'
	SELECT * FROM Dashboards WHERE ProjectId = '837ccd31-8159-4db3-b8ce-de0c36d2a0bf' AND TeamId = '27369296-c53e-4f21-9cac-1f0d62c87e40'

Insert

The following is an example of inserting into Dashboards table:

INSERT INTO DashBoards (ProjectId,TeamId,Name,Description) VALUES ('b154d8f3-bfd9-4bfb-90ae-2e6c8cda8937','619e870e-5242-4218-bedd-c52d8c003591','hello@123y','demo dashboards')

Update

The following is an example of updating a Dashboards table:

UPDATE DashBoards SET Name = 'abc' WHERE ProjectId = 'b154d8f3-bfd9-4bfb-90ae-2e6c8cda8937' AND Id = 'd112a62e-5fa1-42eb-abcc-2272cdceefe0' AND TeamId = '619e870e-5242-4218-bedd-c52d8c003591'

Delete

The following is an example of deleting data in the Dashboards table:

DELETE FROM DashBoards WHERE ProjectId = 'b154d8f3-bfd9-4bfb-90ae-2e6c8cda8937' AND Id = 'd112a62e-5fa1-42eb-abcc-2272cdceefe0' AND TeamId = '619e870e-5242-4218-bedd-c52d8c003591'

Columns

Name	Type	ReadOnly	References	Description
Id [KEY]	String	True		Unique Id of the dashboard.
ProjectId	String	True		The Id of the project to which this dashboard belongs to.
TeamId	String	True		The Id fo the team to which this dashboard belongs to.
Description	String	False		Description of the dashboard.
ETag	String	False		Server defined version tracking value, used for edit collision detection.
LinksGroupHref	String	True		Group reference link.
LinksSelfHref	String	True		Self reference link.
LinksWidget	String	True		Widget reference link.
Name	String	False		Name of the dashboard.
OwnerId	String	False		ID of the owner for a dashboard.
Position	Integer	False		Position of the dashboard, within a dashboard group.
RefreshInterval	Integer	False		Interval for client to automatically refresh the dashboard. Expressed in minutes.
Url	String	False		The full HTTP link to the dashboard.