TaskComments
Represents conversations about a plan.
Table Specific Information
Select
The add-in uses the Microsoft Planner API to process WHERE clause conditions built with the following columns and operators. The rest of the filter is executed client side within the add-in.
If Scope = NoAdminConsent, List the data related to the groups that the user is a member of.
If Scope = AdminConsent, List all the data related to groups.
- GroupId supports the '=' operator.
- ConversationThreadId supports the '=' operator.
For example, the following queries are processed server side:
SELECT * FROM TaskComments SELECT * FROM TaskComments WHERE GroupId = '73094928-3786-4246-a0d1-90c' SELECT * FROM TaskComments WHERE ConversationThreadId = 'AAQkADBlMTk2ZmZjLTJlZmYtNGQ0Zi05ZmViLTQwNzM0MWM0NWU5ZAMkABAAWZ7-9ddvEUa7ZFI' SELECT * FROM TaskComments WHERE ConversationThreadId = 'AAQkADBlMTk2ZmZjLTJlZmYtNGQ0Zi05ZmViLTQwNzM0MWM0NWU5ZAMkABAAWZ7-9ddvEUa7ZFI' and GroupId = '73094928-3786-4246-a0d1-90c'
Columns
| Name | Type | Description |
| conversationId [KEY] | String | The ID of the conversation. |
| body_content | String | Specifies the body content. |
| body_contentType | String | Specifies the body content type. |
| conversationThreadId | String | The ID of the conversation thread. |
| from_emailAddress_address | String | Specifies the email address from which the email was sent. |
| from_emailAddress_name | String | Specifies the name of the person from which the email was sent. |
| hasAttachments | Bool | Specifies whether the message has attachments |
| newParticipants | String | Specifies the new participants. |
| receivedDateTime | Datetime | Specifies the received date and time. |
| sender_emailAddress_address | String | Specifies the email address of the sender. |
| sender_emailAddress_name | String | Specifies the name of the sender. |
| inReplyTo_id | String | Specifies the ID to reply to. |
| GroupId | String | The ID of the group. |