Retrieves all wikis in a project or collection.

Table Specific Information

Select

The 本製品 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.

The rest of the filter is executed client-side in the 本製品.

For example:

SELECT * FROM Wikis WHERE Id = '35df8f05-c66c-4a97-953d-a2a6d47a6198'
SELECT * FROM Wikis WHERE ProjectId = '837ccd31-8159-4db3-b8ce-de0c36d2a0bf'

Insert

Note that when inserting a Wiki of type ProjectWiki, the MappedPath, RepositoryId, and Version are not required.

The following are examples of inserting into the Wikis table:

INSERT INTO Wikis (ProjectId, Name) VALUES ('b154d8f3-bfd9-4bfb-90ae-2e6c8cda8937', 'TestWiki')

INSERT INTO Wikis (ProjectId, Name, Type, MappedPath, RepositoryId, Version) VALUES ('b154d8f3-bfd9-4bfb-90ae-2e6c8cda8937', 'MyCodeWiki', 'CodeWiki', '/', 'd36a682e-db74-4bc1-b0c3-8929402ce829', '{"version":"main"}')

Update

The following is an example of updating the Wikis table:

UPDATE Wikis SET Name = 'cd' WHERE Id = 'e7c569e7-3ff0-432c-93f0-084c09d578b5' AND ProjectId = 'b154d8f3-bfd9-4bfb-90ae-2e6c8cda8937'

Delete

The following is an example of deleting data from the Wikis table:

DELETE FROM Wikis WHERE Id = 'e7c569e7-3ff0-432c-93f0-084c09d578b5' AND ProjectId = 'b154d8f3-bfd9-4bfb-90ae-2e6c8cda8937'

Columns

Name	Type	ReadOnly	References	Description
Id [KEY]	String	True		Unique ID of the wiki.
MappedPath	String	False		Folder path inside repository which is shown as wiki.
Name	String	False		The name of the wiki.
ProjectId	String	False		ID of the project in which the wiki is to be created.
Properties	String	True		Properties of the wiki.
RemoteUrl	String	True		Remote web url to the wiki.
RepositoryId	String	False	Repositories.Id	ID of the git repository that backs up the wiki. Not required for ProjectWiki type.
Type	String	False		Type of the wiki.
Url	String	True		REST url for this wiki.

Pseudo-Columns

SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。 特に指定がない限り、擬似カラムでフィルタリングを行う場合は = 演算子のみ使用できます。

Name	Type	Description
Version	String	Version aggregate of the wiki.