Skip Navigation

[Closed] New toolset relationships compatibility

This support ticket is created 3 years, 3 months ago. There's a good chance that you are reading advice that it now obsolete.

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.

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: Africa/Casablanca (GMT+01:00)

This topic contains 12 replies, has 2 voices.

Last updated by Jamal 3 years, 3 months ago.

Assisted by: Jamal.

Author
Posts
#2116449

Hi Shane,

Hope you're fine. We have updated on an old website the toolset relationships functionality. We have modified a lot of shortcodes and other but we struggle on queries.

For example, how to adapt this query ?

[code]
// All projections Query args
$programs_args = array(
'post_type' => 'projection',
'posts_per_page' => -1,
'nopaging' => true,
'order' => 'DESC',
'post_status' => 'publish',
'post__in' => $exclude,
'post__not_in' => $projections_results,
// In edition & in section
'tax_query' => array(
'relation' => 'AND',
array (
'taxonomy' => 'edition',
'field' => 'term_id',
'terms' => array($current_edition_id),
),
// Added by a conditionnal
),
// Have no films
'meta_query' => array(
'relation' => 'AND',
'belongs' => array(
'compare' => 'NOT EXISTS',
'key' => '_wpcf_belongs_film_id',
),
),
// Gets IDs
'fields' => 'ids',
);
[/code]

Or this one :

`
// Query args
$p_args = array(
'post_type' => 'projection',
'posts_per_page' => -1,
'nopaging' => true,
'order' => 'DESC',
'post_status' => 'publish',
'post__in' => $exclude,
// In edition & in section
'tax_query' => array(
'relation' => 'AND',
array (
'taxonomy' => 'edition',
'field' => 'term_id',
'terms' => array($current_edition_id),
),
// Added by a conditionnal
),
// Have films
'meta_query' => array(
'relation' => 'AND',
'belongs' => array(
'compare' => 'IN',
'key' => '_wpcf_belongs_film_id',
'value' => $films_in_section_results,
),
'p-highlights' => array(
'key' => $f,
'compare' => '=',
'value' => 1,
'type' => 'NUMERIC'
)
),
// Gets IDs
'fields' => 'ids',
);
`

Or, we tried updated this one, is that correct ?

// All projections Query args
$projections_args = array(
'post_type' => 'projection',
'posts_per_page' => -1,
'nopaging' => true,
'order' => 'DESC',
'post_status' => 'publish',
'post__in' => $exclude,
// In edition & in section
'tax_query' => array(
'relation' => 'AND',
array (
'taxonomy' => 'edition',
'field' => 'term_id',
'terms' => array($current_edition_id),
),
// Added by a conditionnal
),
// Have films / OLD approach before toolset 3.0
// 'meta_query' => array(
// 'relation' => 'AND',
// 'belongs' => array(
// 'compare' => 'IN',
// 'key' => '_wpcf_belongs_film_id', // A Revoir maj toolset
// 'value' => $films_in_section_results,
// ),
// ),
// Have film / NEW approach
// New toolset_relationships query argument
'toolset_relationships' => array(
'role' => 'child',
'related_to' => $films_in_section_results,
// this will work only with relationships that have existed before the migration
// if possible, use the relationship slug instead of an array
'relationship' => array( 'film', 'projection' )
),
// Gets IDs
'fields' => 'ids',
);

Best regards,
Wilhem

#2117295

Hello Wilhem and thank you for contacting Toolset support.

Shane does not work on weekends. If you don't mind, I'll continue with you on this ticket. If you would prefer to have Shane, I can transfer this thread to him.

The following parts of the 1st and 2nd codes are not correct anymore:

	'meta_query' => array(
		'relation' => 'AND',
		'belongs' => array(
			'compare' => 'NOT EXISTS',
			'key' => '_wpcf_belongs_film_id',
		),
	),

And:

	'meta_query' => array(
		'relation' => 'AND',
		'belongs' => array(
			'compare' => 'IN',
			'key' => '_wpcf_belongs_film_id',
			'value' => $films_in_section_results,
		),
		'p-highlights' => array(
			'key' => $f,
			'compare' => '=',
			'value' => 1,
			'type' => 'NUMERIC'
		)
	),

