V_QUERY_JOBATTACHMENT

This provides to ability to query for job attachments.

Fields

Field	Field Type	Null	Description
ID	uniqueidentifier		System record ID
JOBID	uniqueidentifier		Job ID
DATEENTERED	datetime		Date entered
TITLE	nvarchar(50)		Title
AUTHORNAME	nvarchar(154)	yes	Author name
AUTHORID	uniqueidentifier	yes	Author system ID
TYPE	nvarchar(100)		Type
FILENAME	nvarchar(255)		Filename
DATEADDED	datetime		Date added
DATECHANGED	datetime		Date changed
TSLONG	bigint	yes	Timestamp value
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

Definition

Copy

/*
Generated by Blackbaud AppFx Platform
Date:  8/17/2011 2:35:28 PM
Assembly Version:  Blackbaud.AppFx.Platform.SqlClr, Version=2.91.1535.0, Culture=neutral, PublicKeyToken=null
Copyright Blackbaud
*/
CREATE VIEW dbo.V_QUERY_JOBATTACHMENT AS



                select
                    [JOBATTACHMENT].[ID],
                    [JOBATTACHMENT].[JOBID],
                    [JOBATTACHMENT].[DATEENTERED],
                    [JOBATTACHMENT].[TITLE],
                    [AUTHOR].[NAME] as [AUTHORNAME],
                    [JOBATTACHMENT].[AUTHORID],
                    [JOBATTACHMENTTYPECODE].[DESCRIPTION] as [TYPE],
                    [JOBATTACHMENT].[FILENAME],
                    [JOBATTACHMENT].[DATEADDED],
                    [JOBATTACHMENT].[DATECHANGED],
                    [JOBATTACHMENT].[TSLONG],
                    [ADDEDBY].[APPLICATIONNAME] as [ADDEDBY_APPLICATION],
                    [ADDEDBY].[USERNAME] as [ADDEDBY_USERNAME],
                    [CHANGEDBY].[APPLICATIONNAME] as [CHANGEDBY_APPLICATION],
                    [CHANGEDBY].[USERNAME] as [CHANGEDBY_USERNAME]
                    /*#EXTENSION*/ 
                from
                    dbo.JOBATTACHMENT
                inner join
                    dbo.JOBATTACHMENTTYPECODE
                on
                    JOBATTACHMENT.JOBATTACHMENTTYPECODEID = JOBATTACHMENTTYPECODE.ID
                left join
                    dbo.CHANGEAGENT as [ADDEDBY]
                on
                    [ADDEDBY].ID = JOBATTACHMENT.ADDEDBYID
                left join
                    dbo.CHANGEAGENT as [CHANGEDBY]
                on
                    [CHANGEDBY].ID = JOBATTACHMENT.CHANGEDBYID
                left join
                    dbo.CONSTITUENT as [AUTHOR]
                on
                    [AUTHOR].ID = JOBATTACHMENT.AUTHORID