[Resolved] Can’t query for children and taxonomy

[Author]

Posts

[Karla Jacobsen]

I am trying to: Filter based on children of a post and a particular custom taxonomy category.

I visited this URL: hidden link

I expected to see: "Andrea de Anda Photography" should have been under the "Filtered For Both" header.

Instead, I got: Nothing.

[Christian Cox]

Hi can you share the following information with me:
- A screenshot of the Loop Output of this View, or copy and paste the code from the Loop Output of this View.
- A screenshot showing the Query Filter settings of the two other Views, which seem to be working as expected.
- Add the debug="true" parameter to the shortcode used to insert this View, and take a screenshot showing the output. Here's an example of that:

[wpv-view template="None" debug="true"]

I'll review and we can go from there. Thanks!

[Karla Jacobsen]

Screenshots attached, but I'm not sure how to get to that particular shortcode...I've attached a screenshot of the layout which includes the three test views.

[Christian Cox]

Okay I see, you've placed the View using a View cell, not a shortcode. Let's try these steps:
- Delete the first 2 View cells that seem to be working, save the Layout, and see if the 3rd View starts working
- Turn on debug mode by going to Toolset > Settings > Front End Content. Check "Enable Views debug mode" and select Full debug mode. When you reload the page with your View, a popup will be triggered. You may need to disable your popup blocker temporarily and reload the page again. Please open up all the information sections in this popup, then copy + paste the results here for me to review.
- Replace the 2 View cells you deleted and turn off debug mode for now.
- Disable all plugins except Layouts, Types and Views, then retest. If the problem is resolved, reactivate the plugins one by one until the problem is revealed.

Please let me know the results of these tests.

[Karla Jacobsen]

Deleted other views and disabling plugins did not resolve the issue.

###### DEBUG ###################################
Enable line breaks Enable syntax higlighter
Page info

Current page hidden link
Total memory used 1.0047MB
Render time 0.11
Total MySQL queries 82
CPU usage 0.03%
Elements info

- Category-Photographers3 (Listings, Exhibitors ordered by post title, ascending)

