slxdeveloper.com Community Forums

The Forums on slxdeveloper.com are now retired. The forum archive will remain available for the time being. Thank you for your participation on slxdeveloper.com!

Architect Forums - SalesLogix Scripting & Customization
Forum to discuss writing script in Architect plugins for SalesLogix & general SalesLogix customization topics (for Windows client only). View the code of conduct for posting guidelines.

Forums RSS Feed

Back to Forum List | Back to SalesLogix Scripting & Customization | New Thread

View: Search:

Author

Thread: Dynamic Group SQL using ADO

Kevin Austin
Posts: 105

Dynamic Group SQL using ADO Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 11 Nov 08 10:54 AM

Hi all,

I've had a look at trying to obtain the SQL used in a dynamic group using ADO and I've come unstuck, it seems that this information is held in a BLOB field. Has anyone got a quick way of returning this information in a query?

Hope this makes sense, all help greatly appreciated.
Kev

[Reply][Quote]

Ryan Farley
Posts: 2265

Re: Dynamic Group SQL using ADO Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 11 Nov 08 11:53 AM

Not sure if this tool will help, but this tool will show you the queries from groups: http://customerfx.com/pages/beta/2008/09/13/saleslogix-group-explorer.aspx

You're likely more after how to to this programatically, right?

[Reply][Quote]

Kevin Austin
Posts: 105

Re: Dynamic Group SQL using ADO Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 12 Nov 08 3:32 AM

Yes, was looking to do something within a SalesLogix VBScript itself, so far I've built something that will allow users to import data into an adhoc group (as I'm able to obtain the account ideas) but I'm stuck when it comes to dynamic groups.

[Reply][Quote]

Bob (RJ)Ledger
Posts: 1103

Re: Dynamic Group SQL using ADO Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 12 Nov 08 7:57 AM

Look at:
Application.BasicFunctions.GetGroupSQL

I've used it many times...

--
RJLedger - www.SlxWizard.com

[Reply][Quote]

Kevin Austin
Posts: 105

Re: Dynamic Group SQL using ADO Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 12 Nov 08 8:12 AM

That's the ticket! Cheers

[Reply][Quote]

Page 1 of 1

You can subscribe to receive a daily forum digest in your user profile. View the site code of conduct for posting guidelines.

Forum RSS Feed - Subscribe to the forum RSS feed to keep on top of the latest forum activity!

slxdeveloper.com is brought to you courtesy of Ryan Farley & Customer FX Corporation. This site, and all contents herein, are Copyright © 2025 Customer FX Corporation. The information and opinions expressed here are not endorsed by Sage Software.	code of conduct \|

page cache (param): 8/27/2025 8:53:41 AM