Return to Jive Software

Up to Discussions in Jive Forums

This Question is Possibly Answered

1 "correct" answer available (4 pts) 2 "helpful" answers available (2 pts)
480 Views 2 Replies Last post: Nov 4, 2009 1:47 PM by Kevin Imber RSS
Tobias Kunz Novice
Tobias Kunz
10 posts since
Nov 20, 2007
Currently Being Moderated

Oct 26, 2009 1:50 AM

Has anybody a solution for a SQL statement, showing up used tags for social groups

We want to harmonize the tags for social groups and are searching for a working SQL statement, that delivers all tags for a given social group - has anybody already experience with a simular SQL? We tried to build it using the database schema for 2.5.x but failed ...

Tags: database, tags, tag, sql, social_group
Kevin Imber Jive Employee
Kevin Imber
293 posts since
Oct 19, 2009
Currently Being Moderated
Nov 4, 2009 12:31 PM in response to: Tobias Kunz
Re: Has anybody a solution for a SQL statement, showing up used tags for social groups

Hello Tobias,

 

If you want to get the tags of a particular group, you could use:

select tagname from jivetag join jivetagcloud on jivetag.tagid=jivetagcloud.tagid where jivetagcloud.containertype=700 and jivetagcloud.containerid=<id>;

This should give you the tag names that are contained in the container with the ID <id>, which you substitute with the actual ID.  You can find your social group IDs in the Admin Console under People > Group Summary.  Social groups have the containertype 700, so if you want to look for other types of containers, you can find them in this document: Content Types and You.  Hope that helps.

 

Thanks,

Kevin

Kevin Imber Jive Employee
Kevin Imber
293 posts since
Oct 19, 2009
Currently Being Moderated
Nov 4, 2009 1:47 PM in response to: Kevin Imber
Re: Has anybody a solution for a SQL statement, showing up used tags for social groups

Hey Tobias,

 

I was mistaken about getting the social group ID from the Admin Console, sorry about that.  You can get it with another SQL query from the social group name:

select groupid from jivesgroup where name='<name>';

and you substitute the <name>.  What this query returns is the <id> for the previous query I told you about.  I hope this helps.

 

Thanks,

Kevin

More Like This

  • Retrieving data ...

Bookmarked By (0)

To better serve our customers we have included functionality to automatically follow up on a case after it has been idle for more than 5 days, and then auto close after an additional 3 days of inactivity. Choose No to acknowledge that this case will remain idle for longer than 5 days.
Making cases public allows other customers to learn from the solution of the case. It can also be used to gain feedback from others in the community. Ask our Support Engineers for more info, but we encourage you to make your cases public.