X-Git-Url: http://git.freeside.biz/gitweb/?a=blobdiff_plain;f=httemplate%2Fsearch%2Fcust_event.html;h=deb34b9e5b5da9b284a42f4b1defa0f45ae188e6;hb=bbabe74c658a55d27a6dda7b6579bbd332f8f789;hp=a0429e44fd0a65d161e1b62ca8ce93249e8748a3;hpb=624b2d44625f69d71175c3348cae635d580c890b;p=freeside.git diff --git a/httemplate/search/cust_event.html b/httemplate/search/cust_event.html index a0429e44f..deb34b9e5 100644 --- a/httemplate/search/cust_event.html +++ b/httemplate/search/cust_event.html @@ -188,8 +188,10 @@ my $sql_query = { FS::UI::Web::cust_sql_fields(), ), 'hashref' => {}, - 'extra_sql' => "$where ORDER BY _date ASC", + 'extra_sql' => $where, + 'order_by' => 'ORDER BY _date ASC', 'addl_from' => $join, + 'debug' => 2, }; my $count_sql = "SELECT COUNT(*) FROM cust_event $join $where";