-
-
Notifications
You must be signed in to change notification settings - Fork 2.9k
New issue
Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.
By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.
Already on GitHub? Sign in to your account
many to many relations using 3rd join table not allowing expansion in identify tool #48776
Comments
Hi @palmerj, can you try with newer version of QGIS? CREATE INDEX fki_fkey_parcel ON title_parcel_association USING btree (par_id);
CREATE INDEX fki_fkey_title ON title_parcel_association USING btree (ttl_title_no);
CREATE INDEX idx_tpa_par_id ON title_parcel_association USING btree (par_id);
CREATE INDEX idx_tpa_ttl_title_no ON title_parcel_association USING btree (ttl_title_no); |
Hi @phidrho
I've updated to 3.28.0
AH good find. I've removed those. However, still the same result. |
Can you also please check the new GDAL version? There's been an upgrade to 3.6.0 recently which maybe still isn't available on Mac, but will sure be in next days/weeks. I didn't think that removing duplicated indexes would fix this behavior, because it's probably not related. EDIT: |
Ok great. I will prepare the data tomorrow. Note the QGIS app bundle version of GDAL is 3.3. See:
|
I can confirm this isn't yet fixed -- the code has not changed at all in recent versions |
Thanks @nyalldawson. @phidrho do you still want the data to support development work? |
@palmerj |
Small PostGIS test dataset here linz_test_data.sql.zip. Licence terms in the header of the SQL file. Note while it would be good to get the 3rd join, we actually have relations to plain tables as many as 8 joins. This is due to highly normalised structure of the database. |
Hi @palmerj, I finally got some time to check your data, and everything seems OK with data, but everything also seems to work as documented. Unfortunately, I didn't manage to find where in manual is noted that you can recursively loop through nested features:
You can set up each layer's attribute form to show you data from mapped M-to-M feature, but not with So, this issue seems to be a In the meantime, you can use Actions for relations plugin which can fulfill your needs, but first you need to add some more relations manually which connect a I recorded you an example how to use plugin. |
Ok, maybe it's not clearly documented that the feature info supports n-m-relations, so let's call it a feature! |
I agree, it's kind of same from user perspective view, but different from QGIS organization view. Don't get me wrong, I really like the idea, and maybe your institution/organization has budget to invest into this feature. Here is a list of companies that offer commercial support for implementation of new features. |
…to referenced ones), and support them on arbitrary nesting level Fixes qgis#48776 Previously only referenced relations where presented when exploring a feature, now referenced ones are presented as well. Do that only when the user explicit unfolds a node, to avoid potential 'explosion' of the number of features in the tree in case of a huge database where all features would be connected through relations. If through relations a feature already present in an ancestor node is detected, it is omitted from the related features. Add setting parameters to disable showing referenced and referencing relations. Add a contextual menu item "Explore Feature" to be able to "re-center" the result of the identification tree on a nested feature, to limit the nesting depth.
What is the bug or the crash?
The manual seems to show it's possible with https://docs.qgis.org/3.22/en/docs/user_manual/working_with_vector/attribute_table.html#introducing-many-to-many-n-m-relations.
However, when using the identify tool, I can't get the table attributes for the 3rd table to show using the join table. See
In the example above I should be able to expand the relationship using field on ttl_title_no field, but it's not an option.
Not sure if it's related but I see the following in message log (repeated each time I click on a feature):
The relationships seem to be formed ok.
Steps to reproduce the issue
Versions
Supported QGIS version
New profile
Additional context
No response
The text was updated successfully, but these errors were encountered: