03-23-2012 12:43 PM
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
03-23-2012 01:36 PM
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.
03-23-2012 02:20 PM
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)
03-23-2012 02:27 PM
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.
03-23-2012 02:32 PM
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!
03-27-2012 04:38 AM - edited 03-27-2012 04:39 AM
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