USP_DATALIST_DISCUSSIONGROUP

Returns the Discussion Group part properties associated with a particular part, or all of them.

Parameters

Parameter	Parameter Type	Mode	Description
@SiteContentID	int	IN	SiteContentID

Definition

Copy



create procedure dbo.USP_DATALIST_DISCUSSIONGROUP(    
    @SiteContentID int = null
)
as
    set nocount on;

     select 
       guid,
       ID,
       SiteContentID
    from dbo.DiscussionGroups
    where 
  (@SiteContentID is null)
  or
  (SiteContentID = @SiteContentID)