Discussions
Query and create discussions in a space.
Select
The 本製品 will use the Garoon API to process WHERE clause conditions built with the following columns and operators. The rest of the filter is executed client side within the 本製品.
- SpaceId supports the '=' operator and is required for querying.
For example, the following query is processed server side:
SELECT * FROM Discussions WHERE SpaceId = 3
Insert
To create a Discussion, you must specify the SpaceId and Title fields.
INSERT INTO Discussions (SpaceId, Title) VALUES (3, 'New Discussion')
Discussion with body content:
INSERT INTO Discussions (SpaceId, Title, Body) VALUES (3, 'New Discussion', 'This is the body of the discussion.')
Discussion with HTML body:
INSERT INTO Discussions (SpaceId, Title, Body, IsHtmlBody) VALUES (3, 'HTML Discussion', 'This is HTML body', true)
Columns
| Name | Type | ReadOnly | Description |
| Id [KEY] | String | True |
ID of the discussion. |
| SpaceId | String | False |
ID of the space. |
| Title | String | False |
Title of the discussion. |
| Body | String | False |
Body of the discussion. |
| IsHtmlBody | Boolean | False |
Whether body is HTML format. |
| CreatedAt | Datetime | True |
Creation date and time. |
| CreatorId | String | True |
Creator's Garoon user ID. |
| CreatorCode | String | True |
Creator's login name. |
| CreatorName | String | True |
Creator's display name. |
| UpdatedAt | Datetime | True |
Update date and time. |
| UpdaterId | String | True |
Updater's Garoon user ID. |
| UpdaterCode | String | True |
Updater's login name. |
| UpdaterName | String | True |
Updater's display name. |