A/B/C Alphabetical Taxonomy Views

By ehappylucky05 on 8 Nov 2007 at 16:46 UTC

Hi All,
I am trying to create something similar in this site
http://drupal.org/node/74715

######################
A | B | C | ...

Accessible Travel
Assisted Living
...

######################
Here is how I structured my category

Travel (top level)
-- Accessible Travel (second level)
------- Hawaii (third level) (content type:page)
------- New York (third level) (content type:page)
------- Newark (third level) (content type:page)
------- New Mexico (third level) (content type:page)
------- Alaska (third level) (content type:page)

However, I noticed the term listed such as Accessible Travel, Assisted Living are taxonomy term (in my case, this is second level category). What I really hope to display is Hawaii, New York, Alaska... such as example below

######################
A (1)| B | C | ...|H(1)|...|N(3)|...

Alaska
...
Hawaii
...
Newark
New Mexico
New York
...
######################
I have tried to manipulate the taxonomy term, node title in view and created my own content type using CCK for last whole month, still can't come up with this view, can anybody help me out?

Thanks!

Comments

A/B/C Alphabetical Taxonomy Views part 2

ehappylucky05 commented 8 November 2007 at 17:48

My goal is to allow users to be able to add content under Accessible Travel (second level) category, such as New Jersey, San Francisco ... , if this can only pick up the taxanomy term, it won't be good, because I don't think is a good idea for user to keep adding terms in the category, it might eventually get out of control, right?
Hope some of you can help!!!!
Thanks a lot in advance!!!

Also, when I tried to display the node title, I got this error, may I know why?
##########################################
user warning: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '(node.title, 1) FROM drupal3_node node WHERE (node.status = '1') AND (node.type' at line 1 query: SELECT LEFT(node.title, 1) AS letter, count(node.nid) AS num_nodes, node.LEFT(node.title, 1) AS letter_LEFT(node.title, 1) FROM drupal3_node node WHERE (node.status = '1') AND (node.type IN ('db_desc')) AND (node.status = '1') GROUP BY LEFT(node.title, 1), letter_LEFT(node.title, 1) ORDER BY letter_LEFT(node.title, 1) ASC LIMIT 0, 30 in /srv/www/htdocs/drupal/drupal3/includes/database.mysql.inc on line 172.
############################################
I am using Drupal 5.3 , mysql 5.0.26
Thanks!!!

You need to patch view_node.inc

wojtha commented 17 May 2008 at 13:12

Look at this issue

"Alphabetic summary listing of node titles causes SQL error"
http://drupal.org/node/171565

... and follow instructions how to patch the node-letter handler.

--
wojtHA

views bonus pack

tm commented 8 November 2007 at 18:48

are you using the views bonus pack to do this?

Both, I am using the view

ehappylucky05 commented 8 November 2007 at 19:16

Both, I am using the view modules and view bonus pack, none of them are working for me

directory?

tm commented 8 November 2007 at 21:00

(sorry for the question; just establishing baseline)

sounds more like a site directory-variant, actually. hmm; i suppose you have already looked at the directory-related modules? the directory module seems to be in limbo (directions); there may also be some "business-directory" stuff in the snippets.

anyway, it does appear that the bottom-half of the split-view needs the taxonomy terms (the sub-filters in the drill-down, in this case). i have tried replacing the terms list with node lists, and the bottom is blank until one of the index letters are clicked. at least they fixed the duplicate-index letters issue.

does not look like i can help you... sorry.