USP_DATALIST_FAF_FRIENDLY_URL
Returns FAF Friendly Url.
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @PARTICIPANTID | uniqueidentifier | IN | Participant ID |
| @CLIENTSITESID | int | IN | Client Sites ID |
Definition
Copy
CREATE procedure dbo.USP_DATALIST_FAF_FRIENDLY_URL(
@PARTICIPANTID uniqueidentifier=null,
@CLIENTSITESID int
)
as
set nocount on;
select VU.VANITYURL, VU.PAGEID, FF.SEQUENCEID, FF.PAGETYPE, VU.ID
from dbo.FAFFRIENDLYURLPARAMS FF
inner join dbo.VANITYURL VU
on FF.SEQUENCEID = VU.RealmID
where VU.RealmTypeID=7 and VU.ClientSitesID=@CLIENTSITESID and
FF.PARTICIPANTID= @PARTICIPANTID