This thread is resolved. Here is a description of the problem and solution.
Problem:
Use WP_Query to query related posts by new post type relationships.
Solution:
As the document, please try to use the relationship field slug instead of array, for example:
https://toolset.com/forums/topic/problem-after-migration-of-post-relationships/#post-1241340
Relevant Documentation:
This is the technical support forum for Toolset - a suite of plugins for developing WordPress sites without writing PHP.
Everyone can read this forum, but only Toolset clients can post in it. Toolset support works 6 days per week, 19 hours per day.
No supporters are available to work today on Toolset forum. Feel free to create tickets and we will handle it as soon as we are online. Thank you for your understanding.
| Sun | Mon | Tue | Wed | Thu | Fri | Sat |
|---|---|---|---|---|---|---|
| - | 9:00 – 13:00 | 9:00 – 13:00 | 9:00 – 13:00 | 9:00 – 13:00 | 9:00 – 13:00 | - |
| - | 14:00 – 18:00 | 14:00 – 18:00 | 14:00 – 18:00 | 14:00 – 18:00 | 14:00 – 18:00 | - |
Supporter timezone: Asia/Hong_Kong (GMT+08:00)
This topic contains 8 replies, has 2 voices.
Last updated by 5 years, 6 months ago.
Assisted by: Luo Yang.
I had had the following code in my php template file.
<?php
$childargs = array(
'post_type' => 'attorney',
'numberposts' => -1,
'meta_key' => 'wpcf-last-name',
'orderby' => 'meta_value',
'order' => 'ASC',
'meta_query' => array(array(
'key' => '_wpcf_belongs_locations_id',
'value' => get_the_ID()))
);
$child_posts = get_posts($childargs);
foreach ($child_posts as $child_post) {
if(get_post_meta($child_post->ID, 'wpcf-office-contact', true) == '1') :
echo '
echo $child_post->post_title;
if( get_post_meta($child_post->ID, 'wpcf-title') ):
echo ' (' . get_post_meta($child_post->ID, 'wpcf-title', true) . ')';
//echo ''.'
';
endif;
echo '';
endif;
}
?>
<?php
$childargs = array(
'post_type' => 'attorney',
'numberposts' => -1,
'meta_key' => 'wpcf-last-name',
'orderby' => 'meta_value',
'order' => 'ASC',
'meta_query' => array(array(
'key' => '_wpcf_belongs_locations_id',
'value' => get_the_ID()))
);
$child_posts = get_posts($childargs);
foreach ($child_posts as $child_post) {
echo '
echo $child_post->post_title;
if( get_post_meta($child_post->ID, 'wpcf-special-note') ):
echo ' (' . get_post_meta($child_post->ID, 'wpcf-special-note', true) . ')';
//echo ''.'
';
endif;
echo '';
}
?>
Before migration to new post relationships, the pages looked like the attached ("Before Migration.png")
After migration the page looks like the attached ("After Migration.png")
I tried changing the code to this (below) (like i saw on this page https://toolset.com/documentation/customizing-sites-using-php/post-relationships-api/how-to-migrate-your-site-to-new-post-relationships/ ), but after doing so, only a partial list displayed.
<?php
$query = new WP_Query(
array(
'post_type' => 'attorney',
'numberposts' => -1,
//new toolset_relationships query argument
'toolset_relationships' => array(
'role' => 'child',
'related_to' => get_the_ID(),
// this will work only with relationships that have existed before the migration
// if possible, use the relationship slug instead of an array
'relationship' => array( 'locations', 'attorney' )
),
'meta_key' => 'wpcf-last-name',
'orderby' => 'meta_value',
'order' => 'ASC',
)
);
$posts = $query->posts;
foreach ($posts as $child_post) {
echo '
echo $child_post->post_title;
if( get_post_meta($child_post->ID, 'wpcf-special-note') ):
echo ' (' . get_post_meta($child_post->ID, 'wpcf-special-note', true) . ')';
//echo ''.'
';
endif;
echo '';
}
?>
Can you let me know what wrong and how I can fix it?
Even after changing it to:
'relationship' => 'locations_attorney'
I only get a partial list. Not all results display in the list. See attached comparison
I looked at the location again to verify that all attorneys are listed in the relationship. They are, and there should be 11 in the list, but after changing the code to the following, only 5 are displayed. See attached.
'relationship' => 'locations_attorney'
