3/16/2026 4:34:22 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.
|
|
|
|
Groups ... can i show Accounts with no Notes?
Posted: 15 Jan 08 12:12 PM
|
I have been messing with creating a new group that shows accunts that do not have any notes with them... but so far it is not working. I put a condition on the group that the notes field does not contain data but when I go thru the resulting group I can see ones that do... Any ideas on if this is as simple as I think it should be?
Thanks! |
|
|
| |
|
Re: Groups ... can i show Accounts with no Notes?
Posted: 17 Jan 08 9:56 AM
|
The only way I have found to show records that do not have something in a sub-table, is to paste a whole load of SQL into the criteria box.
Set the operator to "IN", "Use Literal" ticked, and the value to "(SELECT DISTINCT ACCOUNTID FROM HISTORY)"
Then change the criteria to be a "Not"
If I recall correctly the query-builder puts strange extra brackets in around the value, so I had to mess about with extras in there somewhere. |
|
|
| |
|
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!
|
|
|
|
|
|
|
|