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
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:
For intIndex = 0 To .Selection.Count – 1
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!