UFN_CMS_SITEISPUBLISHED
Return
| Return Type |
|---|
| bit |
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @ID | int | IN |
Definition
Copy
CREATE FUNCTION [dbo].[UFN_CMS_SITEISPUBLISHED]
(@ID int)
RETURNS bit
AS
BEGIN
DECLARE @Published bit = 0
DECLARE @LastActionDate datetime
select top 1 @LastActionDate = AU.AuditCodesID from ClientSites CS
inner join Audits AU on CS.Guid = AU.ObjectGuid
where CS.ID = @ID and
(AU.AuditCodesID = 7
or AU.AuditCodesID = 8)
order by AuditDate desc
if @LastActionDate = 7
set @Published = 1;
else
set @Published = 0;
return @Published
END