Comments
Retrieve comments.
Table Specific Information
Select
Streak allows only a small subset of columns to be used in the WHERE clause of a SELECT query. These columns can typically be used with only = comparision. The available column for Comments is CommentKey. For example:
SELECT * FROM Comments WHERE CommentKey='agxzfm1haWxmb29nYWVyLabSDE9yZ2FuaXphdGlvbiIJY2RhdGEuY29tDAsSB0NvbW1lbnQYgIDsyJ_29gsM'
Columns
Name | Type | References | Description |
CommentKey [KEY] | String | Key of the comment. | |
BoxKey | String |
Boxes.BoxKey | Box associated with the comment. |
PipelineKey | String |
Pipelines.PipelineKey | Pipeline associated with the comment. |
CreatorKey | String |
Users.UserKey | User that created the comment. |
NewsfeedEntryKey | String |
Newsfeeds.NewsfeedEntryKey | News feed entry key for this comment. |
Timestamp | Timestamp | When this comment was created. | |
Message | String | The value of the comment. | |
LastSavedTimestamp | Timestamp | When the comment was last saved. |