Body
The ItemUpdateComments Table contains replies to top-level feed items in the system.
Query Example
You may use the following example as a starter template.
Please note that the below example does not cover every possible column to select, join, filter, or order by. You may need to modify this query to suit your needs. Refer to the related Getting Started Guide for Database Queries article for how to identify your @BEIDInt or @BEID values (tenant ID).
Select
Top 10
iuc.IUC_ID,
/* ItemUpdate ID */
iuc.IUC_ItemUpdateID,
iuc.IUC_Body,
iuc.IUC_CreatedByUID,
iuc.IUC_DateCreated
/* Add or change selected columns as necessary. */
From
dbo.ItemUpdateComments iuc With (NOLOCK)
Where
iuc.IUC_ItemUpdateID = ITEM_UPDATE_ID_HERE
Order By
iuc.IUC_DateCreated Desc
You would normally get the list of specific ItemUpdates records you want to find comments for from the related Query Guide: ItemUpdates Table article. You then plug the ItemUpdates IDs into this query to identify their comments.