USP_DATALIST_PROSPECTRESEARCHDASHBOARDCONSTITUENCIES
This datalist returns constituency information that is used by the prospect research dashboard.
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @CONSTITUENTID | uniqueidentifier | IN | Constituent |
| @ISVISIBLE | bit | IN | Visible |
Definition
Copy
CREATE procedure dbo.USP_DATALIST_PROSPECTRESEARCHDASHBOARDCONSTITUENCIES
(
@CONSTITUENTID uniqueidentifier,
@ISVISIBLE bit = 1
)
as
set nocount on;
declare @DONORCONSTITUENCYDEFTYPECODE int;
declare @DONORCONSTITUENCYDEFLASTYEARS int;
declare @DONORCONSTITUENCYDEFSTARTDATE datetime;
declare @CURRENTDATE datetime;
declare @DONORCONSTITUENCYLOWERDATEBOUND datetime;
if @ISVISIBLE = 1
begin
select
CONSTITUENCYTYPECODE,
DESCRIPTION,
DATEFROM,
DATETO
from
dbo.UFN_CONSTITUENT_GETALLCONSTITUENCIES(@CONSTITUENTID)
order by
DESCRIPTION, DATEFROM, DATETO, CONSTITUENCYTYPECODE;
end
else
begin
select top 1
CONSTITUENCYTYPECODE,
DESCRIPTION,
DATEFROM,
DATETO
from
dbo.UFN_CONSTITUENT_GETALLCONSTITUENCIES(@CONSTITUENTID)
order by
DESCRIPTION, DATEFROM, DATETO, CONSTITUENCYTYPECODE;
end