spCustomFormEntry_LoadByEntryIDorFormGuidorClientUserID

Parameters

Parameter	Parameter Type	Mode
@EntryID	uniqueidentifier	IN
@FormGuid	uniqueidentifier	IN
@ClientUserID	int	IN

Definition

Copy


                CREATE PROCEDURE [dbo].[spCustomFormEntry_LoadByEntryIDorFormGuidorClientUserID]
          @EntryID        uniqueidentifier,
          @FormGuid        uniqueidentifier,
          @ClientUserID    int
        as
            begin
             set @EntryID = nullif(@EntryID, dbo.fnGetGuidMinValue())
             set @FormGuid = nullif(@FormGuid, dbo.fnGetGuidMinValue())
             set @ClientUserID = nullif(@ClientUserID, dbo.fnGetIntMinValue())

            select
                 [ID],
                 [EntryID],
                 [FormGuid],
                 [ClientUserID],
                 [EntryData],
                 [EntryAlias],
                 [Printed],
                 [ClientSitesID]
            from
                 dbo.CustomFormEntry
            where
              ([EntryID] = @EntryID) or ([FormGuid] = @FormGuid) or ([ClientUserID] = @ClientUserID)
            order by
                [EntryAlias]
            end