JDBC Driver for Azure DevOps

Build 22.0.8462

FeedViews

Retrieves all views for the specific feed.

Table Specific Information

Select

The driver 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 driver.


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

Projects.Id

Id of the project.

FeedId String True

Feeds.Id

Id of the feed.

LinksFeedHref String True

Feed reference link.

LinksPackagesHref String True

Packages reference link.

LinksSelfHref String True

Self reference link.

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.

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8462