If you have a comment on this topic, contact Aptify Documentation. If you want to return to the Aptify Community Site, please click here.

Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

Version 1 Next »

This part uses a SQL statement to specify that the Data Table Base Part should display a table of the orders where the message recipient is the Ship To person. See "Creating a Derived Part" on page 459 for more information on this type of message part.
This part provides these input values for the Data Table:

  • SQL: SELECT ID, OrderDate 'Order Date', Line1_ProductName 'Product Name', CALC_GrandTotal 'Grand Total' FROM APTIFY.dbo.vwOrders WHERE ShipToID=<%ID%>
  • Title: This is your order history

Note that the other optional input properties are not specified and they use default HTML settings.

  • No labels

Copyright © 2014-2017 Aptify - Confidential and Proprietary