Projects in a workspace.

Table Specific Information

Select

The add-in uses the Bitbucket API to process WHERE clause conditions built with the below columns. Filtering on other columns is processed client-side within the add-in.

• UUID
• Key
• Name
• Description
• IsPrivate
• CreatedOn
• UpdatedOn

The add-in uses the Bitbucket API to process ORDER BY clause conditions built with the below columns. Sorting on other columns is processed client-side within the add-in.

• UUID
• Key
• Name
• Description
• IsPrivate
• CreatedOn
• UpdatedOn

For example, the following query is processed server side:

SELECT * FROM Projects WHERE Name='Project2'

Insert

To create a new project, you must specify the Key and Name fields. You can also, optionally, specify the Description and IsPrivate fields.

A sample INSERT is included below:

INSERT INTO Projects (Key, Name) VALUES ('TEST', 'TestProj')

Update

A sample UPDATE is included below:

UPDATE Projects SET IsPrivate=true WHERE Key='PROJ'

Delete

You cannot delete a project that still contains repositories. If you want to delete a project, you must first either delete all existing repositories or move them to a different project.

A sample DELETE is included below:

DELETE FROM Projects WHERE Key='PROJ'

Columns

Name	Type	ReadOnly	References	Description
UUID	String	True		The project's immutable id.
Key [KEY]	String	False		The project's key.
Name	String	False		The name of the project.
Description	String	False		Description of the project.
IsPrivate	Bool	False		Whether the project is publicly accessible, or private to the team and only visible to team members.
CreatedOn	Datetime	True		When the project was created.
UpdatedOn	Datetime	True		When the project was updated.
HasPubliclyVisibleRepos	Bool	True		Indicates whether the project contains publicly visible repositories.