Syntax for "last contact" dynamic list?

[stephouse]

So I tried creating a dynamic group to show nodes that had not checked in within the last 5 minutes. Since I could find to documentation, I guessed it might be measured in seconds and created a rule for "last contact" > 600.

That clearly wasn't it as now any page I load within AirControl throws a SQL error "org.hibernate.exception.SQLGrammarException: could not execute query"

First, how to I remove the dynamic group from my configuration (it's installed on debian, I'm comfortable poking around on the command line or executing SQL statements if I know what I'm looking for).

Second, what is the syntax for creating dynamic groups based on "last contact"

[stephouse]

After some digging, I've discovered that although "Last Contact" is listed, it's not a valid option for dynamic groups due to it not being a selectable column in the SQL statement as detailed in the error I'm getting in /usr/share/aircontrol/data/${catalina.base}/catalina.2010-01-06.log:

Caused by: java.sql.SQLException: Column not found: D.LASTSTATSTIME in statement [select distinct d.* from Device d left outer join device_attr_value av ON (av.ctime = d.last_stats_time AND av.device_id = d.device_id) left outer join device_attribute attr on (attr.device_attr_id = av.device_attr_id) WHERE d.lastStatsTime > ?]

[UBNT-Thomas]

This field is not supported for dynamic groups at the moment. It will be in the future.