Smarter default queries?

[aadrian]

Would be nice if the context menu would also have some smarter query generation.

Right now, the generated query is always only: SELECT * FROM "table" WHERE time > now() - 5m .

It would be very useful if there were the possibility to generate not just for the last 5 mintues, but e.g.:

• dependent on the available timestamps data, i.e. "last_available_date" - 5m instead of just now()-5m
• dependent on the columns, i.e. select col1, col2, col3 from instead of just select * from

Thank you.

[Hypnos3]

It would be nice to be able to configure the default query. t least to define a different value for 'now() - 5m', like 'now() - 60m', ...

[TomTom0815]

I vote for a change of the default query as well.

I changed my local copy to the following queries (which I prefer more - but that's just a personal opinion)

SELECT * FROM "dbname" ORDER BY time DESC LIMIT 1000

AppForm.cs 1487: queryControl.EditorText = string.Format("SELECT * FROM \"{0}\" ORDER BY time DESC LIMIT 1000", measurement);

[mr-manuel]

Can I download your copy somewhere or the relevant *.dll for this change?