I have a virtual layer in QGIS 2 with a query on a CSV. The CSV gets updated regulary. I need the max/min attributes in the virtual layer to be updated as well. The virtual layer is used as a title in print composer (displayed as attribute table).
The query looks like
SELECT "Events between " as from, min(fromdate) as fromdate, " and " as to, max(todate) as todate from "Events_Happening" WHERE invalid = 0
(Events_Happening is the .csv)
How can I achieve this without recreating the virtual layer by hand every time the csv is updated? (Update on QGIS startup would be enough)