[Plugin: Posts 2 Posts] Startswith in WP_Query

p2p_type( 'posts_to_destinations', 'posts_to_posts' )

The second parameter is ignored. You can query multiple connection types simultaneously only by using WP_Query.

ok, so I changed it to
p2p_type('posts_to_destinations' )->each_connected( $wp_query, array(), 'articles' );
and it still works on the first listing, but then when I drill down via a letter, not all connection are found.

this is my wp_query

if( !empty($theletter) ) {
$args = array( 'post_type' => 'destination','paged' => $paged,  'posts_per_page' => $listitems ,'order' => 'ASC', 'orderby' => 'title', 'query' => $wp_query,'startswith'=>$theletter) ;
}else{
$args = array( 'post_type' => 'destination','paged' => $paged,'posts_per_page' => $listitems ,'order' => 'ASC', 'orderby' => 'title', 'query' => $wp_query) ;
 }

the second one works, but when $theletter is in action, only the first item (if there is any connection) will pick up its connection, none other down the list…

In the same type of problem, on a different page, I display the connected page depending on a selection from a select (id)

so I have

$selected = $_GET["optid"];
$args = array(
'post_type' => 'post',
'tax_query' => array(
    array(
		'taxonomy' => 'authortype',
          	'field' => 'slug',
          	'terms' => 'logs'
          )
         ),
                    'paged' => $paged,
                    'posts_per_page' => $listitems ,
                    'order' => 'DESC',
                    'orderby' => 'title',
                    'query' => $wp_query,
                    'connected_type' => 'posts_to_posts',
                    'connected_items' => $selected
                    ) ;

not returning ANY connection via the $selected chosen

You have to keep in mind that I don’t know all the details of your setup. For example, I have no idea what 'query' => $wp_query does.

Like I said in the email, you’ll need to give me some steps to reproduce. For example:

1) Use this code to register these post types and these connection types.
2) Use this code to handle ‘startswith’.
3) Run this query with this kind of post id.

etc.

Note that you’ll probably want to use https://gist.github.com/ for this, since it will likely be a lot of code.

Ok, here we go again,
I have created a Gist with my CPT and the code used to run the listing.
See https://gist.github.com/2281398

The Query works, but when a letter is selected, ie from the alphabet, only the first item in the list will have its connection displayed, ie the icon.

To clarify.
Normal query
– Item 1 – Icon connection display
– Item 2 – Icon connection display
– Item 3
– Item 4 – Icon connection display

Start with query
– Item 1 – Icon connection display
– Item 2
– Item 3
– Item 4

In my previous code, to get connected, I used
`global $post;
remove_filter( ‘posts_where’, ‘startswithaction’ );
$the_query = null;
$the_query = new WP_Query( array(
‘suppress_filters’ => false,
‘post_type’ => array( ‘post’, ‘destination’),
‘connected’ => $post->ID
) ); `

hope you can help/

So, you’re saying that $wp_query returns the exact same posts in both cases, but that in the second case, each_connected() doesn’t work properly.

You still haven’t added the code that handles ‘startswith’, i.e. startswithaction().

yes $wp_query returns the exact same posts.
and yes in second case doesn’t work properly

add_action( 'posts_where', 'startswithaction' );
function startswithaction( $sql ){
    global $wpdb;
    $startswith = get_query_var( 'startswith' );

    if( $startswith ){
        $sql .= $wpdb->prepare( " AND $wpdb->posts.post_title LIKE %s ", $startswith.'%' );
    }

    return $sql;
}

Oh, I know what’s going on. The ‘startswithaction’ is applied to the WP_Query call from each_connected() too, since you’re using get_query_var().

Correct code:

add_action( 'posts_where', 'startswithaction', 10, 2 );
function startswithaction( $sql, $wp_query ){
    global $wpdb;
    $startswith = $wp_query->get( 'startswith' );

    if( $startswith ){
        $sql .= $wpdb->prepare( " AND $wpdb->posts.post_title LIKE %s ", $startswith.'%' );
    }

    return $sql;
}

Told you it wasn’t a bug in P2P. ??

yeap that fixed it nicely…
thx very much again

BELIEVE in the P2P

??