8/23/2025 5:26:33 PM
|
| |
| 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 writing script in Architect plugins for SalesLogix & general SalesLogix customization topics (for Windows client only). View the code of conduct for posting guidelines.
|
|
|
|
Can I use complex SQL in Groups (v6.2)
Posted: 21 May 08 9:40 AM
|
Hello,
I am trying to get a count of opportunities that have a certain status for a certain number of accounts and then filter on the count. I have tried creating a view and looking at the "plugin" table in the SLX db, both to no avail.
Has anyone else had to create a group using more than what the query builder allows you in 6.2? If so, how?
Thanks,
Tim |
|
|
|
Re: Can I use complex SQL in Groups (v6.2)
Posted: 21 May 08 12:58 PM
|
Not sure exactly what your conditions are but you might be able to do this in a group by adding a condition something like this...
field: accountid
operator: in
value is: (select accountid from opportunity where .....)
use value as literal: checked
It is tricky but should filter the group to only the records that you want to see.
|
|
|
|
Re: Can I use complex SQL in Groups (v6.2)
Posted: 21 May 08 1:45 PM
|
Thanks Frank, I didnt realize that that was possible. I think combining this with views (since group by isnt supported) will hopefully get me to where I wanted to be. Unfortuatly it doesnt look like you could show something like this in the results, but again, views would fix that.
Thanks again,
Tim
Edit: Turns out you cant use views like that :/ |
|
|
|
Re: Can I use complex SQL in Groups (v6.2)
Posted: 22 May 08 1:12 AM
|
| Actually, groupby is supported - e.g select type, account from account group by type where type in ('"1","2","3") is perfectly find syntax to use ? |
|
|
|
Re: Can I use complex SQL in Groups (v6.2)
Posted: 22 May 08 9:34 AM
|
Hi Mike,
Thanks for the info. I was getting a message that stated "GROUP BY is not supported by VSSC" in SLX Profiler and was getting no results in the query window. After fixing a logic error, however, it still produces the error in Profiler but does return results.
Thanks,
Tim |
|
|
|
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!
|
|
|
|
|
|
|
|