Return to Jive Software

Up to Discussions in Developers
779 Views 8 Replies Last post: Nov 5, 2009 4:54 AM by Benjamin Chiad RSS
Benjamin Chiad Beginner
Benjamin Chiad
279 posts since
Jan 9, 2009
Currently Being Moderated

Sep 11, 2009 6:38 AM

Plugin with a schema

Hi,

 

I want to create a plugin which adds some additional properties associated to a social group.

 

As I see it, I have two choices:

 

Create my own schema storing the social group object id and the information, or to use extended properties for the social group.

 

Either way, I need to provide the following data via a view to an external system:

 

Social Group Name, Social Group URL, Data

 

or something silmilar.

 

Is there a way of specifying a view in the plugins schema.xml?

 

If not, I'll just create by other means, so I guess it's no big deal, but it would be advantageous to have the plugin self contained for future maintenance purposes.

 

Thanks and Kind Regards,

Ben.

Tags: plugin, schema.xml
Todd West Jive Employee
Todd West
15,918 posts since
Jul 14, 2008
Currently Being Moderated
Sep 11, 2009 6:45 AM in response to: Benjamin Chiad
Re: Plugin with a schema

Hey Ben,

 

It seems like this would be best suited to extended properties on the social group object itself. All you would need to do is create an extended property for your data and it will live in the jiveSGroupProp table like this:

 

 

Social Group IDNameValue
This will link to your social group (which you can use to get the name and URL)This will be the name of your data fieldThis will be the value of your data

 

 

Would this work for what you are trying to achieve?

 

-Todd

Benjamin Chiad Beginner
Benjamin Chiad
279 posts since
Jan 9, 2009
Currently Being Moderated
Sep 11, 2009 6:48 AM in response to: Todd West
Re: Plugin with a schema

Hi Todd,

 

Are you saying I don't even have to code anything for this?

 

The other aspect is exposing the data to the other system via the view.

 

Can I use a plugin to create the view, or must I do it directly in the schema?

 

Thanks,

Ben.

Todd West Jive Employee
Todd West
15,918 posts since
Jul 14, 2008
Currently Being Moderated
Sep 11, 2009 6:59 AM in response to: Benjamin Chiad
Re: Plugin with a schema

Hey Ben,

 

Sorry, I'm not too familiar with "views". I'm assuming that this is an Oracle specific mechanism? If you'd like to run some specific SQL with your plugin, this is definitely possible:

 

 

In your schema.xml as defined in these docs:

 

http://www.jivesoftware.com/jivespace/docs/DOC-3439

http://www.jivesoftware.com/jivespace/docs/DOC-3281

 

 

Just do something like this

 

 

<schema name="Social Group Plugin Schema">
  <table name="mySampleTable" description="Sample table to show base schema.xml">
     ... Your optional table schema goes here
  </table>

  <sql description="Default Data."><![CDATA[

     CREATE OR REPLACE VIEW...

     ]]>
  </sql>
</schema>

 

 

 

I think this is what you are looking for. Hope that helps!

 

-Todd

Benjamin Chiad Beginner
Benjamin Chiad
279 posts since
Jan 9, 2009
Currently Being Moderated
Sep 11, 2009 8:19 AM in response to: Todd West
Re: Plugin with a schema

Hi Todd,

 

That looks like it might work.

 

Thanks,

Ben.

Todd West Jive Employee
Todd West
15,918 posts since
Jul 14, 2008
Currently Being Moderated
Sep 11, 2009 8:46 AM in response to: Benjamin Chiad
Re: Plugin with a schema

Great! No problem.

 

-Todd

Airman85 Novice
Airman85
6 posts since
Oct 30, 2009
Currently Being Moderated
Nov 1, 2009 5:37 PM in response to: Todd West
Re: Plugin with a schema

Is it possible to customize a Social Group Property in the admin console somewhere?

 

Somewhat like the extended properties for Communities?

 

Thanks.

Benjamin Chiad Beginner
Benjamin Chiad
279 posts since
Jan 9, 2009
Currently Being Moderated
Nov 1, 2009 9:51 PM in response to: Airman85
Re: Plugin with a schema

Hi Airman85,

 

Having analysed the possibilitied here myself, the only way I found was to modify the Create and Edit action classes and related FTL to add an additional field. I used the actions to store the additional value in the extended properties of the social groups.

 

Manipulating extended properties is possible via the Java APIs for the Social Group class.

 

Kind Regards,

Ben.

Benjamin Chiad Beginner
Benjamin Chiad
279 posts since
Jan 9, 2009
Currently Being Moderated
Nov 5, 2009 4:54 AM in response to: Todd West
Re: Plugin with a schema

Was able to create the plugin the schema without any issues.

Was able to create a view which brought all the information together including from the social group properties, so didn't need to implement a special table.

 

Even seems to have migrated cleanly to 4.0.0.

 

Thanks,

Ben.

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.