SQL and Lookup Results Group in SalesLogix

Question: I’m trying to get the SQL that is creating the Lookup Results group for a
mainview in SalesLogix.  If it were an actual group I know I could use
the Application.BasicFunctions.GetGroupSQL, but I’m not seeing an ID for the Generic Lookup Results group.

Answer: This should do what you need:

sql = Application.MainViews.ActiveView.CurrentGroupSQL
msgbox sql

You can replace your existing Application.BF.GetGroupSQL with this as well.

Also, if you wanted to find just the selected ID’s on this view you can use:

with application.MainViews.ActiveView.GroupsPane
For intIndex = 0 To .Selection.Count – 1
msgbox .Selection.Item(intIndex)
end with



Submit a Comment

Your email address will not be published. Required fields are marked *

Subscribe To Our Newsletter

Join our mailing list to receive the latest Infor CRM (Saleslogix) and Creatio (bpm'online) news and product updates!

You have Successfully Subscribed!