I have a parent content type which is categorized with a taxonomy term. Then there are child nodes to the parent. When someone clicks on a category, I want them to see a table basically. It would be of the form:
Parent1 Description
Child1 Description
Child2 Description
Parent2 etc
Seems out of the box I can't get Views to behave that way, so I was thinking I would have one view that is for the Parents, and another for children of a parent, and then somehow (via Display Suite for instance) have the page display the views one after another. Though I suspect that way of thinking is counter to what drupal is all about, so I am really trying to harnass the power of drupal to make that happen, as opposed to writing a custom module (though in the end I think such a custom module would be easier than Views, but I want to max out my understanding of Views before I go that route).
That said, how would you go about creating the Views and then controlling the display in Display Suite?
EDIT: So I figured out the SQL query that would return the results how I want them. Basically something like this
SELECT n.title, d.field_description_value, n.nid, l.field_lesson_target_id from drupal_node n
JOIN drupal_field_data_field_description AS d ON d.entity_id = n.nid
JOIN drupal_taxonomy_index AS t ON t.nid = n.nid
LEFT JOIN drupal_field_data_field_lesson AS l ON l.entity_id = n.nid
ORDER BY COALESCE(l.field_lesson_target_id, n.nid), l.field_lesson_target_id, n.nid
I made sqlfiddle
So I guess it comes down to whether Views is able to produce such queries.