fnTransactions_GetUnprocessedCarePages

Return

Return Type
table

Parameters

Parameter	Parameter Type	Mode	Description
@ClientsID	int	IN

Definition

Copy


      CREATE  function [dbo].[fnTransactions_GetUnprocessedCarePages](@ClientsID int)
      returns table as
      return (
          select frs.[ID],sc.[ClientSitesID] from dbo.FundRaiserSolicitors frs
          inner join dbo.FundRaisers fr on fr.ID=frs.FundRaiserID
          inner join dbo.SiteContent sc on fr.SiteContentID=sc.[ID]
          left join dbo.ClientUsers cu on cu.ID=frs.ClientUsersID
          where fr.IsCarePageManager=1
          and frs.Dirty=1 
          and dbo.fnGetRaisersEdgeRecordIDFromLinkedUserID(frs.ClientUsersID) > 0
      )