About the Meeting Details Message Part

This part uses a SQL statement to specify that the Meeting Title Base Part should display a table with information about the meeting details from a particular order. See Creating a Derived Part for more information on this type of message part.

This part uses the following SQL statement to populate the Data Table:

SELECT m.SessionWParent AS 'Meeting',m.StartDate AS 'Start Date and Time',omd.AttendeeID_Name As 'Registrant',omd.AttendeeStatus_Name As 'Current Status' FROM dbo.vwOrderMeetDetail omd INNER JOIN dbo.vwMeetings m On omd.ProductID=m.ProductID WHERE omd.OrderID=<%ID%> ORDER BY omd.AttendeeID_Name,m.StartDate

The remaining input properties specify formatting options for the table. See the Message Parts record's Input Map tab for details.