USP_SIMPLEDATALIST_RE7INTEGRATIONAVAILABLEFIELDS
This simple datalist returns the available The Raiser's Edge integration fields.
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @DIRECTIONCODE | tinyint | IN | DIRECTIONCODE |
Definition
Copy
CREATE procedure dbo.USP_SIMPLEDATALIST_RE7INTEGRATIONAVAILABLEFIELDS(@DIRECTIONCODE tinyint)
as
select
ID as VALUE,
NAME as LABEL
from
dbo.RE7INTEGRATIONAVAILABLEFIELD
where
@DIRECTIONCODE is null or DIRECTIONCODE = @DIRECTIONCODE
order by
NAME;