UFN_CONSTITUENTINTERACTIONLIST_QUERY

CREATE function dbo.UFN_CONSTITUENTINTERACTIONLIST_QUERY
(
  @CONSTITUENTID uniqueidentifier,
  @CURRENTAPPUSERID uniqueidentifier = null,
  @SITEFILTERMODE tinyint = 0,
  @SITESSELECTED xml = null,
  @SECURITYFEATUREID uniqueidentifier ='66455516-5589-4961-8c49-341e4230dc4d',
  @SECURITYFEATURETYPE tinyint = 10
)
returns @INTERACTIONS table (
  ID uniqueidentifier,
  DATE datetime,
  STATUS nvarchar(200),
  OWNER nvarchar(200),
  OWNERID uniqueidentifier,
  OBJECTIVE nvarchar(200),
  TYPE nvarchar(200),
  HASDOCUMENTATION bit,
  ISMOVE bit,
  EVENT nvarchar(200),
  HASRESPONSES bit,
  CATEGORY nvarchar(200),
  SUBCATEGORY nvarchar(200),
  VIEWFORMID uniqueidentifier,
  SITES nvarchar(1024), 
  STARTTIME nvarchar(4),
  ENDTIME nvarchar(4),
  TIMEZONE nvarchar(200),
  ISSTEWARDSHIPSTEP bit,
  ISINDIVIDUALSTEP bit,
  EXPECTEDDATE datetime,
  ACTUALDATE datetime,
  EXPECTEDSTARTTIME nvarchar(4),
  ACTUALSTARTTIME nvarchar(4),
  EXPECTEDENDTIME nvarchar(4),
  ACTUALENDTIME nvarchar(4),
  COMMENT nvarchar(max),
  HASPARTICIPANTS bit,
  LOCATION nvarchar(300)
  )
as
begin
  insert into @INTERACTIONS
  select 
    ID,
    DATE,
    STATUS,
    OWNER,
    OWNERID,
    OBJECTIVE,
    TYPE,
    HASDOCUMENTATION,
    ISMOVE,
    EVENT,
    HASRESPONSES,
    CATEGORY,
    SUBCATEGORY,
    VIEWFORMID,
    SITES, 
    STARTTIME,
    ENDTIME,
    TIMEZONE,
    ISSTEWARDSHIPSTEP,
    ISINDIVIDUALSTEP,
    EXPECTEDDATE,
    ACTUALDATE,
    EXPECTEDSTARTTIME,
    ACTUALSTARTTIME,
    EXPECTEDENDTIME,
    ACTUALENDTIME,
    COMMENT,
    HASPARTICIPANTS,
    LOCATION
  from dbo.UFN_CONSTITUENT_INTERACTIONS(
    @CONSTITUENTID,
    null,
    null,
    null,
    @CURRENTAPPUSERID,
    @SITEFILTERMODE,
    @SITESSELECTED,
    @SECURITYFEATUREID,
    @SECURITYFEATURETYPE,
    null
  )
  order by [DATE] desc;

  return;
end