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!

Data & Imports Forums - T-SQL & Queries
Forum to discuss general T-SQL questions and help with queries related to SalesLogix data. View the code of conduct for posting guidelines.

Forums RSS Feed

Back to Forum List | Back to T-SQL & Queries | New Thread

View: Search:

Author

Thread: Group that shows accounts where notes have been added by a user on a specific date

SLX_Novice
Posts: 246

Group that shows accounts where notes have been added by a user on a specific date Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 11 Jul 06 9:49 AM

I would like to know if there is a way to create a group in the SalesLogix Client that shows accounts where notes have been added by a specific user on a specific date.

Any help would be great!

Thanks.

[Reply][Quote]

Tim Montgomery
Posts: 23

Re: Group that shows accounts where notes have been added by a user on a specific date Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 11 Jul 06 10:43 AM

Fabian,
A start would be adding the following conditions to your group:
Account.history.type = 262148 and

Account.History.Createuser = :USERID
(select the "Use Value as a Literal" checkbox)

Place the Account, Contact fullname, History.Createdate, History.Createuser in the layout

Hope this helps,
Tim

[Reply][Quote]

SLX_Novice
Posts: 246

Re: Group that shows accounts where notes have been added by a user on a specific date Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 11 Jul 06 11:21 AM

It worked great Tim!

Thanks a lot!

[Reply][Quote]

Tim Montgomery
Posts: 23

Re: Group that shows accounts where notes have been added by a user on a specific date Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 11 Jul 06 11:35 AM

You're welcome Fabian - glad to help

[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 © 2024 Customer FX Corporation. The information and opinions expressed here are not endorsed by Sage Software.	code of conduct \|

page cache (param): 11/22/2024 2:52:28 PM