UFN_TRANSLATIONFUNCTION_BBWORKFLOWINSTANCEINFO_DISPLAYTEXT

create function dbo.UFN_TRANSLATIONFUNCTION_BBWORKFLOWINSTANCEINFO_DISPLAYTEXT(@ID uniqueidentifier) returns nvarchar(300) 
as
begin

    declare @s nvarchar(300);
  declare @catname nvarchar(60);
  declare @startdate datetimeoffset;
  declare @user nvarchar(128);
  declare @lookupId nvarchar(100);

select 
@lookupId=WI.LOOKUPID,
@catname= WC.NAME ,
@startdate= WI.WORKFLOWSTARTDATE
--,@user=COALESCE(STARTAU.DISPLAYNAME,'')



FROM dbo.BBWORKFLOWCATALOG as WC

inner join dbo.BBWORKFLOWINSTANCEINFO AS WI

LEFT OUTER JOIN dbo.APPUSER as STARTAU
ON WI.INITIATEDBY_APPUSERID=STARTAU.ID

ON WC.ID=WI.BBWORKFLOWCATALOGID

WHERE
WI.ID=@ID;

set @s = @lookupId + ' (' + @catname + ') ' + cast(@startdate as nvarchar(100)) -- + ' ' + @user;

return @s;


end