ODBC Driver for Garoon

Build 26.0.9655

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.

Copyright (c) 2026 CData Software, Inc. - All rights reserved.
Build 26.0.9655