TaskComments
null
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 |
body_content | String | |
body_contentType | String | |
conversationId [KEY] | String | |
conversationThreadId | String | |
from_emailAddress_address | String | |
from_emailAddress_name | String | |
hasAttachments | Bool | |
newParticipants | String | |
receivedDateTime | Datetime | |
sender_emailAddress_address | String | |
sender_emailAddress_name | String | |
inReplyTo_id | String | |
GroupId | String |