hlio
8 years agoMentor
LiQL question about selecting from ancestor category
Hello I'm trying to select the top 5 TKB articles with a specific label, but only within our Japan Category not our English category. I'm not sure how to include the ancestor_categories.id field ...
- 8 years ago
hlio - Have you tried below query.
SELECT subject, view_href FROM messages WHERE labels.text='example' AND conversation.style='tkb' AND conversation.featured = false AND category.id = 'Japan' ORDER BY metrics.views DESC LIMIT 5" />