Home | Forums | Contact | Search | Syndication  
 
 [login] [create account]   Friday, July 11, 2025 
 
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!
 Administration Forums - General Administration
Forum to discuss general administration topics for SalesLogix (including LAN & remote topics). View the code of conduct for posting guidelines.
Forums RSS Feed


 Back to Forum List | Back to General Administration | New ThreadView:  Search:  
 Author  Thread: Group
Sankar
Posts: 84
 
GroupYour last visit to this thread was on 1/1/1970 12:00:00 AM
Posted: 06 May 08 3:36 PM
In SLX 7.2 how will i change the group to Server mode from client mode?

Thanks
Uma Sankar
[Reply][Quote]
Mike Spragg
Posts: 1226
Top 10 forum poster: 1226 posts
 
Re: GroupYour last visit to this thread was on 1/1/1970 12:00:00 AM
Posted: 06 May 08 6:28 PM
The system will decide, you cannot influence it (well, not really, there are ways - but you should let it decide, there's no "switch")
[Reply][Quote]
John H. Hedges
Posts: 62
 
Re: GroupYour last visit to this thread was on 1/1/1970 12:00:00 AM
Posted: 07 May 08 2:08 AM
The main thing to do is avoid the use of left joins, no...? Also, joins that aren't made on primary keys do it too, I believe. Oh, and you must never, ever use the word "AARDVARK" in a query - that's a complete dealbreaker.
[Reply][Quote]
Dan Carvin
Posts: 227
 
Re: GroupYour last visit to this thread was on 1/1/1970 12:00:00 AM
Posted: 07 May 08 10:38 AM
Are you sure about not using Left joins? What if a left join is what you need to meet a requirement?

For example: Suppose the user wants to see all of the contacts in a specific state. For those that have lit requests, they want to see what literature was requested. But they still want to see contacts who do not have lit requests. This group has to have a left join to the litrequest table.

Some of my groups like this were broken in 6.2.2, but when we upgraded to 6.2.6, the issue was fixed and these groups worked fine. I've also created joins on non-primary keys. Assuming they are theoretically sound, they've worked for me.
[Reply][Quote]
John H. Hedges
Posts: 62
 
Re: GroupYour last visit to this thread was on 1/1/1970 12:00:00 AM
Posted: 07 May 08 11:00 AM
How were they broken?

There should be nothing to prevent you from successfully using a left join in a group... the question was about "client mode" vs. "server mode," which I took to mean that VSSC (Virtual Server-Side Cursors) wasn't being invoked for a particular group in this case. Most (if not all) left joins will prevent VSSC from being invoked, but the group should still work OK as a client-side cursor, just like always.
[Reply][Quote]
Dan Carvin
Posts: 227
 
Re: GroupYour last visit to this thread was on 1/1/1970 12:00:00 AM
Posted: 09 May 08 2:00 PM
You mentioned avoiding the use of left joins. I thought that this might refer to some issues I had in 6.2 where some groups returned no data and -1 rows, or obviously wrong data, even though the the text in Show SQL worked correctly when pasted into query analyzer.

I figured out that this was due to SLX using Client Mode. Look at SQL traces, I found the provider was re-writing the query into two separate queries, which produced incorrect results. My workaround for this was to tinker with the joins. For example, litrequest by default is a left join, but if one of your criteria is that the contact has a lit request between certain dates, you can make it a inner join, or add a criteria like "litreqid does contain data." Stuff like this often fixed problematic groups.

But this was fixed after installing 6.2.6 (which I beleive doesn't have VCCS), and I haven't needed to worry about client-side vrs server-side since.
[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 | Subscribe to the slxdeveloper.com Latest Article RSS feed
   
 
page cache (param): 7/11/2025 12:02:48 AM