3

I have two users working on the same project with identical shapefiles but in a different geographic area.

User 1 is working in Area 1
User 2 is working on Area 2

When using MapInfo I used to keep track of the progress by creating an SQL SELECT and then GROUP BY. The view was refreshed each time I opened the Workspace.

How may I replicate this in QGIS?

Taras
  • 32,823
  • 4
  • 66
  • 137
N_S
  • 303
  • 1
  • 7
  • 1
    You can look this documentation part : https://docs.qgis.org/3.22/en/docs/user_manual/managing_data_source/create_layers.html?#creating-virtual-layers – J. Monticolo May 05 '22 at 09:15
  • 2
    Is there a non spatial virtual layer in QGIS? - Yes, just dont add geometry. – MrXsquared May 05 '22 at 09:32

1 Answers1

4

As was mentioned by @J.Monticolo in his comment it is possible to exclude the geometry simply by choosing 'No geometry' in the 'Geometry' tab

option1

Also as was mentioned by @MrXsquared in his/her comment: simply do not add the geometry.

SELECT "field1", "field2"
FROM "layer"

Also pay attention to this thread : Selecting all columns except geometry using Virtual Layer in QGIS

Taras
  • 32,823
  • 4
  • 66
  • 137
  • 1
    even by adding a geometry column, there is an explicit option in the dialog : No geometry, for me it's very explicit. – J. Monticolo May 05 '22 at 10:10