diff options
| -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 |