ChatMessageMentions
Get Chat Message Mentions.
Table Specific Information
Select
The connector uses the Microsoft Teams API to process WHERE clause conditions built with the following column and operator:
- ChatId supports '=' operator.
The rest of the filter is executed client side within the connector.
The following is an example query:
SELECT * FROM ChatMessageMentions WHERE ChatId = '19:92dfdfc6-f1d4-4965-9f71-30e4da4fa7fe_e4ea490e-b30c-4b1e-92b0-337117920315@unq.gbl.spaces'
Columns
| Name | Type | Description |
| Id | String | The Chat Messages Id. |
| ChatId | String | The Chat Id. |
| Mentions_Id | Int | The Id of the mention. |
| MentionText | String | The MentionText of the mention. |
| User_Id | String | The User_Id of the mention. |
| User_DisplayName | String | The User_DisplayName of the mention. |
| User_TenantId | String | The User_TenantId of the mention. |
| Application_Id | String | The Application_Id of the mention. |
| Application_DisplayName | String | The Application_DisplayName of the mention. |
| Application_TenantId | String | The Application_TenantId of the mention. |
| Device_Id | String | The Device_Id of the mention. |
| Device_DisplayName | String | The Device_DisplayName of the mention. |
| Device_TenantId | String | The Device_TenantId of the mention. |
| Conversation_Id | String | The Conversation_Id of the mention. |
| Conversation_DisplayName | String | The Conversation_DisplayName of the mention. |
| Conversation_ConversationIdentityType | String | The Conversation_ConversationIdentityType of the mention. |