Showing results for 
Search instead for 
Do you mean 
Community Home Request Access Read Blogs Share Your Ideas Search Community View My Settings
Reply
New Member
Posts: 8
Registered: ‎03-21-2012

Parsing Blob field for Groups

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

Bronze Super Contributor
Posts: 129
Registered: ‎06-09-2009

Re: Parsing Blob field for Groups

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.

Raul A. Chavez
http://raul.chavez.com
http://www.crmbi.com
Gold Super Contributor
Posts: 3,087
Registered: ‎03-19-2009

Re: Parsing Blob field for Groups

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)

--
RJ Ledger - rjledger@rjlSystems.net +1 603.369.3047 x101

".. Innovators in Mobility - Experts in Workflow Automation..."
http://www.rjlSystems.net - blog: www.rjlSystems.net/blog.html
Bronze Super Contributor
Posts: 129
Registered: ‎06-09-2009

Re: Parsing Blob field for Groups

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.

 

 

Raul A. Chavez
http://raul.chavez.com
http://www.crmbi.com
Gold Super Contributor
Posts: 3,087
Registered: ‎03-19-2009

Re: Parsing Blob field for Groups

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!

--
RJ Ledger - rjledger@rjlSystems.net +1 603.369.3047 x101

".. Innovators in Mobility - Experts in Workflow Automation..."
http://www.rjlSystems.net - blog: www.rjlSystems.net/blog.html
Silver Contributor
Posts: 835
Registered: ‎03-24-2009

Re: Parsing Blob field for Groups

[ Edited ]

 

 

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

RJ Samp