StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
primarykey
Id
7569979
data
AcceptedAnswerId
0
AnswerCount
0
ClosedDate
CommentCount
2
CommunityOwnedDate
CreationDate
2011-09-27T13:29:19.140
FavoriteCount
0
LastActivityDate
2011-09-29T16:40:21.987
LastEditDate
2011-09-29T16:40:21.987
LastEditorUserId
312411
OwnerUserId
312411
ParentId
5639328
PostTypeId
2
Score
1
ViewCount
0
LastEditorDisplayName
text
Body
I've done this before on D6 where basically I just create a couple template tpl.php files for my View-1. Inside my View-1 template for Display Output (views-view--default.tpl.php in D7 now) I would simply programmatically find the value passed or returned by View-1 for this row. In your case on each row you would check to see which node is returned by View-1 and then I'd add code in my View-1 template to programmatically load View-2 based on the current View-1 row (ie. node in your case.) Make sense? 5 months late on the response but I was looking for a refresher and seeing if there's a better way to do this now in D7. UPDATE: Just did this on my new D7 install. As an example I'll explain how it relates to my Ubercart implementation. Ubercart, when installed, has it's main "home" shop page located at <code>mysite.com/catalog</code> This page, when loaded, calls a View created by Ubercart called <code>uc_catalog_terms</code>. It is a taxonomy based view and all it does is grab all your Catalog taxonomy categories and render them. E.g As a clothing store, when you navigate to <code>mysite.com/catalog</code>, all you'll see at this page is a grid structure like: Sweaters Shirts Jeans My requirement was that I needed to show the shop catalog categories/terms on this page, but ALSO show 3 random products (images) from that category/term below it each catalog category. E.g Sweaters Random Sweater #1 - Random Sweater #2 - Random Sweater #3 Jeans Random Jean #1 - Random Jean #2 - Random Jean #3 How is this accomplished? I created my own brand new custom view (no page or lock, just default) which grabs 3 random product images based on a taxonomy term ID argument and renders 3 linked product images. I'll call this custom view <code>random_catalog_items</code>. If <code>15</code> is the term ID for Sweaters, when this view is called with the argument <code>15</code> it will only render 3 random linked sweater product images. I now went back to <code>uc_catalog_terms</code> view and created a <code>views-view-fields--uc-catalog-terms.tpl.php</code> (Row Style Output) template file. THE DEFAULT VIEW VERSION OF THIS FILE (BEFORE MODIFICATION) IS: <pre><code><?php foreach ($fields as $id => $field): ?> <?php if (!empty($field->separator)): ?> <?php print $field->separator; ?> <?php endif; ?> <?php print $field->wrapper_prefix; ?> <?php print $field->label_html; ?> <?php print $field->content; ?> <?php print $field->wrapper_suffix; ?> <?php endforeach; ?> </code></pre> THE MODIFIED VERSION BECOMES: <pre><code><?php foreach ($fields as $id => $field): ?> <?php if (!empty($field->separator)): ?> <?php print $field->separator; ?> <?php endif; ?> <?php print $field->wrapper_prefix; ?> <?php print $field->label_html; ?> <?php $title = str_replace('/','-',strtolower($field->raw)); print '<img src="'.drupal_get_path('theme','my_theme').'/images/catalog/'.$title.'-header.png" />'; print '<hr style="width: 100%; background: #000; height: 2px; margin-top: 3px;"/>'; // get the taxonomy term ID $tid = $row->tid; // render the 3 random items if ($random_products = views_get_view('random_catalog_items' )) { print $random_products->execute_display('default', array($tid)); } ?> <?php print $field->wrapper_suffix; ?> <?php endforeach; ?> </code></pre> So as you can see inside the first View, for every row that is rendered I get the current taxonomy term ID being shown through the available row result object - <code>$row->tid</code> and then I simply call my created view for each row, passing along this Term ID as the argument for it. I leave a lot of the default code in there but inside my view configurations the LABELS and such are set to HIDDEN so they don't even render anyway. In your case it should be very easily adaptable to just pass a Node NID instead of a Taxonomy Term ID. VOILA IT ALL WORKS! View within a View! Hope this helps :) It helps to have the Devel module loaded since then inside these View templates you can debug and see what variables are available to you via something like <code>print krumo($row)</code>.
Tags
Title
singulars
PostAcceptedAnswerId
1. This table or related slice is empty.
PostParentId
1. POProgrammatic Views in Drupal 7
 singulars
 PostTypePostTypeId
 PTQuestion
PostTypePostTypeId
1. PTAnswer
UserLastEditorUserId
1. USskålfyfan
UserOwnerUserId
1. USskålfyfan
plurals
PostLinksPostIdRelatedPostId
1. This table or related slice is empty.
PostLinksRelatedPostIdPostId
1. This table or related slice is empty.
PostsAcceptedAnswerId
1. This table or related slice is empty.
PostsParentIdCreationDate
1. This table or related slice is empty.
VotesPostIdCreationDate
1. VO
 singulars
 PostPostId
 PO
 UserUserId
 This table or related slice is empty.
 VoteTypeVoteTypeId
 VTUpMod
CommentsPostId
1. COThis sounds like what I'm looking for - can you offer a code snippet what it looks like calling a variable from a view loaded into a different template?
 singulars
 PostPostId
 PO
 UserUserId
 USstarsinmypockets
2. COJust updated with a full use-case example and code. Hope it helps. @starsinmypockets
 singulars
 PostPostId
 PO
 UserUserId
 USskålfyfan

Querying!

Guidance

A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.