V_SIMPLEDATALIST_SITESFORUSER
List of all sites in the system that a given user could interact with in the context of a specific feature, based on Role assignments.
Fields
| Field | Field Type | Null | Description |
|---|---|---|---|
| VALUE | uniqueidentifier | ||
| LABEL | nvarchar(250) |
Definition
Copy
/*
Generated by Blackbaud AppFx Platform
Date: 8/17/2011 2:20:37 PM
Assembly Version: Blackbaud.AppFx.Platform.SqlClr, Version=2.91.1535.0, Culture=neutral, PublicKeyToken=null
Copyright Blackbaud
*/
CREATE VIEW dbo.V_SIMPLEDATALIST_SITESFORUSER AS
select
[ID] as [VALUE],
[NAME] as [LABEL]
from dbo.[SITE];