From 7d5306ea268033b92cac8496c2d5efdb16b9f6c6 Mon Sep 17 00:00:00 2001 From: ftimme <ft@falkotimme.com> Date: Fri, 28 Jun 2013 14:37:02 -0400 Subject: [PATCH] - Lists can now be created from more than one database table (including sorting and searching) // needs more testing! --- interface/web/client/client_list.php | 4 ++-- 1 files changed, 2 insertions(+), 2 deletions(-) diff --git a/interface/web/client/client_list.php b/interface/web/client/client_list.php index 3eff65b..35258b8 100644 --- a/interface/web/client/client_list.php +++ b/interface/web/client/client_list.php @@ -17,8 +17,8 @@ $app->uses('listform_actions'); -$app->listform_actions->SQLOrderBy = 'ORDER BY company_name, contact_name, client_id'; -$app->listform_actions->SQLExtWhere = "limit_client = 0"; +$app->listform_actions->SQLOrderBy = 'ORDER BY client.company_name, client.contact_name, client.client_id'; +$app->listform_actions->SQLExtWhere = "client.limit_client = 0"; $app->listform_actions->SQLExtSelect = ', client.country as countryiso'; $app->listform_actions->onLoad(); -- Gitblit v1.9.1