How to set or update an extended attribute via SQL?

Support

Support
A public community space for Developers, IT Professionals, Architects, and System Administrators to engage and help each other, share knowledge and best practices, find product documentation and Q&A, and discuss technology oriented topics.

How to set or update an extended attribute via SQL?

This question has suggested answer(s)

In order to do some testing, I would like to be able to set and/or update extended attributes on a group via SQL. I know how to use UDF FetchExtendedAttributeValue to retrieve an extended attribute, but I cannot find a function which will allow me to set such an extended attribute via SQL. I would prefer not to have to write a script to do this and would rather do it directly in SQL.

Is there such a function or method?

All Replies
  • What version of Evolution are you running?

    Usually, we recommend using either our In-Process or REST API.

    In-Process: telligent.com/.../34237.groups-in-process-api-service.aspx

    REST: telligent.com/.../35012.update-group-rest-endpoint.aspx

  • Telligent Community 6.1.  I understand that it can be done via the APIs, but I was hoping to avoid writing a script to do this, when I only need to update a few group records.

  • If I'm not mistaken, the Group extended attributes are stored in the cs_Groups table and are actually split across two columns:  PropertyNames and PropertyValues - These colums are serialized and they do not appear to be easily updatable from a Raw SQL Query.

    Your best bet would to use REST...  You can even accomplish this via Fiddler by passing in your appropriate headers and auth tokens...