E-Commerce Configuration Guide : Site Configuration Settings : Email Settings : EXHIBITS MET_MODS MEMBERFREEPtsSel
 
EXHIBITS MET_MODS MEMBERFREEPtsSel
Key value:
DCI and text for statement
Description:
The key contains the padded DCI of the free item modifier and a select statement. If you enter multiple DCIs into PointsModDCIs, then you need one of these select statement entries per DCI.
Example:
EXHIBITS MET_MODS MEMBERFREEPtsSel = Select points1 as uses from gst_pass where pass_no = {{pass_no}} and voided_by='' and voided_for='' and start_date<=GETDATE() and expires>=GETDATE()
See also:
EXHIBITS MET_MODS MEMBRFREE2PtsSel
EXHIBITS MET_MODS MEMBRFREE3PtsSel
MEMBERSHIPTMAMODS FRIENDS PtsSel
MEMBERSHIPTMAMODS FRIENDS2 PtsSel