CODEWITHSUNDEEP
mysqlwordpresspodscms
DelphiLynx
DelphiLynx

Reputation: 921

Wordpress Pods: How to only get (sub)categories with articles in it

I am trying to get all subcategories which have articles linked to it.

To visualize the needed result:

So for my pods , I have the following: (all Advanced Content Type)

Category pod:

Article pod:

I have this query, which works, but it does not skip the subcategories who has no articles in it.

$subcategories = pods( 'category',
    array( 'where' => "category_relation.slug = 'Top Category" 
) );

I know I should do a left join, but I do not see how to get that working because I can only select one pod type at once.

Have anyone experience with this type of getting pods data?

Note: I asked this question on the Pods forum too, but did not get any response. On SO I will reach more people I think and update the forum post on Pods.io with the best answer.

Upvotes: 1

Views: 1531

Answers (1)

Scott Kingsley Clark
Scott Kingsley Clark

Reputation: 987

Have you tried 'where' => 'category_relation.slug = "Top Category" AND 0 < tt.count' yet?

Also, if you pass any string into the 'where' that's a $variable, definite be sure to sanitize it first (pods_sanitize( $variable ), $wpdp->prepare( "category_relation.slug = %s", $variable ), etc..)

Upvotes: 1

Related Questions