Data Model-Project Information, Discussions

Note: This is a subtopic for the Data Model Project Information topic.

• Main Topic—The text name of the discussion. This identifies the discussion in the Discussions application where discussions are listed by name (topic).
• Discussion Count——The total count of discussions in the report. This also provides subtotals for any groupings you include in the report. This value can change as you add or remove items that impact the number of discussions in the report.
  
  Note: Discussion Count counts the unique GUID values for discussions. This means that if you have 2 discussions with identical names, Discussion Count will be 2 even though your report shows a single discussion name.
• Message—The text of the discussion message.
• Discussion Owner—The creator of the discussion.
• Closed—Whether or not the discussion is closed. Options are Yes and No.
• Discussion Folder Name—The name of the folder in which the discussion is located.
• Last Reply By—The user who posted the last reply to the discussion.
• Last Reply On—The date the last reply was made.
• Created On—The date on which the discussion was created.
• Replies

  Note: A discussion may have multiple replies.

  • Reply Topic—The topic of the reply.
  • Discussion Type—The type of discussion reply. Options are FYI, Question, Answer, and Discussion Item.
  • Reply By—The name of the user who made the reply.
  • Reply Created On—The date on which the reply was made.
  • Reply Message—The reply message.
  • Reply Count——The total count of replies in the report. This also provides subtotals for any groupings you include in the report. This value can change as you add or remove items that impact the number of replies in the report.
    
    Note: Reply Count counts the unique GUID values for replies. This means that if you have 2 replies with identical names, Reply Count will be 2 even though your report shows a single reply name.
  • Reply Parent—The parent discussion for the reply.
• IDs

  Note:IDs are included in the data model so you can join to other queries. Also, grouping on an ID can help separate different items with identical names.

  • DiscussionItemID
  • LastPostBy
  • OwnerID
  • ParentWorkspaceID
  • ParentAppInstanceID
  • ParentFolderID
  • ParentItemID
  • ParentItemTypeID
  • DiscussionItemPostID
  • RootID
  • ParentID
• UTC Dates

  Note: UTC dates are shown in Coordinated Universal Time format. UTC is also known as Greenwich Meridian Time (GMT).

  • Last Post On (UTC)—The date of the last discussion post.
  • Created On (UTC)—The date the discussion was created.
  • Reply Created On (UTC)—The date the discussion reply was created.

   

Copyright © 2018 Daptiv Solutions, LLC. All Rights Reserved