ID 6913
Name Category-Photographers3 (Edit)
Kind of element View
Render time 0.00756
Memory used 0.0156MB
Summary Listings, Exhibitors ordered by post title, ascending
Query args Hide
Basic query arguments
Array
(
[post_type] => Array
(
[0] => listing
[1] => exhibitor
)

[paged] => 1
[suppress_filters] =>
[ignore_sticky_posts] => 1
)
MySQL query Hide
SELECT wp_posts.* FROM wp_posts LEFT JOIN wp_term_relationships ON (wp_posts.ID = wp_term_relationships.object_id) WHERE 1=1 AND wp_posts.ID IN (6915,6898,6899,6900,6901,6902,6903,6351) AND (
wp_term_relationships.term_taxonomy_id IN (57)
) AND wp_posts.post_type IN ('listing', 'exhibitor') AND ((wp_posts.post_status = 'publish' OR wp_posts.post_status = 'private')) GROUP BY wp_posts.ID ORDER BY wp_posts.post_title ASC
Items found 0
Query results Hide
WP_Query Object
(
[query] => Array
(
[post_type] => Array
(
[0] => listing
[1] => exhibitor
)

[paged] => 1
[suppress_filters] =>
[ignore_sticky_posts] => 1
[posts_per_page] => -1
[wpv_original_limit] => -1
[wpv_original_offset] => 0
[wpv_original_posts_per_page] => -1
[tax_query] => Array
(
[0] => Array
(
[taxonomy] => listing_cat
[field] => id
[terms] => Array
(
[0] => 57
)

[operator] => IN
[include_children] => 1
)

[relation] => AND
)

[post_status] => Array
(
[0] => publish
[1] => private
)

[post__in] => Array
(
[0] => 6915
[1] => 6898
[2] => 6899
[3] => 6900
[4] => 6901
[5] => 6902
[6] => 6903
[7] => 6351
)

[pr_filter_post__in] => Array
(
[0] => 6915
[1] => 6898
[2] => 6899
[3] => 6900
[4] => 6901
[5] => 6902
[6] => 6903
[7] => 6351
)

[orderby] => title
[order] => ASC
)

[query_vars] => Array
(
[post_type] => Array
(
[0] => listing
[1] => exhibitor
)

[paged] => 1
[suppress_filters] =>
[ignore_sticky_posts] => 1
[posts_per_page] => -1
[wpv_original_limit] => -1
[wpv_original_offset] => 0
[wpv_original_posts_per_page] => -1
[tax_query] => Array
(
[0] => Array
(
[taxonomy] => listing_cat
[field] => id
[terms] => Array
(
[0] => 57
)

[operator] => IN
[include_children] => 1
)

[relation] => AND
)

[post_status] => Array
(
[0] => publish
[1] => private
)

[post__in] => Array
(
[0] => 6915
[1] => 6898
[2] => 6899
[3] => 6900
[4] => 6901
[5] => 6902
[6] => 6903
[7] => 6351
)

[pr_filter_post__in] => Array
(
[0] => 6915
[1] => 6898
[2] => 6899
[3] => 6900
[4] => 6901
[5] => 6902
[6] => 6903
[7] => 6351
)

[orderby] => title
[order] => ASC
[error] =>
[m] =>
[p] => 0
[post_parent] =>
[subpost] =>
[subpost_id] =>
[attachment] =>
[attachment_id] => 0
[name] =>
[static] =>
[pagename] =>
[page_id] => 0
[second] =>
[minute] =>
[hour] =>
[day] => 0
[monthnum] => 0
[year] => 0
[w] => 0
[category_name] =>
[tag] =>
[cat] =>
[tag_id] =>
[author] =>
[author_name] =>
[feed] =>
[tb] =>
[meta_key] =>
[meta_value] =>
[preview] =>
[s] =>
[sentence] =>
[title] =>
[fields] =>
[menu_order] =>
[embed] =>
[category__in] => Array
(
)

[category__not_in] => Array
(
)

[category__and] => Array
(
)

[post__not_in] => Array
(
)

[post_name__in] => Array
(
)

[tag__in] => Array
(
)

[tag__not_in] => Array
(
)

[tag__and] => Array
(
)

[tag_slug__in] => Array
(
)

[tag_slug__and] => Array
(
)

[post_parent__in] => Array
(
)

[post_parent__not_in] => Array
(
)

[author__in] => Array
(
)

[author__not_in] => Array
(
)

[cache_results] => 1
[update_post_term_cache] => 1
[lazy_load_term_meta] => 1
[update_post_meta_cache] => 1
[nopaging] => 1
[comments_per_page] => 50
[no_found_rows] =>
[taxonomy] => listing_cat
[term_id] => 57
)

[tax_query] => WP_Tax_Query Object
(
[queries] => Array
(
[0] => Array
(
[taxonomy] => listing_cat
[terms] => Array
(
[0] => 57
)

[field] => id
[operator] => IN
[include_children] => 1
)

[relation] => AND
)

[relation] => AND
[table_aliases:protected] => Array
(
[0] => wp_term_relationships
)

[queried_terms] => Array
(
[listing_cat] => Array
(
[terms] => Array
(
[0] => 57
)

[field] => id
)

)

[primary_table] => wp_posts
[primary_id_column] => ID
)

[meta_query] => WP_Meta_Query Object
(
[queries] => Array
(
)

[relation] =>
[meta_table] =>
[meta_id_column] =>
[primary_table] =>
[primary_id_column] =>
[table_aliases:protected] => Array
(
)

[clauses:protected] => Array
(
)

[has_or_relation:protected] =>
)

[date_query] =>
[request] => SELECT wp_posts.* FROM wp_posts LEFT JOIN wp_term_relationships ON (wp_posts.ID = wp_term_relationships.object_id) WHERE 1=1 AND wp_posts.ID IN (6915,6898,6899,6900,6901,6902,6903,6351) AND (
wp_term_relationships.term_taxonomy_id IN (57)
) AND wp_posts.post_type IN ('listing', 'exhibitor') AND ((wp_posts.post_status = 'publish' OR wp_posts.post_status = 'private')) GROUP BY wp_posts.ID ORDER BY wp_posts.post_title ASC
[posts] => Array
(
)

[post_count] => 0
[current_post] => -1
[in_the_loop] =>
[comment_count] => 0
[current_comment] => -1
[found_posts] => 0
[max_num_pages] => 0
[max_num_comment_pages] => 0
[is_single] =>
[is_preview] =>
[is_page] =>
[is_archive] => 1
[is_date] =>
[is_year] =>
[is_month] =>
[is_day] =>
[is_time] =>
[is_author] =>
[is_category] =>
[is_tag] =>
[is_tax] => 1
[is_search] =>
[is_feed] =>
[is_comment_feed] =>
[is_trackback] =>
[is_home] =>
[is_404] =>
[is_embed] =>
[is_paged] =>
[is_admin] =>
[is_attachment] =>
[is_singular] =>
[is_robots] =>
[is_posts_page] =>
[is_post_type_archive] =>
[query_vars_hash:WP_Query:private] => e42aab4150e8151395bd94c3c04a91f4
[query_vars_changed:WP_Query:private] =>
[thumbnails_cached] =>
[stopwords:WP_Query:private] =>
[compat_fields:WP_Query:private] => Array
(
[0] => query_vars_hash
[1] => query_vars_changed
)

[compat_methods:WP_Query:private] => Array
(
[0] => init_query_flags
[1] => parse_tax_query
)

)
Filters
Filter arguments before the query using wpv_filter_query Hide
wpv_filter_query
Array
(
[post_type] => Array
(
[0] => listing
[1] => exhibitor
)

[paged] => 1
[suppress_filters] =>
[ignore_sticky_posts] => 1
[posts_per_page] => -1
[wpv_original_limit] => -1
[wpv_original_offset] => 0
[wpv_original_posts_per_page] => -1
[tax_query] => Array
(
[0] => Array
(
[taxonomy] => listing_cat
[field] => id
[terms] => Array
(
[0] => 57
)

[operator] => IN
[include_children] => 1
)

[relation] => AND
)

[post_status] => Array
(
[0] => publish
[1] => private
)

[post__in] => Array
(
[0] => 6915
[1] => 6898
[2] => 6899
[3] => 6900
[4] => 6901
[5] => 6902
[6] => 6903
[7] => 6351
)

[pr_filter_post__in] => Array
(
[0] => 6915
[1] => 6898
[2] => 6899
[3] => 6900
[4] => 6901
[5] => 6902
[6] => 6903
[7] => 6351
)

[orderby] => title
[order] => ASC
)
Filter the returned query using wpv_filter_query_post_process Hide
wpv_filter_query_post_process
WP_Query Object
(
[query] => Array
(
[post_type] => Array
(
[0] => listing
[1] => exhibitor
)

[paged] => 1
[suppress_filters] =>
[ignore_sticky_posts] => 1
[posts_per_page] => -1
[wpv_original_limit] => -1
[wpv_original_offset] => 0
[wpv_original_posts_per_page] => -1
[tax_query] => Array
(
[0] => Array
(
[taxonomy] => listing_cat
[field] => id
[terms] => Array
(
[0] => 57
)

[operator] => IN
[include_children] => 1
)

[relation] => AND
)

[post_status] => Array
(
[0] => publish
[1] => private
)

[post__in] => Array
(
[0] => 6915
[1] => 6898
[2] => 6899
[3] => 6900
[4] => 6901
[5] => 6902
[6] => 6903
[7] => 6351
)

[pr_filter_post__in] => Array
(
[0] => 6915
[1] => 6898
[2] => 6899
[3] => 6900
[4] => 6901
[5] => 6902
[6] => 6903
[7] => 6351
)

[orderby] => title
[order] => ASC
)

[query_vars] => Array
(
[post_type] => Array
(
[0] => listing
[1] => exhibitor
)

[paged] => 1
[suppress_filters] =>
[ignore_sticky_posts] => 1
[posts_per_page] => -1
[wpv_original_limit] => -1
[wpv_original_offset] => 0
[wpv_original_posts_per_page] => -1
[tax_query] => Array
(
[0] => Array
(
[taxonomy] => listing_cat
[field] => id
[terms] => Array
(
[0] => 57
)

[operator] => IN
[include_children] => 1
)

[relation] => AND
)

[post_status] => Array
(
[0] => publish
[1] => private
)

[post__in] => Array
(
[0] => 6915
[1] => 6898
[2] => 6899
[3] => 6900
[4] => 6901
[5] => 6902
[6] => 6903
[7] => 6351
)

[pr_filter_post__in] => Array
(
[0] => 6915
[1] => 6898
[2] => 6899
[3] => 6900
[4] => 6901
[5] => 6902
[6] => 6903
[7] => 6351
)

[orderby] => title
[order] => ASC
[error] =>
[m] =>
[p] => 0
[post_parent] =>
[subpost] =>
[subpost_id] =>
[attachment] =>
[attachment_id] => 0
[name] =>
[static] =>
[pagename] =>
[page_id] => 0
[second] =>
[minute] =>
[hour] =>
[day] => 0
[monthnum] => 0
[year] => 0
[w] => 0
[category_name] =>
[tag] =>
[cat] =>
[tag_id] =>
[author] =>
[author_name] =>
[feed] =>
[tb] =>
[meta_key] =>
[meta_value] =>
[preview] =>
[s] =>
[sentence] =>
[title] =>
[fields] =>
[menu_order] =>
[embed] =>
[category__in] => Array
(
)

[category__not_in] => Array
(
)

[category__and] => Array
(
)

[post__not_in] => Array
(
)

[post_name__in] => Array
(
)

[tag__in] => Array
(
)

[tag__not_in] => Array
(
)

[tag__and] => Array
(
)

[tag_slug__in] => Array
(
)

[tag_slug__and] => Array
(
)

[post_parent__in] => Array
(
)

[post_parent__not_in] => Array
(
)

[author__in] => Array
(
)

[author__not_in] => Array
(
)

[cache_results] => 1
[update_post_term_cache] => 1
[lazy_load_term_meta] => 1
[update_post_meta_cache] => 1
[nopaging] => 1
[comments_per_page] => 50
[no_found_rows] =>
[taxonomy] => listing_cat
[term_id] => 57
)

[tax_query] => WP_Tax_Query Object
(
[queries] => Array
(
[0] => Array
(
[taxonomy] => listing_cat
[terms] => Array
(
[0] => 57
)

[field] => id
[operator] => IN
[include_children] => 1
)

[relation] => AND
)

[relation] => AND
[table_aliases:protected] => Array
(
[0] => wp_term_relationships
)

[queried_terms] => Array
(
[listing_cat] => Array
(
[terms] => Array
(
[0] => 57
)

[field] => id
)

)

[primary_table] => wp_posts
[primary_id_column] => ID
)

[meta_query] => WP_Meta_Query Object
(
[queries] => Array
(
)

[relation] =>
[meta_table] =>
[meta_id_column] =>
[primary_table] =>
[primary_id_column] =>
[table_aliases:protected] => Array
(
)

[clauses:protected] => Array
(
)

[has_or_relation:protected] =>
)

[date_query] =>
[request] => SELECT wp_posts.* FROM wp_posts LEFT JOIN wp_term_relationships ON (wp_posts.ID = wp_term_relationships.object_id) WHERE 1=1 AND wp_posts.ID IN (6915,6898,6899,6900,6901,6902,6903,6351) AND (
wp_term_relationships.term_taxonomy_id IN (57)
) AND wp_posts.post_type IN ('listing', 'exhibitor') AND ((wp_posts.post_status = 'publish' OR wp_posts.post_status = 'private')) GROUP BY wp_posts.ID ORDER BY wp_posts.post_title ASC
[posts] => Array
(
)

[post_count] => 0
[current_post] => -1
[in_the_loop] =>
[comment_count] => 0
[current_comment] => -1
[found_posts] => 0
[max_num_pages] => 0
[max_num_comment_pages] => 0
[is_single] =>
[is_preview] =>
[is_page] =>
[is_archive] => 1
[is_date] =>
[is_year] =>
[is_month] =>
[is_day] =>
[is_time] =>
[is_author] =>
[is_category] =>
[is_tag] =>
[is_tax] => 1
[is_search] =>
[is_feed] =>
[is_comment_feed] =>
[is_trackback] =>
[is_home] =>
[is_404] =>
[is_embed] =>
[is_paged] =>
[is_admin] =>
[is_attachment] =>
[is_singular] =>
[is_robots] =>
[is_posts_page] =>
[is_post_type_archive] =>
[query_vars_hash:WP_Query:private] => e42aab4150e8151395bd94c3c04a91f4
[query_vars_changed:WP_Query:private] =>
[thumbnails_cached] =>
[stopwords:WP_Query:private] =>
[compat_fields:WP_Query:private] => Array
(
[0] => query_vars_hash
[1] => query_vars_changed
)

[compat_methods:WP_Query:private] => Array
(
[0] => init_query_flags
[1] => parse_tax_query
)

)

