Retrieves all views for the specific feed.

Table Specific Information

Select

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

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

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

NOTE: FeedId is required in order to query FeedViews.

For example:

    SELECT * FROM FeedViews WHERE FeedId = 'e14f9853-4830-4f04-9561-c551254a32c9'
	SELECT * FROM FeedViews WHERE FeedId = 'e14f9853-4830-4f04-9561-c551254a32c9' AND Id = 'a7e5d881-fde1-46d8-8852-7433bf49fcd3'

Insert

The following is an example of inserting into an Earnings Table:

INSERT INTO FeedViews (ProjectId, FeedId, Name, Type) VALUES ('c831d3b4-a289-462f', 'b680c89a-fda0-4689', 'TestName', 'release')

Update

The following is an example of updating a FeedViews table:

UPDATE FeedViews Name = 'abc' WHERE ProjectId = 'b154d8f3-bfd9-4bfb-90ae-2e6c8cda8937' AND feedid = '2dfe0d39-1ee0-4501-9924-2e6b186a7435' AND Id = '738ccfca-cef3-4d53-98f8-4136c2e446cf'

Delete

The following is an example of deleting data in a FeedViews table:

DELETE FROM FeedViews WHERE ProjectId = 'b154d8f3-bfd9-4bfb-90ae-2e6c8cda8937' AND FeedId = '2dfe0d39-1ee0-4501-9924-2e6b186a7435' AND Id = '738ccfca-cef3-4d53-98f8-4136c2e446cf'

Columns

Name	Type	ReadOnly	References	Description
Id [KEY]	String	True		Id of the view.
ProjectId	String	True		Id of the project.
FeedId	String	True	Feeds.Id	Id of the feed.
Links	String	True		Aggregate of the reference links.
Name	String	False		Name of the view.
Type	String	False		Type of view.
Url	String	False		Url of the view.
Visibility	String	False		Visibility status of the view.