Hi all,

Views has only parent selection Relationship. Why not having child Relationship?
Providing simple patch for that.

Use case

Products catalog of fixed-level depth, where products are tagged with lowest level terms (leafs). And now need to output the products, divided into categories, say - price-list.

1) Create a taxonomy View
2) Add Contextual filter for Parent Term, and set Fixed value = 0 (to select only root of the tree)
3) Add this new Relationship - Child terms.
4) Repeat (3) until low-level reached
5) Add Taxonomy content Relationship to select products.
6) PROFIT!

CommentFileSizeAuthor
#17 views-term_child_relationship-1437494-17.patch1.04 KBfrob
#13 views-term_child_relationship-1437494-4.patch1.14 KBOnkelTem
#9 features-drupal_static_reset-2.patch770 bytesOnkelTem
#4 views-term_child_relationship-1437494-4.patch1.14 KBerikwebb
adding_child_terms_relationship.patch1.16 KBOnkelTem
Support from Acquia helps fund testing for Drupal Acquia logo

Comments

liquidcms’s picture

liquidcms CreditAttribution: liquidcms commented
Status: Active » Reviewed & tested by the community

thanks for this; seems to be just what was needed. odd this wasn't there already.

Status: Reviewed & tested by the community » Needs work

The last submitted patch, adding_child_terms_relationship.patch, failed testing.

fehin’s picture

fehin CreditAttribution: fehin commented

This sounds like a great idea.

erikwebb’s picture

erikwebb CreditAttribution: erikwebb commented
Version: 7.x-3.1 » 7.x-3.x-dev
Status: Needs work » Needs review
FileSize
views-term_child_relationship-1437494-4.patch1.14 KB
philipz’s picture

philipz CreditAttribution: philipz commented

Wow after such long time and just when I thought about it here it is :) Thanks! It works for me fine.

Now if only I could select this relationship in representative node relationship this would be awesome. I'll open a new issue for that and link to patch #4.
My mistake - relationship order matters :)

TimelessDomain’s picture

TimelessDomain CreditAttribution: TimelessDomain commented
Status: Needs review » Reviewed & tested by the community
Summit’s picture

Summit CreditAttribution: Summit commented
Issue summary: View changes

Hi,

Could like this also child terms for node-views be build?

Greetings, Martijn

colan’s picture

colan
he/him
Primary language English
Location Toronto 🇨🇦
CreditAttribution: colan at Colan Schwartz Consulting for Chapter Three commented

We've recently switched our testing from the old qa.drupal.org to DrupalCI. Because of a bug in the new system, #2623840: Views (D7) patches not being tested, older patches must be re-uploaded. On re-uploading the patch, please set the status to "Needs Review" so that the test bot will add it to its queue.

If all tests pass, change the Status back to "Reviewed & tested by the community". We'll most likely commit the patch immediately without having to go through another round of peer review.

We apologize for the trouble, and appreciate your patience.

OnkelTem’s picture

OnkelTem CreditAttribution: OnkelTem as a volunteer commented
Status: Reviewed & tested by the community » Needs review
FileSize
features-drupal_static_reset-2.patch770 bytes
OnkelTem’s picture

OnkelTem CreditAttribution: OnkelTem as a volunteer commented

@colan what is it waiting for? (no testing)

colan’s picture

colan
he/him
Primary language English
Location Toronto 🇨🇦
CreditAttribution: colan at Colan Schwartz Consulting for Chapter Three commented

Tests don't run until the branch passes on its own. We just got it to pass again now so it looks like all of the tests are automatically re-queueing. There will be a large number of them now so please be patient.

Status: Needs review » Needs work

The last submitted patch, 9: features-drupal_static_reset-2.patch, failed testing.

OnkelTem’s picture

OnkelTem CreditAttribution: OnkelTem as a volunteer commented
Status: Needs work » Needs review
FileSize
views-term_child_relationship-1437494-4.patch1.14 KB

Oh, crap, I've uploaded the wrong patch :)
Uploading again, the #4th by erikwebb

ibis’s picture

ibis CreditAttribution: ibis commented

Works very well to select only parent terms what have content even only on children term! And the grouped by count-distinct on the related node-ids gives count of all content from childrens. Thanks!

demonde’s picture

demonde CreditAttribution: demonde commented

Works very well. When will it be contributed to dev?

darrenwh’s picture

darrenwh CreditAttribution: darrenwh as a volunteer and at Investis Digital commented
Status: Needs review » Needs work 
  1. +++ b/modules/taxonomy.views.inc
@@ -370,6 +370,31 @@ function taxonomy_views_data() {
+  // ----------------------------------------------------------------------

    I don't think this comment is in line with DCS? perhaps omit -----? 

  2. +++ b/modules/taxonomy.views.inc
@@ -370,6 +370,31 @@ function taxonomy_views_data() {
+  // term_hierarchy table (reversed)

    Should capitalise first letter and add a period (.) at end.

frob’s picture

frob
Primary language English
CreditAttribution: frob at Clarity Innovations, Inc. commented
Status: Needs work » Needs review
FileSize
views-term_child_relationship-1437494-17.patch1.04 KB

Rerolled patch to better conform to Drupal Coding standards for documentation.

Status: Needs review » Needs work

The last submitted patch, 17: views-term_child_relationship-1437494-17.patch, failed testing.