The "belongs" part is not correct anymore. Because now, Toolset stores the relationships in its own tables rather than in a specialized custom field "_wpcf_belongs_film_id".

In the 3rd code, this part is correct to handle realtionships:

'toolset_relationships' => array(
	'role' => 'child',
	'related_to' => $films_in_section_results,
	// this will work only with relationships that have existed before the migration
	// if possible, use the relationship slug instead of an array
	'relationship' => array( 'film', 'projection' )
),

You can read more about migrating your code to handle the new way of relationships:
- https://toolset.com/documentation/customizing-sites-using-php/post-relationships-api/how-to-migrate-your-site-to-new-post-relationships/

I would suggest building the queries in steps. First, try testing the parts of the relationship, then check the tax_query parts.

I hope this helps. Let me know if you have any questions.

#2117369

Hi Jamal,

No worries ! It's fine !
( I'm sorry, I can't find the markup to show a code section. )

Yes, I just tried the new relationship query, and it's working fine. My first question wasn't accurate ; what I had not found it's how to check ( for example ) if we DON'T have a relationship between two PS.

( OLD )
'meta_query' => array(
'relation' => 'AND',
'belongs' => array(
'compare' => 'NOT EXISTS',
'key' => '_wpcf_belongs_film_id',
),
),

And how to have multiple queries :

( OLD )
'meta_query' => array(
'relation' => 'AND',
'belongs' => array(
'compare' => 'IN',
'key' => '_wpcf_belongs_film_id',
'value' => $films_in_section_results,
),
'p-highlights' => array(
'key' => $f,
'compare' => '=',
'value' => 1,
'type' => 'NUMERIC'
)
),

Is this code will work :

'toolset_relationships' => array(
'role' => 'child',
'related_to' => $films_in_section_results,
'relationship' => array( 'film', 'section' )
),
'meta_query' => array(
'p-highlights' => array(
'key' => $f,
'compare' => '=',
'value' => 1,
'type' => 'NUMERIC'
)
),

Thanks a lot !
Best
Wilhem

#2117393

Regarding the last code, this does not seems correct to me:

'meta_query' => array(
	'p-highlights' => array(
		'key' => $f,
		'compare' => '=',
		'value' => 1,
		'type' => 'NUMERIC'
	)
),

This is the correct way, assuming that the meta_key you are checking against is "p-highlights":

'meta_query' => array(
	array(
		'key' => 'p-highlights',
		'compare' => '=',
		'value' => 1,
		'type' => 'NUMERIC'
	)
),

Read more about WP_Query arguments here https://toolset.com/forums/topic/search-post-without-relation/#post-1227321
If it is a Toolset defined field, it will usually have a prefix "wpcf-", so the code should be:

'meta_query' => array(
	array(
		'key' => 'wpcf-p-highlights',
		'compare' => '=',
		'value' => 1,
		'type' => 'NUMERIC'
	)
),

Check this https://toolset.com/documentation/customizing-sites-using-php/functions/

And regarding posts that do not have a connection in a relationship, we do not have a straightforward way to find them. You will have to search for the posts that have relationships and exclude them. Check the custom code in this ticket, even though you will not be using Toolset hooks, but it can give you an idea. If it is not clear, please elaborate more on your use case. Why are you looking for non-connected posts, and we'll find out a solution.
https://toolset.com/forums/topic/search-post-without-relation/

#2118011

Hi Jamal,

It's working with the new approach ; but it seems a bit longer. Do you have a better idea ?
( $films_in_section_results is a list a films )

