[Plugin: Posts 2 Posts] Access values in connection field array?

Hi scribu, thanks for your reply.
Yes I want to get back all the ‘childtype’ values that have at least one connection (I’m using it in combination with the domtab javascript). How do I achieve that exactly?
Thanks!

And what about just getting the values regardless if it has a connected post or not?

Hi thanks for that,

Can’t seem to get this working, echo $terms does give me an array, but I’m not sure how I should do the foreach loop? I’m not really an expert on SQL queries I have to admit…

$terms = $wpdb->get_col("SELECT DISTINCT meta_value FROM $wpdb->p2pmeta WHERE meta_key = 'childtype'" );

foreach($terms as $type):
	$connected = $participant_connection->get_connected( get_queried_object_id(), array(
		'connected_meta' => array('childtype' => $type )
	) );
	if ($connected->have_posts() ) :
		echo '<li><a href="#'.$type.'">'.$type.'</a></li>';
	endif;
endforeach;

I want to make an list item for every value (value1, value2 etc).
Any ideas on this?
Thanks!

Oh by the way, I’m getting an error with the development version (0.9.5-alpha) when deleting an image from my media library:

Fatal error: Call to undefined method P2P_Storage::get() in /mydomain/wp-content/plugins/posts-to-posts/core/storage.php on line 80

Just to let you know

Hi scribu,

After upgrading to the 1.1 plugin version, the p2p_split_posts doesn’t work anymore.

I addressed the issue over here and I put the function in my functions.php like you suggested.

The error Call to undefined function p2p_split_posts() is gone obviously, but the connected posts are not showing up anymore in my domtabs.

I use this code to get the connected posts and split the post types into domtabs:

$connected = p2p_type('event-participant')->get_connected( get_queried_object_id(), array(
	'suppress_filters' => true, // necessary in combination with the sticky-custom-post-types plugin
	'posts_per_page' => -1,
    'orderby' => 'title',
	'order' => 'ASC'
) );
$buckets = p2p_split_posts( $connected, 'participanttype' );
foreach ( $GLOBALS['participant_types'] as $type ) {
	if ( !isset( $buckets[$type] ) )
		continue;
	$bucket = $buckets[$type];
	echo '<li><a href="#'.$type.'">'.$type.'</a></li>';
} ?>

To populate the domtab div’s with the corresponding posts I’m using this code:

foreach ( $buckets as $type => $bucket ) { ?>
	<div class="tab">
		<a name="<?php echo $type; ?>" id="<?php echo $type; ?>"></a>
		<?php foreach ( $bucket as $post ) {
		// Posts } ?>
	</div>
<?php } ?>

I setup my connection type like this:

$GLOBALS['participant_types'] = array('value1', 'value2', 'value3', 'value4','value5');
    p2p_register_connection_type( array(
    	'id' => 'event-participant',
        'from' => 'fiber-event',
		'to' => 'participant',
		'sortable' => '_order',
		'reciprocal' => true,
		'prevent_duplicates' => false,
		'title' => 'Event - Participant connection',
		'fields' => array(
			'project' => 'Project',
			'featuredimage' => 'Attachement ID',
			'participanttype' => array(
				'title' => 'Type',
				'values' => $GLOBALS['participant_types']
			)
		),
		'admin_box' => array('show' => 'any', 'context' => 'advanced')
    ) );

Any idea why it’s not working anymore?
When I downgrade to the 1.0.1 version, it works again?

Thanks!