[Qgis-user] 1 to many relationship does not allow to display the many

Dear list, I have a parent - child relationship set up between a table location (1, the parent) and a table assets (many, the child). The location table contains geometry, the asset table does not. I would like to be able to display each record in the asset table with the corresponding

Re: [Qgis-user] 1 to many relationship does not allow to display the many

Hi Janneke, Maybe you need a field that would uniquely identify the 170 asset rows (their primary key). You can use an ID field of your asset layer or construct one with row_number function? Regards, Harrissou Le jeu. 19 sept. 2019 à 16:10, Janneke van Dijk a écrit : > Dear list, > > I have

[QGIS-it-user] Esportazione tavole Atlante

Buongiorno, ho una domanda sull'esportazione delle tavole generate con un atlante: se ad esempio ho in una cartella A gli shapefile usati per fare la generica tavola vorrei che, arrivati al momento di esportarla, QGIS riconoscesse in automatico il percorso di esportazione puntando alla cartella A

Re: [QGIS-it-user] errore mailing list

ciao a tutti, si è riverificato di nuovo e ho già messo a posto tutto. scusate, ma non ho proprio idea del motivo per cui mailman "impazzisca" grazie della pazienza... s. -- Sent from: http://osgeo-org.1560.x6.nabble.com/QGIS-Italian-User-f5250612.html

Re: [Qgis-user] QGIS 3 copy style form from one attribute table to another (both no geometry) does not seem to work

Thanks for confirming, Matthias (and bummer - I was hoping I had overlooked something :-) ). Will open a ticket. Janneke On 18/09/2019 16:38, Matthias Kuhn wrote: Hi Janneke, Sounds very much like a bug to me (or a very desirable feature, depending on the point of view). Can you open a

Re: [Qgis-user] 1 to many relationship does not allow to display the many

Hi On Thu, Sep 19, 2019 at 3:10 PM Janneke van Dijk wrote: > > What I can do with the DB manager is: > > select location_point.geom, asset_point.assetid, location_point.fid > from asset_point cross join location_point on asset_point.locationid = > location_point.fid > > This should work, but

Re: [Qgis-user] 1 to many relationship does not allow to display the many

Indeed On 19/09/2019 17:56, DelazJ wrote: You mean, it's the selected field in the primary key drop-down menu in DB manager when you want to add the layer? Le jeu. 19 sept. 2019 à 16:42, Janneke van Dijk mailto:janneke.q...@gmail.com>> a écrit : Hi Harrissou, Thanks for the quick

Re: [Qgis-user] 1 to many relationship does not allow to display the many

It sounds like a bug... Can you provide a data sample and project. Also, what QGIS version are you using? Alexandre Neto On Thu, Sep 19, 2019 at 3:57 PM Janneke van Dijk wrote: > Hi Alexandre, > Also thanks for the quick response! > > What I can do with the DB manager is: > > >> select

[Qgis-user] Oracle connections in QGIS for MacOS

Hello, I'm aware that in the QGIS 2.x days in order to connect to any Oracle database a user would need to compile QGIS themselves, including the Oracle instant client libraries (or something like that)... Now that QGIS has an "Official All-in-one, signed installer" for MacOS, will Oracle

Re: [QGIS-it-user] Nuovo Plugin CDU Creator

Ecco Il giorno gio 19 set 2019 alle ore 17:21 Stefano Campus ha scritto: > La licenza del servizio dell'AdE non lo permette e quindi non credo che > sia penalmente oppurtuno introdurre esplicitamente nel plug-in la > possibilità di violazione della licenza. > > Il gio 19 set 2019, 17:12

Re: [Qgis-user] 1 to many relationship does not allow to display the many

You mean, it's the selected field in the primary key drop-down menu in DB manager when you want to add the layer? Le jeu. 19 sept. 2019 à 16:42, Janneke van Dijk a écrit : > Hi Harrissou, > Thanks for the quick response - indeed, I indicated the assetid which is a > unique value. That did not

Re: [QGIS-it-user] Nuovo Plugin CDU Creator

La licenza del servizio dell'AdE non lo permette e quindi non credo che sia penalmente oppurtuno introdurre esplicitamente nel plug-in la possibilità di violazione della licenza. Il gio 19 set 2019, 17:12 Marco Spaziani ha scritto: > Lo so che ora esagero e che, dal nulla che c'era prima, ora

Re: [Qgis-user] 1 to many relationship does not allow to display the many

Hi Alexandre, Also thanks for the quick response! What I can do with the DB manager is: select location_point.geom, asset_point.assetid, location_point.fid from asset_point cross join location_point on asset_point.locationid = location_point.fid This should work, but why the

Re: [Qgis-user] 1 to many relationship does not allow to display the many

3.6, but will check when I have time later tonight and see if other versions show the same issue. And will create a sample project with bug report. Thanks! Janneke On 19/09/2019 18:04, Alexandre Neto wrote: It sounds like a bug... Can you provide a data sample and project. Also, what QGIS

Re: [QGIS-it-user] Nuovo Plugin CDU Creator

Lo so che ora esagero e che, dal nulla che c'era prima, ora chiedo la Luna, però, non si sa mai, se con gli sviluppi futuri di questo plugin si arrivasse, pian pianino, anche a quello che ora vado a proporre, non sarebbe male. Arrivo al dunque. Usando CDU Creator, sia che mi avvalga di un layer

Re: [Qgis-user] 1 to many relationship does not allow to display the many

Hi Harrissou, Thanks for the quick response - indeed, I indicated the assetid which is a unique value. That did not solve the problem, alas... Janneke On 19/09/2019 17:31, DelazJ wrote: Hi Janneke, Maybe you need a field that would uniquely identify the 170 asset rows (their primary key).

Re: [QGIS-it-user] Nuovo Plugin CDU Creator

Per quelle che sono le mie conoscenze servirebbe il servizio WFS che però mi risulta non sia disponibile. Qualcuno ne sa di più?  R Eng. Roberto Marzocchi, PhD GIS Project Coordinator Gter srl (Unige spin-off) Piazza De Marini 3/61 - 16123 Genova P.IVA/CF 01998770992 ph: 010-8694830 - mob: