V_SEARCH_APPUSER

Used to search for Application Users

Fields

Field	Field Type	Null
ID	uniqueidentifier
LOGINNAME	nvarchar(128)	yes
DISPLAYNAME	nvarchar(255)
ISSYSADMIN	bit
NUMROLES	int	yes
CONSTITUENTNAME	nvarchar(154)	yes
SITE	nvarchar(250)
CURRENCYSETNAME	nvarchar(100)
CUSTOMAUTHENTICATIONNAME	nvarchar(255)
ISACTIVE	int
EMAILADDRESS	nvarchar(100)	yes
HASRUNASRIGHTS	bit

Definition

Copy

/*
Generated by Blackbaud AppFx Platform
Date:  5/3/2024 2:17:13 PM
Assembly Version:  Blackbaud.AppFx.Platform.SqlClr, Version=4.0.3700.0, Culture=neutral, PublicKeyToken=null
Copyright Blackbaud
*/
CREATE VIEW dbo.V_SEARCH_APPUSER AS



                select APPUSER.ID,
                    APPUSER.USERNAME [LOGINNAME],
                    APPUSER.DISPLAYNAME,
                    APPUSER.ISSYSADMIN,
                    (select count(*) from dbo.SYSTEMROLEAPPUSER where APPUSERID = APPUSER.ID) [NUMROLES],
                    NF.NAME [CONSTITUENTNAME],
                    isnull(SITE.NAME, '') as SITE,
                    isnull((select CURRENCYSET.NAME
                        from dbo.CURRENCYSET
                        inner join dbo.APPUSERCURRENCYSET on CURRENCYSET.ID = APPUSERCURRENCYSET.CURRENCYSETID
                        where APPUSERCURRENCYSET.APPUSERID = APPUSER.ID), '') as CURRENCYSETNAME,
                    isnull(APPUSER.CUSTOM_AUTHENTICATION_USERID, '') as CUSTOMAUTHENTICATIONNAME,
                    case
                      when APPUSERTHIRDPARTYAUTH.ID is not null then iif(APPUSERTHIRDPARTYAUTH.INACTIVE = 1, 0, 1)
                        else isnull(APPUSER.ISACTIVE, 1)
                    end as ISACTIVE,
                    APPUSER.EMAILADDRESS,
                    isnull(APPUSER.HASRUNASRIGHTS, 0) as HASRUNASRIGHTS
                from 
                    dbo.APPUSER
                    left outer join dbo.APPUSERTHIRDPARTYAUTH on APPUSER.ID = APPUSERTHIRDPARTYAUTH.ID
                    outer apply dbo.UFN_CONSTITUENT_DISPLAYNAME(APPUSER.CONSTITUENTID) NF
                    left outer join dbo.SITE on SITE.ID = APPUSER.SITEID;