< 3.0

 
	$projections_args = array(
		'post_type' 		=> 'projection',
		'posts_per_page' 	=> -1,
		'nopaging' 			=> true,
		'order' 			=> 'DESC',
		'post_status' 		=> 'publish',
			// Have film merged with exclude 
		'post__in'			=> $post__in,
			// In edition & in section
		'tax_query' => array(
			'relation' 		=> 'AND',
			array (
				'taxonomy' 	=> 'edition',
				'field' 	=> 'term_id',
				'terms' 	=> array($current_edition_id),
			),
			// Added by a conditionnal
		),
		// Have films / OLD approach before toolset 3.0 
		'meta_query' => array(
			'relation' 		=> 'AND',
			'belongs' => array(
				'compare' 	=> 'IN',
				'key' 		=> '_wpcf_belongs_film_id', // A Revoir maj toolset 
				'value' 	=> $films_in_section_results,
			),
		),
		// Gets IDs
		'fields' => 'ids',
	);

> 3.0

	$belongs_film_projection_ids = array();
	$relationship = 'film_projection';
	// get the child posts of the parent post
	$belongs_film_projection_ids[] = toolset_get_related_posts(
		array( 'parent' => $films_in_section_results ), //query_by_elements
		$relationship, //relationship
		array(
			100, //limit
			0, //offset
			array(), //args
			'post_id', //return
			'child' //role_to_return : 'parent' | 'child' | 'intermediary' | 'all'
		)
	);
	error_log("belongs_film : find parent returns child");
	error_log(print_r($belongs_film_projection_ids, true));
	
	if ( !is_array($exclude) )
		$post__in = $belongs_film;
	else 
		$post__in = array_merge( $exclude, $belongs_film);

	// All projections Query args 
	$projections_args = array(
		'post_type' 		=> 'projection',
		'posts_per_page' 	=> -1,
		'nopaging' 			=> true,
		'order' 			=> 'DESC',
		'post_status' 		=> 'publish',
			// Have film merged with exclude 
		'post__in'			=> $post__in,
			// In edition & in section
		'tax_query' => array(
			'relation' 		=> 'AND',
			array (
				'taxonomy' 	=> 'edition',
				'field' 	=> 'term_id',
				'terms' 	=> array($current_edition_id),
			),
			// Added by a conditionnal
		),	 
		// Gets IDs
		'fields' => 'ids',
	);

Best regards,
Wilhem

#2118049

Hello Wilhem,

Actually, I don't have any more ideas on how to get the posts that do not have a relationship. Let me discuss it within the team, and if I get any feedback, I'll share it with you.

#2118719

So, I discussed this with the team, and we would like to know more about your use case.

How do you display the results of this WP query? Is it used on the theme's template files?
Or are you using it along with a view?

We need to know more about your website to better advise you. Please share as many details as possible. Or maybe share credentials to your website so we can see this closely! Your next reply will be private to let you share credentials safely.

#2119843

Hi Jamal,

So sorry for ma late reply, last week before holidays, it's a bit busy.

Yes, you are right, it's not inside a view, it's a shortcode used to count post with particular meta / tax / relation to an archive template.

