UFN_QUERY_GETFOLDERDETAILS

create function dbo.[UFN_QUERY_GETFOLDERDETAILS]
(
  @CURRENTAPPUSERID uniqueidentifier = null
)
returns table 

as

  return
            select  
              f.[ID] as [FOLDERID],
              isnull(f.[PARENTFOLDERID], '00000000-0000-0000-0000-000000000000') as [PARENTFOLDERID],
              f.[NAME] as [FOLDERNAME],
        f.[DISPLAYORDER],
        af.[APPLYASDEFAULTPERMISSIONSFORALLSUBFOLDERS],
        af.[SECURITYLEVELCODE],
        af.[QUERYDEFAULTALLOWALLUSERSTORUN],
        af.[QUERYDEFAULTALLOWALLUSERSTOEDIT],
        af.[SMARTQUERYDEFAULTALLOWALLUSERSTORUN],
        af.[SMARTQUERYDEFAULTALLOWALLUSERSTOEDIT]
            from dbo.[UFN_ADHOCQUERYFOLDERS_GETUSERSFOLDERS](@CURRENTAPPUSERID) f
      left join dbo.[ADHOCQUERYFOLDER] af on f.[ID] = af.[ID];