###############################################

[Christian Cox]

Okay thank you, I'm not quite sure why the View isn't finding any results here.
- Have you added any custom code to functions.php or another PHP file? If so, please copy + paste any wpv_filter_query or wpv_filter_query_post_process hooks here for me to review.
- Is it possible for me to log in and check your wp-admin area to see if I can uncover any issues? If so, please provide login credentials for me here in the private reply fields.

[Christian Cox]

Okay I see a couple of problems here. The show sb-fall-2017 has child exhibitors, but no child listings. Your loop output is only set up to display child listings:

[wpv-post-link id="$listing"]

If you want to show exhibitors, you must modify that to be [wpv-post-link id="$exhibitor"].

However, you won't find any results for this View because the listing-cat taxonomy is not set up to be used with Exhibitors post type. No Exhibitors will ever have the listing cat "Photographers". You'll need to modify the taxonomy to be used with the Exhibitors post type, and ensure that the correct Exhibitors are given the Photographer term.

Make sense?

[Karla Jacobsen]

I understand the general concept of what you are saying, but not well enough to figure out how to fix it.

Is it not possible to display all the listings/vendors associated with a particular show? It seems like I would have to repeat the company name and re-select the listing categories for each exhibitor in order to get them to display correctly; however, this is precisely what I was trying to avoid. Am I missing some way to make this work?

