Get connected post - Support Fourms - Meta Box

This topic has 2 replies, 2 voices, and was last updated 1 year, 5 months ago by Max@powdersky.com.

Creator

Topic
June 26, 2019 at 7:07 PM #15104

Resolved Max@powdersky.com
Participant

Hi,

Is there a way I can get a connected post without haven’t to query it?

For example I have a connection between resorts and accommodation so if I am on the accommodation page I want to display a link to the resort page, I know I could use the WP_Query but wondered if I could use something a bit more simpler?

i.e get_connected_post_id() EXAMPLE

Thanks
Creator

Topic

Viewing 2 replies - 1 through 2 (of 2 total)

Author

Replies
June 27, 2019 at 3:39 PM #15133
Anh Tran
Keymaster
Hi Max,

You can do raw SQL query like this:
```
global $wpdb;
$ids = $wpdb->get_col( "SELECT <code>to</code> FROM $wpdb->mb_relationships WHERE <code>from</code> = 123 AND <code>type</code> = 'your_relationship' ");
```
PS: I think WP_Query is fine if you set 'fields' => 'ids'.
June 27, 2019 at 5:12 PM #15144

Max@powdersky.com
Participant

Thanks Anh, didn’t realize you could use ‘fields’, neat trick thanks!
Author

Replies

Viewing 2 replies - 1 through 2 (of 2 total)

You must be logged in to reply to this topic.