To the best of my knowledge this isn’t possible with v1.1. In v1.2 the query/matching syntax has changed to be more SQL like and you might be able to do LIKE syntax. But we haven’t upgraded to v1.2 yet so I cannot offer any help on that.
Still mongodb, it’s just the query-language that has been expanded. With my limited knowledge (I don’t really know programming or SQL but I can google and we have akcoder on the forum…) we use it like this:
Find a unit that begins with Nokia: InternetGatewayDevice.DeviceInfo.ProductClass LIKE "Nokia%"
Find a unit that contains Nokia: InternetGatewayDevice.DeviceInfo.ProductClass LIKE "%Nokia%"
Find a unit that ends with Nokia: InternetGatewayDevice.DeviceInfo.ProductClass LIKE "%Nokia"
Here’s an OR example: InternetGatewayDevice.DeviceInfo.ModelName LIKE "%DRG719%" OR InternetGatewayDevice.DeviceInfo.ModelName LIKE "%DRG711%" OR InternetGatewayDevice.DeviceInfo.ModelName LIKE "%v2%"
One can also group conditions: (Device.DeviceInfo.ProductClass = "Polar" OR Device.DeviceInfo.ProductClass = "Lunar") AND Tags.bridge IS NULL AND Tags.iptv IS NULL AND Tags.get IS NOT NULL AND Tags.nat IS NOT NULL AND Device.DeviceInfo.ModelName <> "FiberTwist-P2410"