Connected_to interference

You’re hooking into ‘posts_where’, right?

Yes Scribu

help?

Any chance for some highlight on this?

The flag is displayed only if you have posts that match both criteria. I don’t think connected_to is ‘lost’; on the contrary.

Add this line before if($the_query->have_posts()) :, to see the final SQL:

var_dump( $the_query->request );

Also, you don’t describe how you order alphabetically.

thx Scribu

As you said, it’s not lost, but it seems not to do the job required.
See pastebin link.
https://pastebin.com/QQi1BScx

First SQL works
All post displayed and connecting flag is displayed when exist.

Second SQL
Displays all post filtered by title LIKE A
But the connection is not shown.

I am using the startwithaction function to drill down by alphabetical letter

thx for looking into it..and sorry if it’s obvious

Ah, you said ‘order’, but you meant ‘filter’.

Displays all post filtered by title LIKE A
But the connection is not shown.

I thought you said you only displayed a flag. What connection do you expect to see?

The problem likely isn’t in the SQL, but in how you’re displaying what you’re trying to display.

Give me the whole story, not just the part that you think is causing the problem.

ok sorry, you’re right

List of country
For each country, articles(post) are “connected”.
So on the listing, I display a link to view articles if a connection is found.
This is working when using the normal listing.

I also use the function startwith..above to filter (sorry) by alphabetical order, so when you click A, you get Australia etc etc.
On this listing my connected article flag is not displaying.

Here’s the code
https://pastebin.com/gL1aH7zn

Ah, I know: The filter on posts_where is affecting all the queries, not just the one you expect.

So, you would only get connected posts that also begin with ‘A’ etc.

You have to remove the filter before doing the connected query. See the remove_filter() function.

should it then be?

global $post;

remove_filter( 'the_content', 'startswithaction' );

  $exp_query = new WP_Query( array(
  'suppress_filters' => false,
  'post_type' => 'post',
  'cat' => '1',
  'connected' => $post->ID) );
  if($exp_query->have_posts()) :

Instead of asking me, just try it.

Sidenote: if the original hook is on ‘posts_where’, why do you attempt to remove it from ‘the_content’ ?

??
you’s the man…

cheers…
and well done for everything…clever man.