2015-04-03, 20:26
It looks like lastusetime isn't a valid filter for the Textures API, I'll need to look into this further.
In the meantime you should be able to get your query to work by using SQL direct access - add @dbjson=no to your command line. Note that the filter you are using is a date/time string so you will need to use a range, eg. "where lastusetime <= '2015-01-01', as matching on exactly '2015-01-01' is never going to find any rows.
Also note the parser is very basic and requires white space between each term. If you get unusual/unexpected results check the logfile to confirm the correct query is being executed.
In the meantime you should be able to get your query to work by using SQL direct access - add @dbjson=no to your command line. Note that the filter you are using is a date/time string so you will need to use a range, eg. "where lastusetime <= '2015-01-01', as matching on exactly '2015-01-01' is never going to find any rows.
Also note the parser is very basic and requires white space between each term. If you get unusual/unexpected results check the logfile to confirm the correct query is being executed.
