USP_DATALIST_SPONSORSHIPOPPORTUNITYADHOCQUERY
Returns a list of sponsorship opportunity ad-hoc queries.
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @RECORDTYPENAME | nvarchar(50) | IN | Record Type Name |
Definition
Copy
CREATE procedure [dbo].[USP_DATALIST_SPONSORSHIPOPPORTUNITYADHOCQUERY]
(
@RECORDTYPENAME nvarchar(50)
)
AS
select
ADHOCQUERY.ID,
ADHOCQUERY.QUERYVIEWCATALOGID,
ADHOCQUERY.NAME,
ADHOCQUERY.DESCRIPTION,
QUERYVIEWCATALOG.DISPLAYNAME [QUERYVIEWCATALOG_NAME],
APPUSER.USERNAME [OWNER],
ADHOCQUERY.OWNERID,
ADHOCQUERY.DATEADDED,
coalesce(SITE.NAME, 'All sites') [SITE]
from dbo.ADHOCQUERY
inner join dbo.QUERYVIEWCATALOG on ADHOCQUERY.QUERYVIEWCATALOGID = QUERYVIEWCATALOG.ID
inner join dbo.RECORDTYPE on QUERYVIEWCATALOG.RECORDTYPEID = RECORDTYPE.ID
left join dbo.APPUSER on ADHOCQUERY.OWNERID = dbo.APPUSER.ID
left join dbo.SITE on ADHOCQUERY.SITEID = SITE.ID
where RECORDTYPE.NAME = @RECORDTYPENAME