Skip to content

Instantly share code, notes, and snippets.

What would you like to do?
get people's publications from CCA portal
SELECT u.first_name, u.last_name,, pub.title, pub.published_in, pub.url,, pub.description
FROM people_ppublication pub
JOIN people_portalprofile prof ON (pub.object_id =
JOIN people_userprofile u ON (prof.user_id =
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment