7/11/2025 1:33:06 AM
|
|
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!
Forum to discuss general administration topics for SalesLogix (including LAN & remote topics). View the code of conduct for posting guidelines.
|
|
|
|
Group
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 |
|
|
|
Re: Group
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") |
|
|
|
Re: Group
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. |
|
|
|
Re: Group
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. |
|
|
|
Re: Group
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. |
|
|
|
Re: Group
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. |
|
|
|
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!
|
|
|
|
|
|
|
|