Hello,

If I
1. create a node view
2. add a taxonomy parent term relationship (hierarchical taxonomy required)
3. add to the fields the taxonomy parent term
4. select this taxonomy parent as the group by field

I get a
GROUP BY uknown

query.

Comments

irakli’s picture

irakli commented

Make sure the group by field is the last one in the list of fields, when you order fields. Also, save and re-enter the view management screen, to make sure caches etc. are not stale.

giorgio79’s picture

giorgio79 commented

Thanks irakli, meanwhile I chose another views query because I became mad and already deleted that view :D. Will try to rebuild but I was desperately looking to make what what I had in mind work :) Appreciate you taking your time to answer. Perhaps someone else will pick up on this.

irakli’s picture

irakli commented
Status: Active » Fixed
masood_mj’s picture

masood_mj commented

I think this tip (group by should be the last field in the list) needs to be mentioned in the tutorial boldly.

irakli’s picture

irakli commented

It is on the project home-page, in bold with "Attention" :) Will add to tutorial too.

Thanks

Status: Fixed » Closed (fixed)

Automatically closed -- issue fixed for 2 weeks with no activity.