V_SEARCHLIST_INTERACTION
This provides the ability to search for interactions.
Fields
| Field | Field Type | Null | Description |
|---|---|---|---|
| ID | uniqueidentifier | ||
| NAME | nvarchar(154) | yes | |
| LOOKUPID | nvarchar(100) | yes | |
| OBJECTIVE | nvarchar(100) |
Definition
Copy
/*
Generated by Blackbaud AppFx Platform
Date: 11/30/2010 11:46:42 PM
Assembly Version: Blackbaud.AppFx.Platform.SqlClr, Version=2.8.2022.0, Culture=neutral, PublicKeyToken=null
Copyright Blackbaud
*/
CREATE VIEW dbo.V_SEARCHLIST_INTERACTION AS
select
INTERACTION.ID,
CONSTITUENT.NAME,
INTERACTION.LOOKUPID,
INTERACTION.OBJECTIVE
from
dbo.INTERACTION
inner join dbo.CONSTITUENT on CONSTITUENT.ID = INTERACTION.CONSTITUENTID;