diff options
author | Ted Trask <ttrask01@yahoo.com> | 2010-11-16 08:56:13 +0000 |
---|---|---|
committer | Ted Trask <ttrask01@yahoo.com> | 2010-11-16 08:56:13 +0000 |
commit | f5772451bd8ecbc8167542f3d84b64a062c4795d (patch) | |
tree | 30d58eff50edfb910dad8381d642e96443179205 /provisioning-model.lua | |
parent | eccd3867912fcfac7ab762ff7b6e0a58bdeeb4ac (diff) | |
download | acf-provisioning-f5772451bd8ecbc8167542f3d84b64a062c4795d.tar.bz2 acf-provisioning-f5772451bd8ecbc8167542f3d84b64a062c4795d.tar.xz |
Fixed bug in search sql statement
Diffstat (limited to 'provisioning-model.lua')
-rw-r--r-- | provisioning-model.lua | 2 |
1 files changed, 1 insertions, 1 deletions
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 |