As stated in my first message:
"I am not using Blocks or views. I need my query to work in PHP in functions.php"
The entire page is made in Elementor, I do not use the wordpress page editor, nor the block editor.
But I reproduced your views, exactly, of my demo website.
I created a test page.
I put a View of get-all-oeuvres-ids-separated-by-comma
I get 9, 84 (on my demo) which are IDs of cocktails in the relashionship NOT oeuvre. But it is what we want to show in the end.
I put a View of get-all-linked-cocktails-ids-separated-by-comma
I get a list of ALL cocktails in database
If I put your shortcode in Elementor, it does not work, it does not convert to result it just shows the shortcode as text
Like [get-only-related-cocktails-with-wp_query]
So I tried creating a view that gives me just the IDS of oeuvres
get-all-oeuvres-ids-period
and then use it in toolset_get_related_posts
function my_custom_query10( $query, $widget ) {
$posts_ids_as_string = do_shortcode("[wpv-view name='get-all-oeuvres-ids-period']");
$cocktail_id10 = toolset_get_related_posts(
$posts_ids_as_string, // ids of oeuvres
'oeuvre-cocktail', // slug of the post relationship
'parent',
1000000, 0,
array( ),
'post_id',
'child'
);
$query->set( 'post__in', $cocktail_id10);
}
add_action( 'elementor/query/maquery10', 'my_custom_query10', 10, 2 );
It gives 0 results
I tried this:
function my_custom_query11( $query, $widget ) {
$oeuvres_ids2 = array('159','187');
$cocktail_id11 = toolset_get_related_posts(
$oeuvres_ids2, // ids of oeuvres
'oeuvre-cocktail', // slug of the post relationship
'parent',
1000000, 0,
array( ),
'post_id',
'child'
);
$query->set( 'post__in', $cocktail_id11);
}
add_action( 'elementor/query/maquery11', 'my_custom_query11', 10, 2 );
It gives no results
I tried this:
function my_custom_query10( $query, $widget ) {
$posts_ids_as_string = do_shortcode("[wpv-view name='get-all-oeuvres-ids-separated-by-comma']");
$cocktails_ids = explode(',', $posts_ids_as_string);
$query->set( 'post__in', $cocktails_ids);
}
add_action( 'elementor/query/maquery10', 'my_custom_query10', 10, 2 );
Does not work
The only thing that works is if I enter it by hand
$args = array('84','9');
$query->set( 'post__in', $args);
-> This gives desired result
