We have provided some of our PODS types with categories that are organized hierarchically. Similar to the example “Hierarchical Taxonomy: Cuisine” here.

To display the PODS entries, we use the shortcode PODS and the filter instruction with where.

We realize that we can filter the list according to the lowest level of the taxonomy, like where="cuisine.slug='french'".

Is there also a way to filter by the next level of the taxonomy, something like where="cuisine.parent.slug='european'"?

Regards
Friedbert

So far we used a nested SQL query.

where="cuisine.term_id IN (SELECT t.term_id FROM wp_terms p JOIN wp_term_taxonomy t ON p.term_id=t.parent WHERE p.slug='european')"

Unfortunately, this is no longer supported. For some time now, this has led to the error message:

Pods Embed Error: WHERE contains SQL that is not allowed