Parsing Blob field for Groups

[SanDegan]

Has anyone parsed the Blob field for a group and successfully extracted the SQL statement ?

If so could you share some knowledge with me????

Jeff

[rchavez]

Expanding on my previous reply, you need to look into the Group Translator object.

It will allow you to work with the Group.

In the past I have built tools to do mass updates of groups (due to schema changes) through it.

[RJLedger]

Since you posted this in the Windows/LAN forum.. and not web - her's an example of getting the SQL for Latest Accounts in the Account Family (entity):

   Dim strFamilyName

   strFamilyName = "ACCOUNT"

   Dim strGroupName

   strGroupName = "Latest Accounts"

   Dim strPluginId

   Dim strSQL

  strPluginId = Application.Basicfunctions.GetGroupIds(strFamilyName, strGroupName)

  strSQL = Application.BasicFunctions.GetGroupSQL(strPluginId)

[rchavez]

RJ:

  Your response is spot on. I was thinking more along the ways of being able to modify the Group's SQL, but for retreiving the Group's SQL this is all that needs to be done.

[RJLedger]

A lot of times on upgrades we run into group issues.. especially Slx systems that go WAY back! SO I have a tool to dump and analyze all the group sql to find tables/fields that are causing issues.. Saves me a TON of time!

[RJSamp]

We've been doing it on the LAN side for a Looooong time......

For the web side: http://customerfx.com/pages/cfxproducts/2007/01/01/saleslogix-group-explorer.aspx