LWP_M2_GET_CUSTOM_VIEW

Description:

This procedure is responsible for selecting eligible rows from a view defined by the client organization as part of a custom view-based scheduled campaign. The view can contain as many fields as the organization would like, and all of them are returned to the mail2 application as output of this procedure for use as personalization tokens in the campaigns that are deployed as part of this scheduled job. 

Signature:

@view varchar(64) = null,
@startDate date = null,
@endDate date = null,
@sessionKey varchar(64) = null)

Any rows in the local view defined by the @view parameter where the [custom_date] field is greater than or equal to the [start_dt] or less than the [end_dt] will be selected as eligible. If the local view doesn't have a [custom_date] field, then an exception is thrown and no data is returned. 

Executed by:

LWP_M2_HANDLE_TRIGGER

Still need help? Contact Us Contact Us