USP_DATALIST_CMS_DONATIONFORMS_BYMODELID
Retrieves all Client Donations IDs that were created from a give model part
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @CONTEXTID | int | IN | Input parameter indicating the context ID for the data list. |
Definition
Copy
CREATE procedure dbo.USP_DATALIST_CMS_DONATIONFORMS_BYMODELID(@CONTEXTID int)
as
set nocount on;
select cd.ID,
cd.ContentId
from dbo.ClientDonations cd inner join dbo.SiteContent sc on cd.ContentId = sc.Id
where sc.FromModelId = @CONTEXTID