From 1d864192f8c91486b938b2ade2e1e148e80b66c9 Mon Sep 17 00:00:00 2001
From: Ted Trask <ttrask01@yahoo.com>
Date: Mon, 18 Jan 2016 16:43:43 +0000
Subject: Fix filter by device_id in listdevices

---
 provisioning-model.lua | 10 +++++++++-
 1 file changed, 9 insertions(+), 1 deletion(-)

diff --git a/provisioning-model.lua b/provisioning-model.lua
index d24e1af..eac1623 100644
--- a/provisioning-model.lua
+++ b/provisioning-model.lua
@@ -1563,7 +1563,15 @@ mymodule.list_devices = function(self, clientdata)
 		local filter = {}
 		for c,f in pairs(retval.value.filter.value) do
 			if columns[c] and f ~= "" then
-				filter[#filter+1] = columns[c].."~'"..provdb.escape(f).."'"
+				if c == "device_id" then
+					if tonumber(f) then
+						filter[#filter+1] = columns[c].."='"..provdb.escape(f).."'"
+					else
+						filter[#filter+1] = columns[c].." IS NULL"
+					end
+				else
+					filter[#filter+1] = columns[c].."~'"..provdb.escape(f).."'"
+				end
 			end
 		end
 
-- 
cgit v1.2.3