Re: [Qgis-user] Problems with data types in joined tables

2013-03-16 Thread Goyo
2013/3/15 Antonio Vico avicomar...@gmail.com: I want the possibility that user can choice data to join, and in a view the join are fixed. I can make a view with states and population and user can ask this view but is user want ask data and sales for example he need another view. I want that

Re: [Qgis-user] Problems with data types in joined tables

2013-03-15 Thread Antonio Vico
El 15/03/2013 0:18, Goyo escribió: 2013/3/14 Antonio Vicoavicomar...@gmail.com: On 14/03/13 22:14, Goyo wrote: I try to join a layer with geometry type and another without and make querys in the conjunt. For example, a layer with states and a table with population. In the joined layer, I can

Re: [Qgis-user] Problems with data types in joined tables

2013-03-14 Thread Antonio Vico
Hi, Thanks for yur reply. I am not problem with sql and I think that someone with knoweledge in sql can do the query. The question is be able to a user without this knoweledge make easyly querys in the joined table. Maybe, this is a little bug in attribute table.

Re: [Qgis-user] Problems with data types in joined tables

2013-03-14 Thread Goyo
2013/3/14 Antonio Vico avicomar...@gmail.com: Hi, Thanks for yur reply. I am not problem with sql and I think that someone with knoweledge in sql can do the query. The question is be able to a user without this knoweledge make easyly querys in the joined table. As far as I know the user can

Re: [Qgis-user] Problems with data types in joined tables

2013-03-14 Thread Antonio Vico
On 14/03/13 22:14, Goyo wrote: 2013/3/14 Antonio Vico avicomar...@gmail.com: Hi, Thanks for yur reply. I am not problem with sql and I think that someone with knoweledge in sql can do the query. The question is be able to a user without this knoweledge make easyly querys in the joined table.

Re: [Qgis-user] Problems with data types in joined tables

2013-03-14 Thread Goyo
2013/3/14 Antonio Vico avicomar...@gmail.com: On 14/03/13 22:14, Goyo wrote: I try to join a layer with geometry type and another without and make querys in the conjunt. For example, a layer with states and a table with population. In the joined layer, I can query about states with

[Qgis-user] Problems with data types in joined tables

2013-03-13 Thread Antonio Vico
Hi, I am testing with joined tables and I have a problem with data types when make a query in Attributes Table. This is the situation: In a Postgres/Postgis I have two tables, one with geographyc information and another with data but without geographyc fiel (relationed both with a fiel). I

Re: [Qgis-user] Problems with data types in joined tables

2013-03-13 Thread Albin Blaschka
Hi! Not a direct answer to your question, but an alternative: What if you do the join on the database-level in making a view in Postgres and using the view? greetings, Albin Am 13.03.2013 10:59, schrieb Antonio Vico: Hi, I am testing with joined tables and I have a problem with data types

Re: [Qgis-user] Problems with data types in joined tables

2013-03-13 Thread Antonio Vico
Create a view in not a solution in this case. Query can change and view only offer a monolitic query. If you want search different options with a view you can't. ___ Qgis-user mailing list Qgis-user@lists.osgeo.org

Re: [Qgis-user] Problems with data types in joined tables

2013-03-13 Thread Goyo
2013/3/13 Antonio Vico avicomar...@gmail.com: Create a view in not a solution in this case. Query can change and view only offer a monolitic query. If you want search different options with a view you can't. If you are not afraid of SQL you can find this plugin useful:

Re: [Qgis-user] Problems with data types in joined tables

2013-03-13 Thread Paolo Cavallini
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Il 13/03/2013 23:00, Goyo ha scritto: 2013/3/13 Antonio Vico avicomar...@gmail.com: Create a view in not a solution in this case. Query can change and view only offer a monolitic query. If you want search different options with a view you can't.