#124 Save RunSQL query with project

closed
nobody
5
2011-04-05
2011-03-11
Fred
No

Would be fantastic to sav SQL Query with the project.
Something like:
1 - the query layer is saved with the project. (just sql and connection...) as another layer like shapefile
2 - the reload in-memory of data happens when opening the project.
3 - There a button to refresh that query when we want... (right click the layer >> refresh query)

Discussion


  • Anonymous
    2011-03-13

    Would be cool to add a way to directly edit the query through properties or directly in the layer view. (i.e. seeing the query and by the way having the ability to edit it.)

     
  • Implemented in svn 2238/2239/2240/2241
    1 - the query layer is saved with the project. (just sql and connection...) as another layer like shapefile
    Done
    2 - the reload in-memory of data happens when opening the project
    Done
    2a)if the query is based on a fence, it is loaded against an empty geometry. It can be refreshed against a new fence at any time
    3 - There a button to refresh that query when we want... (right click the layer >> refresh query)
    Done
    4 - An edit plugin makes it possible to open the query associated with a layer in a new Run SQL Query panel

     
    • status: open --> closed