Livesite code to query taxonomy info in iwtax_node and iwtax_node_type

We have determined that we need to query database on LSDS to map taxonomy text values eg "Audience" to their cryptic key eg "igw1264" so that we can use these in a query to LSCS.

However I can't find any documentation regarding this. There are classes in the livesite.jar such as

TaxonomyDataFetcherDelegate

but can these be used in our own externals to query the database (not the branch.taxonomies file) ?

Or do we need to create driver / query classes of our own?

Any pointers to documentation on this gratefully recieved!

Find more posts tagged with

Comments

Rick Poulin

Based on this and this, it seems like you're not alone and there's nothing overly helpful OOTB so you may have to write your own handler.

Bowker

There is nothing OOTB for accessing this information.

Apparently Taxonomies are not being used by a lot of companies since I received little (if any) help on anything dealing with taxonomies in general.

Below is a list of things we didn't find anything OOTB to accomplish:

1) inserting Taxonomy item into a DCR - wrote our own.

2) Finding Ancestors / Descendants of the current node / value

3) don't try to delete a taxonomy item - removing it from the taxonomy xml file won't remove it from the database (I think)

4) inserting Taxonomy item into a component customization select box

5) converting "key value" to "text value"

6) we have multiple production databases for redundancy there is no way in the system to deploy the taxonomy file to multiple databases in the same environment. (You need to setup triggers on the database to replicate.)

We've come up with solutions to all of these, but each is a unique custom piece of code.

Managing two differents languages in a report.zip

SL_CM

Thanks that's given me a lot of extra information to take forward in terms of using this as a solution