UFN_ASSIGNLETTERCODESPROCESS_GETLETTERCODESANDSELECTIONS_2

Returns all letters and their corresponding selections for a given assign letters process.

Return

Return Type
table

Parameters

Parameter	Parameter Type	Mode	Description
@ASSIGNLETTERCODESPROCESSID	uniqueidentifier	IN
@OWNERID	uniqueidentifier	IN

Definition

Copy



CREATE function dbo.[UFN_ASSIGNLETTERCODESPROCESS_GETLETTERCODESANDSELECTIONS_2]
(
  @ASSIGNLETTERCODESPROCESSID uniqueidentifier = null,
  @OWNERID uniqueidentifier = null
)
returns @RESULT table
(
  [LETTERCODEID] uniqueidentifier,
  [IDSETREGISTERID] uniqueidentifier,
  [LETTERCODENAME] nvarchar(100),
  [IDSETREGISTERNAME] nvarchar(100)
)
as begin    
  if @ASSIGNLETTERCODESPROCESSID is null
    insert into @RESULT
    select 
      [LETTERCODE].[ID],
      [IDSETREGISTER].[ID],
      [LETTERCODE].[NAME],
      [IDSETREGISTER].[NAME]
    from dbo.[LETTERCODE]
    inner join dbo.[IDSETREGISTER] on [LETTERCODE].[IDSETREGISTERID] = [IDSETREGISTER].[ID]
    where [LETTERCODE].[ISACTIVE] = 1
    and [LETTERCODE].[IDSETREGISTERID] is not null
    --and dbo.[UFN_LETTERCODE_USERHASSITEACCESS](@OWNERID, [LETTERCODE].[ID]) = 1;

  else
    insert into @RESULT
    select
      [ASSIGNLETTERCODESPROCESSLETTERCODES].[LETTERCODEID],
      [IDSETREGISTER].[ID],
      [LETTERCODE].[NAME],
      [IDSETREGISTER].[NAME]
    from dbo.[ASSIGNLETTERCODESPROCESSLETTERCODES]
    inner join dbo.[LETTERCODE] on [ASSIGNLETTERCODESPROCESSLETTERCODES].[LETTERCODEID] = [LETTERCODE].[ID]
    inner join dbo.[IDSETREGISTER] on [LETTERCODE].[IDSETREGISTERID] = [IDSETREGISTER].[ID]
    where [ASSIGNLETTERCODESPROCESSLETTERCODES].[ASSIGNLETTERCODESPROCESSID] = @ASSIGNLETTERCODESPROCESSID
    and [LETTERCODE].[ISACTIVE] = 1
    and [LETTERCODE].[IDSETREGISTERID] is not null
    --and dbo.[UFN_LETTERCODE_USERHASSITEACCESS](@OWNERID, [LETTERCODE].[ID]) = 1;


  return;            
end