Query sql for taxonomies

[asanchez]

Hi !

I need mount a query sql for get the value of hippotaxonomy:description of this node

[jeroen.hoffman]

This is fairly basic… don’t you just need a column specifier?
Basically the structure is //element(*, my:type)/@my:title
There are quite some examples out there, what is the documentation you’re looking at?
Cheers, Jeroen

[asanchez]

@jeroen.hoffman

//element(*, my:type)/@my:title

Thanks for the explanation. I will detail the requirements more specifically:
I need a query that retrieves all the nodes of the second level that contains the property description with the value businessDomain

The concrete problem is that the description is not directly in the hippotaxonomie: category node, but is in its child nodes:

[machak]

something like:
//element(*,hippotaxonomy:category)[hippotaxonomy:categoryinfos/en/@hippotaxonomy:description=‘whatever’]