AnsweredAssumed Answered

Email -Pilcrow fails to LF

Question asked by sawhat on Apr 17, 2018
Latest reply on Apr 27, 2018 by sawhat

I have the following calculated field that returns the Line Items for an order. When I use the SEND MAIL script step with email client option if there is more than 1 line item in the result then the rest of the items get cut off. Data viewer displays the results correctly. If I change the pilcrow to a pipe or comma all the results will display on one line. Is there another delimiter I can use to get the email results to wrap?

 

Let (

[

$wo = _kp_Order ID ;

$table = GTN( OrderLine::OrderID );

$field = GFN( OrderLine::description ) ;

$where = GFN( OrderLine::OrderID );

 

$items = ExecuteSQL ("SELECT " & $field &" FROM " & $table &" WHERE " & $where &" = ?" ; "," ; "¶"

;$wo)

] ;

 

$items)

Outcomes