V_QUERY_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: 10/27/2011 12:13:17 PM
Assembly Version: Blackbaud.AppFx.Platform.SqlClr, Version=2.92.537.0, Culture=neutral, PublicKeyToken=null
Copyright Blackbaud
*/
CREATE VIEW dbo.V_QUERY_FAFIMAGES AS
select
FAFIMAGES.ID,
FAFIMAGES.[CONSTITUENTID],
FAFIMAGES.[EVENTID],
FAFIMAGES.[NAME],
FAFIMAGES.[DESCRIPTION],
FAFIMAGES.[FILENAME],
FAFIMAGES.[UPLOADFILENAME],
FAFIMAGES.[IMAGETYPE],
FAFIMAGES.[IMAGESIZE],
FAFIMAGES.[IMAGECONTENT],
FAFIMAGES.[CAPTION],
FAFIMAGES.[APPROVED],
FAFIMAGES.[PRIVATE],
FAFIMAGES.[PHOTOGRAPHER],
FAFIMAGES.[PHOTODATETAKEN],
FAFIMAGES.[TAGS],
FAFIMAGES.[EXTERNALFLAG],
FAFIMAGES.[IMAGESOURCECODE],
FAFIMAGES.[EXTERNALURL],
ADDEDBY.APPLICATIONNAME as [ADDEDBY_APPLICATION],
ADDEDBY.USERNAME as [ADDEDBY_USERNAME],
CHANGEDBY.APPLICATIONNAME as [CHANGEDBY_APPLICATION],
CHANGEDBY.USERNAME as [CHANGEDBY_USERNAME],
FAFIMAGES.DATEADDED,
FAFIMAGES.DATECHANGED,
FAFIMAGES.TSLONG
from
dbo.FAFIMAGES
left join dbo.CHANGEAGENT as [ADDEDBY] on [ADDEDBY].ID = FAFIMAGES.ADDEDBYID
left join dbo.CHANGEAGENT as [CHANGEDBY] on [CHANGEDBY].ID = FAFIMAGES.CHANGEDBYID