V_SEARCHLIST_IDSET
Search form for Selections.
Fields
| Field | Field Type | Null | Description |
|---|---|---|---|
| ID | uniqueidentifier | ||
| NAME | nvarchar(300) | ||
| DESCRIPTION | nvarchar(1024) | ||
| RECORDTYPE | nvarchar(50) | yes | |
| FORMAT | varchar(7) | ||
| SITE | nvarchar(1024) | yes | |
| DATE | datetime | ||
| APPUSER | nvarchar(128) | yes | |
| ACTIVE | bit |
Definition
Copy
/*
Generated by Blackbaud AppFx Platform
Date: 5/3/2024 2:19:00 PM
Assembly Version: Blackbaud.AppFx.Platform.SqlClr, Version=4.0.3700.0, Culture=neutral, PublicKeyToken=null
Copyright Blackbaud
*/
CREATE VIEW dbo.V_SEARCHLIST_IDSET AS
select
ID,
NAME,
DESCRIPTION,
dbo.UFN_TRANSLATIONFUNCTION_RECORDTYPE_GETNAME(IDSETREGISTER.RECORDTYPEID) as RECORDTYPE,
case IDSETREGISTER.STATIC when 0 then 'Dynamic' else 'Static' end FORMAT,
dbo.UFN_TRANSLATIONFUNCTION_SITE_GETNAME(IDSETREGISTER.SITEID) as SITE,
IDSETREGISTER.DATECHANGED as DATE,
dbo.UFN_CHANGEAGENT_GETUSERNAME(IDSETREGISTER.CHANGEDBYID) as APPUSER,
ACTIVE
from
dbo.IDSETREGISTER