StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
primarykey
Id
4692197
data
AcceptedAnswerId
0
AnswerCount
0
ClosedDate
CommentCount
1
CommunityOwnedDate
CreationDate
2011-01-14T14:41:05.453
FavoriteCount
0
LastActivityDate
2011-01-14T14:41:05.453
LastEditDate
LastEditorUserId
0
OwnerUserId
250402
ParentId
4586533
PostTypeId
2
Score
2
ViewCount
0
LastEditorDisplayName
text
Body
<p>To do what you want to do using Views, and not some other contributed module, like Glossary, you'll have to define and theme your own view. </p> <p>First, you'll need to create a new node View. I'm going to call it myglossary, but it doesn't matter. Make sure that one of your fields is the node title, and that it's sorted by node title, ascending. In other words, alphabetical order. I'm assuming you'll be using the unformatted row style (it's default), but you can probably do something similar with the other row styles.</p> <p>Then, you'll have to get into your theme. From the views/theme folder, copy the views-view-unformatted.tpl.php template into the folder of the theme you're using. Rename it to views-view-unformatted--myglossary.tpl.php so it will only be used for this view. Then, open up your theme's template.php file, and add a preprocess function:</p> <pre><code>//Change mytheme to your theme name function mytheme_preprocess_views_view_unformatted__myglossary(&$vars) { //If you have the devel module installed, //this is a great way to see all the available variables //dpm($vars); $results = $vars['view']->result; $rows = $vars['rows']; //Sort rows into letter sets $letters = array(); $i = 0; foreach ($results as $result) { $first_letter = strtolower(substr($result->node_title, 0, 1)); if (is_array($letters[$first_letter])) { array_push($letters[$first_letter], $rows[$i]); } else { $letters[$first_letter] = array($rows[$i]); } $i++; } //Generate glossary navigation $nav = ''; foreach($letters as $letter => $rows) { $num = count($rows); $cap_letter = strtoupper($letter); $nav .= <<<NAV <a href="#$letter" class="letter_link"> $cap_letter </a> ($num) NAV; } //Add to variables $vars['nav'] = $nav; $vars['letters'] = $letters; } </code></pre> <p>Then, you'll have to change the template file you copied over earlier to add in the navigation, and to output the rows in a glossary style:</p> <pre><code><?php if (!empty($title)): ?> <h3><?php print $title; ?></h3> <?php endif; ?> <?php if (!empty($nav)): ?> <div id="glossary_nav"> <?php print $nav; ?> </div> <?php endif; ?> <?php foreach ($letters as $letter=>$rows): ?> <a name="<?php print $letter ?>"></a> <h4 class="letter"> <?php print strtoupper($letter); ?> </h4> <?php foreach ($rows as $id=>$row): ?> <div class="<?php print $classes[$id]; ?>"> <?php print $row; ?> </div> <?php endforeach;?> <?php endforeach; ?> </code></pre> <p>You might need to regenerate the theme registry to have your changes show up on your site.</p>
Tags
Title
singulars
PostAcceptedAnswerId
1. This table or related slice is empty.
PostParentId
1. PODrupal : how to sort and display nodes grouping by first letter in view
  singulars
  PostTypePostTypeId
  PTQuestion
PostTypePostTypeId
1. PTAnswer
UserLastEditorUserId
1. This table or related slice is empty.
UserOwnerUserId
1. USemmychan
plurals
PostLinksPostIdRelatedPostId
1. This table or related slice is empty.
PostLinksRelatedPostIdPostId
1. This table or related slice is empty.
PostsAcceptedAnswerId
1. PODrupal : how to sort and display nodes grouping by first letter in view
  singulars
  PostTypePostTypeId
  PTQuestion
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
2. VO
  singulars
  PostPostId
  PO
  UserUserId
  This table or related slice is empty.
  VoteTypeVoteTypeId
  VTAcceptedByOriginator
3. VO
  singulars
  PostPostId
  PO
  UserUserId
  This table or related slice is empty.
  VoteTypeVoteTypeId
  VTDownMod
CommentsPostId
1. COThis approach might work, but you don't need to do this. You can achieve the same affect without any custom code.
  singulars
  PostPostId
  PO
  UserUserId
  USmessedup

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.