I can paste you the whole function ( with many try ans comment, don't be afraid of ! )

 

/**
 * Used in taxonomies archives templates 
 */
function get_counts($taxonomy_name = 'section', $taxonomy_id = array(), $exclude = array()) {

	/*
		Get Counts old SQL method 
	*/

	/*
	// Get 'wpcf-p-is-guest' // SELECT proj.post_title, film.post_title, proj_meta_key.meta_value
	global $wpdb;
	$sql = <<<SQL
	SELECT film.post_title, film.ID
	FROM wp_posts AS proj, 
	wp_posts AS film, 
	wp_postmeta AS proj_meta_key, 
	wp_postmeta AS proj_meta_film,
	wp_term_relationships AS trs1,
	wp_term_relationships AS trs2
	WHERE ( proj.ID = proj_meta_key.post_id ) 
	AND (proj_meta_film.post_id = proj.ID)
	AND (proj_meta_film.meta_key = '_wpcf_belongs_film_id')
	AND (proj_meta_film.meta_value = film.ID )
	AND ( proj_meta_key.meta_key = 'wpcf-p-is-guest' AND CAST(proj_meta_key.meta_value AS SIGNED) = '1' )
	AND proj.post_type = 'projection' 
	AND ((proj.post_status = 'publish' OR proj.post_status = 'private'))
	AND trs1.object_id = film.ID
	AND trs1.term_taxonomy_id = 219
	AND trs2.object_id = film.ID
	AND trs2.term_taxonomy_id = 221
	GROUP BY proj.ID 
	ORDER BY proj.menu_order, proj.post_date DESC
	SQL;

	$results = $wpdb->get_results($sql);
	print_r($results);
	print_r(count($results));

	// Get 'wpcf-p-young-public' // SELECT proj.post_title, film.post_title, proj_meta_key.meta_value
	global $wpdb;
	$sql = <<<SQL
	SELECT film.post_title, film.ID
	FROM wp_posts AS proj, 
	wp_posts AS film, 
	wp_postmeta AS proj_meta_key, 
	wp_postmeta AS proj_meta_film,
	wp_term_relationships AS trs1,
	wp_term_relationships AS trs2
	WHERE ( proj.ID = proj_meta_key.post_id ) 
	AND (proj_meta_film.post_id = proj.ID)
	AND (proj_meta_film.meta_key = '_wpcf_belongs_film_id')
	AND (proj_meta_film.meta_value = film.ID )
	AND ( proj_meta_key.meta_key = 'wpcf-p-young-public' AND CAST(proj_meta_key.meta_value AS SIGNED) = '1' )
	AND proj.post_type = 'projection' 
	AND ((proj.post_status = 'publish' OR proj.post_status = 'private'))
	AND trs1.object_id = film.ID
	AND trs1.term_taxonomy_id = 219
	AND trs2.object_id = film.ID
	AND trs2.term_taxonomy_id = 221
	GROUP BY proj.ID 
	ORDER BY proj.menu_order, proj.post_date DESC
	SQL;

	$results = $wpdb->get_results($sql);
	print_r($results);
	print_r(count($results));

	// Get 'wpcf-p-highlights' // SELECT proj.post_title, film.post_title, proj_meta_key.meta_value
	global $wpdb;
	$sql = <<<SQL
	SELECT film.post_title, film.ID
	FROM wp_posts AS proj, 
	wp_posts AS film, 
	wp_postmeta AS proj_meta_key, 
	wp_postmeta AS proj_meta_film,
	wp_term_relationships AS trs1,
	wp_term_relationships AS trs2
	WHERE ( proj.ID = proj_meta_key.post_id ) 
	AND (proj_meta_film.post_id = proj.ID)
	AND (proj_meta_film.meta_key = '_wpcf_belongs_film_id')
	AND (proj_meta_film.meta_value = film.ID )
	AND ( proj_meta_key.meta_key = 'wpcf-p-highlights' AND CAST(proj_meta_key.meta_value AS SIGNED) = '1' )
	AND proj.post_type = 'projection' 
	AND ((proj.post_status = 'publish' OR proj.post_status = 'private'))
	AND trs1.object_id = film.ID
	AND trs1.term_taxonomy_id = 219
	AND trs2.object_id = film.ID
	AND trs2.term_taxonomy_id = 221
	GROUP BY proj.ID 
	ORDER BY proj.menu_order, proj.post_date DESC
	SQL;

	$results = $wpdb->get_results($sql);
	print_r($results);
	print_r(count($results));
	*/

	global $current_edition_id;

	// Get counts 
	$counts = array();

	/**
	 * All films / OK 
	 */

	// Films Args
	$films_in_section_args = array(
		'post_type' 		=> 'film',
		'posts_per_page' 	=> -1,
		'nopaging' 			=> true,
		'order' 			=> 'DESC',
		'post_status' 		=> 'publish',
		// In edition & in section
		'tax_query' => array(
			'relation' 		=> 'AND',
			array (
				'taxonomy' 	=> 'edition',
				'field' 	=> 'term_id',
				'terms' 	=> array($current_edition_id),
			),
			// Added by a conditionnal
		),
		// Has status required
		'meta_query' => array(
			'relation' 		=> 'AND',
			array(
				'key'   	=> '_status',
				'value' 	=> ['approved','programmed'],
				'compare' 	=> 'IN'
			)
		),
		// Gets IDs
		'fields' => 'ids',
	);

	// Conditionnal 
	if ( $taxonomy_name === 'section')
		$films_in_section_args['tax_query'][] = array (
			'taxonomy'	=> $taxonomy_name,
			'field' 	=> 'term_id',
			'terms' 	=> $taxonomy_id,
		);

	// Query 
	$films_in_section_query = new WP_Query($films_in_section_args);

	// Results
	$films_in_section_results = $films_in_section_query->posts;

	// Store count
	$counts['films'] = count($films_in_section_results); //found_posts

	// Restore original Post Data 
	wp_reset_postdata();

	/**
	 * All promoted films ( with field )
	 */

	// Promoted args
	$films_promoted_args = array(
		'post_type' 		=> 'film',
		'posts_per_page' 	=> -1,
		'nopaging' 			=> true,
		'order' 			=> 'DESC',
		'post_status' 		=> 'publish',
		// In edition & in section
		'tax_query' => array(
			'relation' 		=> 'AND',
			array (
				'taxonomy' 	=> 'edition',
				'field' 	=> 'term_id',
				'terms' 	=> array($current_edition_id),
			),
			// Added by a conditionnal
		),
		// Has status required
		'meta_query' => array(
			'relation' 		=> 'AND',
			array(
				'key'   	=> '_status',
				'value' 	=> ['approved','programmed'],
				'compare' 	=> 'IN'
			),
			array(
				'key' 		=> 'wpcf-f-promote',
				'compare' 	=> '=',
				'value' 	=> 1,
				'type' 		=> 'NUMERIC'
			),
		),
		// Gets IDs
		'fields' => 'ids',
	);

	// Conditionnal 
	if ( $taxonomy_name === 'section')
		$films_promoted_args['tax_query'][] = array (
			'taxonomy'	=> $taxonomy_name,
			'field' 	=> 'term_id',
			'terms' 	=> $taxonomy_id,
		);

	// Query 
	$films_promoted_args = new WP_Query($films_promoted_args);

	// Results 
	$films_promoted_results = $films_promoted_query->posts;

	// Store count
	$counts['wpcf-f-promote'] = count($films_promoted_results);

	// Restore original Post Data 
	wp_reset_postdata();

	/**
	 * All projections belongs to a film 
	 */

	error_log("> 3.0 films_in_section_results");
	error_log(print_r($films_in_section_results, true));

	$belongs_film_projection_ids = array();
	$relationship = 'film_projection';
	// get the child posts of the parent post
	$belongs_film_projection_ids[] = toolset_get_related_posts(
		array( 'parent' => $films_in_section_results ), //query_by_elements
		$relationship, //relationship
		array(
			// 'child', // query_by_role: Name of the element role to query by. This argument is required if a single post is provided in $query_by_elements, and in other cases, it must not be present at all. Accepted values: 'parent' | 'child' | 'intermediary'.
			100, //limit
			0, //offset
			array(), //args
			'post_id', //return
			'child' //role_to_return : 'parent' | 'child' | 'intermediary' | 'all'
		)
	);
	error_log("> 3.0 belongs_film : find parent returns child");
	error_log(print_r($belongs_film_projection_ids, true));
	

	// All projections Query args 
	if ( !is_array($exclude) )
		$post__in = $belongs_film;
	else 
		$post__in = array_merge( $exclude, $belongs_film);
	$projections_args = array(
		'post_type' 		=> 'projection',
		'posts_per_page' 	=> -1,
		'nopaging' 			=> true,
		'order' 			=> 'DESC',
		'post_status' 		=> 'publish',
			// Have film merged with exclude 
		'post__in'			=> $post__in,
			// In edition & in section
		'tax_query' => array(
			'relation' 		=> 'AND',
			array (
				'taxonomy' 	=> 'edition',
				'field' 	=> 'term_id',
				'terms' 	=> array($current_edition_id),
			),
			// Added by a conditionnal
		),
		// Have films / OLD approach before toolset 3.0 
		// 'meta_query' => array(
		// 	'relation' 		=> 'AND',
		// 	'belongs' => array(
		// 		'compare' 	=> 'IN',
		// 		'key' 		=> '_wpcf_belongs_film_id', // A Revoir maj toolset 
		// 		'value' 	=> $films_in_section_results,
		// 	),
		// ),
		// Have film / NEW approach > NOT WORKING FOR MANY IDs 
		// New toolset_relationships query argument
		// 'toolset_relationships' => array(
		// 	'role' => 'child',
		// 	'related_to' => $films_in_section_results,
		// 	// this will work only with relationships that have existed before the migration
		// 	// if possible, use the relationship slug instead of an array
		// 	//'relationship' => array( 'film', 'projection' ),
		// 	'relationship' => 'film_projection',
		// ),			 
		// Gets IDs
		'fields' => 'ids',
	);

	// Conditionnal 
	if ( $taxonomy_name === 'room')
		$projections_args['tax_query'][] = array (
			'taxonomy'	=> $taxonomy_name,
			'field' 	=> 'term_id',
			'terms' 	=> $taxonomy_id,
		);

	// Query 
	$projections_query = new WP_Query($projections_args);

	// Results 
	$projections_results = $projections_query->posts;

	// Store count
	$counts['projections'] = count($projections_results);


	/**
	 * All projections not belongs to a film 
	 */

	// All projections Query args 
	$programs_args = array(
		'post_type' 		=> 'projection',
		'posts_per_page' 	=> -1,
		'nopaging' 			=> true,
		'order' 			=> 'DESC',
		'post_status' 		=> 'publish',
		'post__in'			=> $exclude,
		'post__not_in'		=> $projections_results,
		// In edition & in section
		'tax_query' => array(
			'relation' 		=> 'AND',
			array (
				'taxonomy' 	=> 'edition',
				'field' 	=> 'term_id',
				'terms' 	=> array($current_edition_id),
			),
			// Added by a conditionnal
		),
		// Have no films
		'meta_query' => array(
			'relation' 		=> 'AND',
			'belongs' => array(
				'compare' 	=> 'NOT EXISTS',
				'key' 		=> '_wpcf_belongs_film_id',
			),
		),
		// Gets IDs
		'fields' => 'ids',
	);

	// Conditionnal 
	if ( $taxonomy_name === 'room')
		$programs_args['tax_query'][] = array (
			'taxonomy'	=> $taxonomy_name,
			'field' 	=> 'term_id',
			'terms' 	=> $taxonomy_id,
		);

	// Query 
	$programs_query = new WP_Query($programs_args);

	// Results 
	$programs_results = $programs_query->posts;

	// Store count
	$counts['programs'] = count($programs_results);

	/**
	 * Projection with fields 
	 */

	$projection_count_fields = array('wpcf-p-is-guest', 'wpcf-p-young-public', 'wpcf-p-highlights');
	foreach ($projection_count_fields as $f) {
		// Query args 
		$p_args = array(
			'post_type' 		=> 'projection',
			'posts_per_page' 	=> -1,
			'nopaging' 			=> true,
			'order' 			=> 'DESC',
			'post_status' 		=> 'publish',
			'post__in'			=> $exclude,
			// In edition & in section
			'tax_query' => array(
				'relation' 		=> 'AND',
				array (
					'taxonomy' 	=> 'edition',
					'field' 	=> 'term_id',
					'terms' 	=> array($current_edition_id),
				),
				// Added by a conditionnal
			),
			// Have films
			'meta_query' => array(
				'relation' 		=> 'AND',
				'belongs' => array(
					'compare' 	=> 'IN',
					'key' 		=> '_wpcf_belongs_film_id',
					'value' 	=> $films_in_section_results,
				),
				'p-highlights' => array(
					'key' 		=> $f,
					'compare' 	=> '=',
					'value' 	=> 1,
					'type' 		=> 'NUMERIC'
				)
			),
			// Gets IDs
			'fields' => 'ids',
		);

		// Conditionnal 
		if ( $taxonomy_name === 'room')
			$p_args['tax_query'][] = array (
				'taxonomy'	=> $taxonomy_name,
				'field' 	=> 'term_id',
				'terms' 	=> $taxonomy_id,
			);

		// Query 
		$p_query = new WP_Query($p_args);

		// Results 
		$p_results = $p_query->posts;

		// Store count
		$counts[$f] = count($p_results);

		if ($f === 'wpcf-p-is-guest') {
			$counts['guests'] = $p_results;
		}

		// Restore original Post Data 
		wp_reset_postdata();
	}

	return $counts;
}

At that time, it's tricky to give you access to the website, I need authorizations.. I'll try !

Best regards, thanks again for your help !

#2120179

I must confess the code is too long and it confused me. And I also do not like the solution to nest WP_Query inside another one using foreach. I get some time to work on it to day and I come up with and SQL query that can return all the posts that have a connection to another post within a relationship. we can use it to pass those post to "post__not_in" from wp_query.

- Get all connected parents

	select DISTINCT
		parents.element_id 
	from 
		wp_toolset_connected_elements parents,
		wp_toolset_associations ta,
		wp_toolset_connected_elements children,
		wp_toolset_relationships tr
	where 
		parents.id = ta.parent_id AND
		children.id = ta.child_id AND
		ta.relationship_id = tr.id AND
		tr.slug = 'state-city'

- Get all the connected children

	select DISTINCT
		children.element_id 
	from 
		wp_toolset_connected_elements parents,
		wp_toolset_associations ta,
		wp_toolset_connected_elements children,
		wp_toolset_relationships tr
	where 
		parents.id = ta.parent_id AND
		children.id = ta.child_id AND
		ta.relationship_id = tr.id AND
		tr.slug = 'state-city'

Notice the relationship slug on the last lines.

I'll be on my weekend for Wednesday and Thursday. After that, once I get the time to work on this, I'll test it on a wp_query code and get back to you. If you, in the meantime, find out how to integrate it into your code, it would be awesome.

All the best,
Jamal

#2120947

Hi Jamal,

Thanks a lot.

However, I really hesitate to use an SQL query directly in a WP environment.
We will lose the WP_queries cache, WP updates, Toolset updates...

I don't see what you get more than :

$belongs_film_projection_ids [] = toolset_get_related_posts (
     array ('parent' => $ films_in_section_results), // query_by_elements
     $ relationship, // relationship
     array (
         100, // limit
         0, // offset
         array (), // args
         'post_id', // return
         'child' // role_to_return: 'parent' | 'child' | 'intermediary' | 'all'
     )
);

This version works well, however, I just need the posts that have no relations : "toolset_get_unrelated_posts";)

Maybe you'll going to suggest me that I do this with an array_diff comparing all post with a get_posts and selected posts with a toolset_get_related_posts ?

It will do the trick .. but, it's seems so boring!
The old relationships were simpler.

Have a great week-end !
Best,
Wilhem

#2123189

Hello Wilhem,

I understand that you don't want to have an SQL query within your website. However, I believe it is the most efficient solution.

Unfortunately, Toolset does not have a proper API to get all the related posts or all the unrelated posts. If you believe this should be added, please suggest it as a feature here https://toolset.com/home/contact-us/suggest-a-new-feature-for-toolset/

Using these SQL queries is not related to WP Queries and WP-Cache, because they are against Toolset database tables instead of WP core tables. Maybe, they won't use Toolset cache, but that's not a documented feature, and honestly, I don't know how it works.

At this point, I am afraid, there is nothing else I could add. So, I'll remain at your disposal, if you have any further questions.

All the best,
Jamal

#2126237

Hello Jamal,

So I'll try your solution.

Best regards,
Wilhem

#2126453

Hi! Let me know if you have any questions. As of now, I'll set this ticket as waiting for your feedback, which should keep it open for 2 weeks.

The topic ‘[Closed] New toolset relationships compatibility’ is closed to new replies.