Releases
Create, update, delete, and query the registered releases.
Table Specific Information
Select
You can query the Releases table using any criteria in the WHERE clause. The provider will use the SuiteCRM API to filter the results.
SELECT * FROM Releases WHERE [Release Version] like 'V3.%'
Insert
Create a Release by specifying any writable column.
INSERT INTO Releases ([Release Version],[Order]) VALUES ('V3.4',3)
Update
You can update any Release column that is writable, by specifying the Id.
UPDATE Releases SET Status = 'Published' WHERE Id = 'Test123'
Delete
Remove a Release by specifying the Id.
DELETE FROM Releases WHERE Id = 10003
Columns
| Name | Type | ReadOnly | Description |
| ID [KEY] | String | False |
The unique identifier of the record. |
| CreatedBy | String | True |
The Id of the user who created the record. |
| CreatedByName | String | True |
The Name of the user who created the record. |
| DateCreated | Datetime | True |
The date the record was entered. |
| DateModified | Datetime | True |
The date the record was last modified. |
| Deleted | Bool | False |
Whether the record is deleted. |
| ModifiedById | String | True |
The Id of the user who last modified the record. |
| ModifiedByName | String | True |
The Name of the user who last modified the record. |
| Order | Int | False |
The relative order in the drop-down list. |
| ReleaseVersion | String | False |
The name of the release. |
| Status | String | False |
The status of the record. |
Pseudo-Columns
Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.
| Name | Type | Description |
| Rows@Next | String |
Identifier for the next page of results. Do not set this value manually. |