From f5772451bd8ecbc8167542f3d84b64a062c4795d Mon Sep 17 00:00:00 2001 From: Ted Trask Date: Tue, 16 Nov 2010 08:56:13 +0000 Subject: Fixed bug in search sql statement --- provisioning-model.lua | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) (limited to 'provisioning-model.lua') diff --git a/provisioning-model.lua b/provisioning-model.lua index 6edd25c..28ba58c 100644 --- a/provisioning-model.lua +++ b/provisioning-model.lua @@ -1312,7 +1312,7 @@ search_device_values = function(parameter_id, parameter_value) sql = sql.."template_id = (SELECT template_id FROM provisioning_templates WHERE label='"..escape(parameter_value).."')" else local group, param = string.match(parameter_id or "", "([^%.]*)%.?(.*)") - sql = "device_id = (SELECT d2t.device_id FROM (devices_to_classes d2t JOIN provisioning_classes t USING(class_id) JOIN classes_to_param_groups t2g USING(class_id) ".. + sql = sql.."device_id = (SELECT d2t.device_id FROM (devices_to_classes d2t JOIN provisioning_classes t USING(class_id) JOIN classes_to_param_groups t2g USING(class_id) ".. "JOIN provisioning_groups g USING(group_id) JOIN param_groups_to_params g2p USING(group_id) JOIN provisioning_params p USING(param_id)) ".. "LEFT JOIN provisioning_values v ON(d2t.device_id=v.device_id AND p.param_id=v.param_id AND g.name=v.group_name ) " if group and group ~= "" then -- cgit v1.2.3