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: Groups ... can i show Accounts with no Notes?

Chip
Posts: 29

Groups ... can i show Accounts with no Notes? Your last visit to this thread was on 1/1/1970 12:00:00 AM

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!

[Reply][Quote]

Chip
Posts: 29

Re: Groups ... can i show Accounts with no Notes? Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 15 Jan 08 1:51 PM

I was able to figure this out. I had to change the join to be a left join and it worked.

[Reply][Quote]

Mark Hanford
Posts: 131

Re: Groups ... can i show Accounts with no Notes? Your last visit to this thread was on 1/1/1970 12:00:00 AM

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.

[Reply][Quote]

Mark Hanford
Posts: 131

Re: Groups ... can i show Accounts with no Notes? Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 17 Jan 08 9:56 AM

Aah, I see what you mean. I only had to do the crazy sub-query thing due to some exta criteria we put in. Your way is easier

[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/18/2025 9:22:05 AM