Tags from hierarchy taxonomy not nested properly
Last Post 09/09/2015 8:54 AM by Joseph Craig. 6 Replies.
Author Messages
Amanda Thomas
Nuke Pro
Nuke Pro
Posts:73


--
10/29/2014 4:04 PM  
I have created several vocabularies in Taxonomy with the hopes of being able to display links to pages using multiple criteria.

It was necessary to use the hierarchy type for one vocabulary, as they represent categories that each have subcategories.

I have created all the vocabularies, and I go to add a new page. Then I click Tags to select the ones I want, but the hierarchical tag and its sub-tags aren't nested or organized in any detectable way. This is a huge problem, as the total of all the tags is quite numerous, and it's impossible to tell which tags in the list fall under what.

Is there anything to be done?
Amanda Thomas
Nuke Pro
Nuke Pro
Posts:73


--
10/29/2014 4:17 PM  
I am looking at the Taxonomy_Terms db table in SSMS, and since I had copied most of these terms from another vocabulary using SQL, the ones I copies have CreatedOnDate, LastModifiedByUserID, and LastModifiedOnDate set to NULL. Could that be giving me problems?
Joseph Craig
DNN MVP
Posts:11667


--
10/30/2014 9:15 AM  
My guess is that copying via SQL is likely the issue.

I am in the midst of using taxonomy and tags for the first real time on a site. If you look at the table (Taxonomy_Terms) organization you will see TermLeft and TermRight fields. I have not dug into this, but I suspect that they are used in displaying the terms.

I doubt that the Created, etc. fields are causing a problem, and you can easily stick values in them.

Joe Craig, Patapsco Research Group
Complete DNN Support
Amanda Thomas
Nuke Pro
Nuke Pro
Posts:73


--
10/31/2014 3:39 PM  
Yes, I went in and copied the values from TermLeft and TermRight from other Vocabularies that WERE nesting properly, and that solved the problem.

However, I still don't grasp the concept of how the TermLeft and TermRight columns work. Is there any documentation on that?

Thanks!!

Joseph Craig
DNN MVP
Posts:11667


--
10/31/2014 5:48 PM  
Not that I know of.

Mainly, that's an implementation detail that is not necessarily available to the user. You might be able to figure it out by staring at the code or the SQL stored procedures.

Joe Craig, Patapsco Research Group
Complete DNN Support
Kim Wallace
Nuke Newbie
Nuke Newbie
Posts:1


--
09/08/2015 3:16 PM  
My team is trying to understand how to do the same thing: display links to pages using multiple criteria stored in the taxonomy. Did you accomplish this and would you be willing to share how?
Joseph Craig
DNN MVP
Posts:11667


--
09/09/2015 8:54 AM  
Can you please flesh out the details of what you are trying to do? There are several approaches that you might take, but the best choice depends on your requirements.

Joe Craig, Patapsco Research Group
Complete DNN Support


---