USR_V_QUERY_USR_FAFIMAGES
Provides support for querying on FAF Images information.
Fields
| Field | Field Type | Null | Description |
|---|---|---|---|
| ID | uniqueidentifier | System record ID | |
| CONSTITUENTID | uniqueidentifier | yes | Constituentid |
| EVENTID | uniqueidentifier | yes | Eventid |
| NAME | nvarchar(256) | Name | |
| DESCRIPTION | nvarchar(256) | Description | |
| FILENAME | nvarchar(256) | Filename | |
| UPLOADFILENAME | nvarchar(256) | Uploadfilename | |
| IMAGETYPE | nvarchar(50) | Imagetype | |
| IMAGESIZE | int | Imagesize | |
| IMAGECONTENT | varbinary | yes | Imagecontent |
| CAPTION | nvarchar(256) | Caption | |
| APPROVED | bit | Approved | |
| PRIVATE | bit | Private | |
| PHOTOGRAPHER | nvarchar(256) | Photographer | |
| PHOTODATETAKEN | datetime | yes | Photodatetaken |
| TAGS | nvarchar(256) | Tags | |
| EXTERNALFLAG | bit | Externalflag | |
| IMAGESOURCECODE | tinyint | Imagesource | |
| EXTERNALURL | nvarchar(256) | Externalurl | |
| ADDEDBY_APPLICATION | nvarchar(200) | yes | Added by application |
| ADDEDBY_USERNAME | nvarchar(128) | yes | Added by user name |
| CHANGEDBY_APPLICATION | nvarchar(200) | yes | Changed by application |
| CHANGEDBY_USERNAME | nvarchar(128) | yes | Changed by user name |
| DATEADDED | datetime | Date added | |
| DATECHANGED | datetime | Date changed | |
| TSLONG | bigint | yes | Timestamp value |
Definition
Copy
/*
Generated by Blackbaud AppFx Platform
Date: 1/27/2010 7:00:55 PM
Assembly Version: Blackbaud.AppFx.Platform.SqlClr, Version=2.5.465.0, Culture=neutral, PublicKeyToken=null
Copyright Blackbaud
*/
CREATE VIEW dbo.USR_V_QUERY_USR_FAFIMAGES AS
select
USR_FAFIMAGES.ID,
USR_FAFIMAGES.[CONSTITUENTID],
USR_FAFIMAGES.[EVENTID],
USR_FAFIMAGES.[NAME],
USR_FAFIMAGES.[DESCRIPTION],
USR_FAFIMAGES.[FILENAME],
USR_FAFIMAGES.[UPLOADFILENAME],
USR_FAFIMAGES.[IMAGETYPE],
USR_FAFIMAGES.[IMAGESIZE],
USR_FAFIMAGES.[IMAGECONTENT],
USR_FAFIMAGES.[CAPTION],
USR_FAFIMAGES.[APPROVED],
USR_FAFIMAGES.[PRIVATE],
USR_FAFIMAGES.[PHOTOGRAPHER],
USR_FAFIMAGES.[PHOTODATETAKEN],
USR_FAFIMAGES.[TAGS],
USR_FAFIMAGES.[EXTERNALFLAG],
USR_FAFIMAGES.[IMAGESOURCECODE],
USR_FAFIMAGES.[EXTERNALURL],
ADDEDBY.APPLICATIONNAME as [ADDEDBY_APPLICATION],
ADDEDBY.USERNAME as [ADDEDBY_USERNAME],
CHANGEDBY.APPLICATIONNAME as [CHANGEDBY_APPLICATION],
CHANGEDBY.USERNAME as [CHANGEDBY_USERNAME],
USR_FAFIMAGES.DATEADDED,
USR_FAFIMAGES.DATECHANGED,
USR_FAFIMAGES.TSLONG
from
dbo.USR_FAFIMAGES
left join dbo.CHANGEAGENT as [ADDEDBY] on [ADDEDBY].ID = USR_FAFIMAGES.ADDEDBYID
left join dbo.CHANGEAGENT as [CHANGEDBY] on [CHANGEDBY].ID = USR_FAFIMAGES.CHANGEDBYID