The Support Forum is closed. Not to worry! Providing the top quality support you expect and we're known for will continue! We're not ending support, just changing where you submit requests. This will provide you with the best experience possible.
Have you purchased an addon for Connections such as one of our premium templates or extensions with a valid license and you need help?
Please open a Support Ticket in your user account.
Are you using the free Connections plugin? Don't worry, you are still very important to us! We are still providing you with the same high quality support that we're known for.
Please open a new support topic in the WordPress support forums for Connections.
i was using this query to get a list of all orgs in a category
SELECT * FROM
wp_connections WHERE visibility = ‘public’ AND id IN ( SELECT entry_id FROM wp_connections_term_relationships WHERE term_taxonomy_id IN ( SELECT term_id FROM wp_connections_terms WHERE wp_connections_terms.name = %s ) ) order by organization
however for members added after updates in the past 6 months or so it looks like there is no corresponding record in wp_connections_term_relationships
Can you suggest how to query for a list of orgs in a specific category like this?
First a question … is there a specific reason you writing you’re own query rather that using the shortcode?
This shortcode should do the trick:
[connections list_type='organization' category='3']
If you need the more low level access, you can do this within PHP like so:`global $connections;
$atts = array(
'list_type' => 'organization',
'category' => 3
$results = $connections->retrieve->entries( $atts );`
The you iterate thru the
If you want to take a look at the actual query being built so you can tweak a custom one to suit, open up the
class.retrieve.php and uncomment line 768 which should be
Hope that helps.
rather than a list of detailed results of a avery member in a category, i just want a list of the names of each organization in the category in a simple list element with each org name linked to a detail page with a single org
This is the shortcode equivalent of what you want to do:
[connections list_type='organization' category='3' template='names']
You cannot reply to this support topic. Please open your own support topic.