Timeline for QGIS - many to many relations - query expression
Current License: CC BY-SA 4.0
16 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Oct 20, 2023 at 13:05 | history | bumped | CommunityBot | This question has answers that may be good or bad; the system has marked it active so that they can be reviewed. | |
| S Sep 21, 2023 at 8:05 | history | bounty ended | CommunityBot | ||
| S Sep 21, 2023 at 8:05 | history | notice removed | CommunityBot | ||
| Sep 19, 2023 at 17:20 | comment | added | jbalk | I think you could just do the first step of my answer, but join the parcel table to the links table. Then you would have a polygon for each row in the links table. If you want all the information in one table, you can join the other 2 tables to the first join result. | |
| Sep 16, 2023 at 8:57 | comment | added | Marek | yes, my problem is, if I start a search by attribute in the link table the results do not affect the layer with the polygons. In other words: i would either like the selection to be also linked to the polygon layer, or if selecting in the polygon layer, to be able to have a query expression to choose attributes form the linked tables, like for exapmle select all parcels from owner Miller. Or show me all parcels without contracts... | |
| Sep 14, 2023 at 17:13 | answer | added | jbalk | timeline score: 1 | |
| Sep 14, 2023 at 17:04 | comment | added | jbalk | Can you elaborate a bit? It seems like the information you want is already in the links table. If you query the links table for owner 2, you would get parcels 1 & 3 both under contract 2. Do you want a table that has the actual owner name, parcel number and contract number/link? For example, if you query for owner miller, you would get parcels 23 & 44/6 both under contract 20190628? | |
| Sep 14, 2023 at 7:43 | comment | added | Marek | if there is no other , sure it would be an option. I've never done this before, so i am quite unfamiliar with the procedure... | |
| Sep 13, 2023 at 19:29 | comment | added | geozelot | Is writing SQL an option for you? QGIS can compile and execute the SQLite/SpatiaLite dialect and functionality on most data sources narively. Use a Virtual Layer (from the Layer menu or from within the DB Manager) and creaate thematic layers as needed. | |
| S Sep 13, 2023 at 5:27 | history | bounty started | Marek | ||
| S Sep 13, 2023 at 5:27 | history | notice added | Marek | Draw attention | |
| Sep 11, 2023 at 12:21 | comment | added | JGH | the table requires a blank line before it | |
| Sep 11, 2023 at 12:16 | history | edited | JGH | CC BY-SA 4.0 |
fix tables
|
| Sep 11, 2023 at 8:44 | comment | added | Marek | sorry for the display of the tables. in edit mode it looks fine :/ | |
| Sep 11, 2023 at 3:48 | history | edited | PolyGeo♦ |
edited tags
|
|
| Sep 10, 2023 at 21:34 | history | asked | Marek | CC BY-SA 4.0 |