[sean]

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?

[Steven Zahm]

@ sean

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 $results array.

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 print_r($sql); die;

Hope that helps.

[sean]

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

[Steven Zahm]

This is the shortcode equivalent of what you want to do:

[connections list_type='organization' category='3' template='names']

[Author]

Posts