1

I did a SQL query from a Geopackage with QGIS database manager. The query is correct and it returns me the expected result with it's ID and the GEOM columns. The problem becomes when I load the query as a layer. The software creates the layer but is void as you can see:

enter image description here

Parameters and columns;

enter image description here

Any ideas?

3
  • 1
    I solved it, the problemas was the amibguity between 2 of the columns in the query, ech one of those were at 2 diferents layers. I just especifyed adding "column.atribute" and then the layer loaded with all the information.
    – J.Patordi
    Feb 1, 2021 at 14:20
  • 1
    You should answer your own question when you are able. Might help other people out. Feb 1, 2021 at 14:28
  • The SQL query was a CTE. I did the proces in two querys. First I did the a JOIN, and then I did a selection over that JOIN. I don't know why the result of the CTE's (wich it was correct) it loaded as a void layer.
    – J.Patordi
    Feb 1, 2021 at 18:24

1 Answer 1

0

The problemas was the amibguity between 2 of the columns in the query, ech one of those were at 2 diferents layers. I just especifyed adding "column.atribute" and then the layer loaded with all the information.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.