[Christian Cox]

Sorry but I'm not really clear what your post types represent, so I'm not sure what the best answer is. What is an Exhibitor, what is a Listing, and what is a Show? Can you give me a short description of each one? How are they created? How are they related? Why is your View set up to show both Listings and Exhibitors in the Content Selection area? Perhaps a general overview of what your site is trying to accomplish will help me understand the concepts better.

[Karla Jacobsen]

Show - We are a company the produces Bridal Shows, so these represent our events.
Listings - Each of the vendors that participate in our shows, have a web listing. We also have clients that do not participate in our shows, but purchase a web listing. (I probably should have named this one Vendors instead of Listings).
Exhibitors - A type created to manage the many-to-many relationship between Shows and Listings (as described in the Toolset documentation: https://toolset.com/documentation/toolset-training-course/part-9-many-to-many-relationships-in-toolset)

The relationship needs to be many-to-many because the vendors participate in multiple shows and the shows have multiple vendors. My goal is to not have to update information in multiple locations if something changes. I don't want to have to make sure to spell/display the name right and figure out what categories to include every time a vendor signs up for a new show.

Your question "Why is your View set up to show both Listings and Exhibitors in the Content Selection area?"...I selected both when I was trying to figure out how to get things to display correctly, because I thought the problem might be with the Toolset UI rather than the way the hierarchy/relationships work.

Ideally, I want to end up with the exhibitors displayed something like this: hidden link.

Does that help?

[Christian Cox]

Okay thanks, this makes more sense to me now. I think you've got your post relationships set up correctly, I just didn't understand them.

- Please remove the listing-cat filter from the Category-Photographers3 View and remove "Listings" from the Content Selection area.
- Adjust your Loop Output to use a conditional statement that tests the listing-cat taxonomy:

[wpv-layout-start]
	[wpv-items-found]
   <ul>
    <!-- wpv-loop-start -->
	<wpv-loop>
		[wpv-conditional if="( has_term('photographers', 'listing_cat', [wpv-post-id id='$listing']) eq true )"]<li>[wpv-post-link id="$listing"]</li>[/wpv-conditional]
	</wpv-loop>
	<!-- wpv-loop-end -->
    </ul>
	[/wpv-items-found]
	[wpv-no-items-found]
		<strong>[wpml-string context="wpv-views"]No items found[/wpml-string]</strong>
	[/wpv-no-items-found]
[wpv-layout-end]

- Go to Toolset > Settings > Front end Content and find the "Functions inside conditional evaluations" section. Add has_term here.

Now the View will actually find all the Listings associated with the Show, but will only show those with the Listing Category term 'photographer'. Please check this out and see if it's working for you.

[Karla Jacobsen]

I'm not sure if I'm doing something wrong still, or what.

Even if this approach works, it might create a second problem...Will there be a way to hide empty categories?

[Christian Cox]

I see a few differences in our setups that was causing the problem. My slugs were "listing-cat" and "photographer" while yours were "listing_cat" and "photographers" - I see you caught the photographers one. I changed the code to use "listing_cat" and now your View is showing the proper result, I believe. Please confirm.

Will there be a way to hide empty categories?
I don't quite understand what you mean here. In the Category Photographers3 View, the only Listings that will appear have at least the "photographers" term applied. If no terms are applied, the Listing will not show. Can you explain in more detail? Hide empty categories where?

[Karla Jacobsen]

The filters are now working, thank you!

If you look at the show page now, you can see the empty category problem: hidden link. I've added views for two more categories. The Apparel & Accessories category header shows up even though there are no vendors in that category. I know this might seem like a minor point, but showing empty categories will highlight the vendors that we don't have yet, which isn't a good thing for us.

Note: I switched to this method of creating a view for each category because I couldn't get the query to work correctly in a loop, but if there is a better way to be doing this, please let me know! 🙂

Also, thank you for all your help with this sticky problem.

[Karla Jacobsen]

Also, I getting things ready to launch and I just changed the IP on my site, so all the previous links just broke. Use '35.163.243.206' instead of 'ec2-34-210-223-62.us-west-2.compute.amazonaws.com' when trying to connect.