FeedViews
Retrieves all views for the specific feed.
Table Specific Information
Select
The server 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.
NOTE:The table automatically slices on the FeedId. Specifying this filter can improve performance.
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
When performing an Insert, the following fields are required: FeedId, Name, Type
The following is an example of inserting into the FeedViews 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 the 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 from the 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. |