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: Getting fields from the Summary tab for an account

SLX_Novice
Posts: 246

Getting fields from the Summary tab for an account Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 11 Apr 07 11:52 AM

Hi all.

I would like to get all the fields (except the Last Update field) that appear in the Summary tab in account detail view. I am using v6.2.6

I would like to use these fields for a report I'm working on(Last Call Date, Last Call User, Last Call Regarding, Next Call Date, Next Call User, Next Call Regarding, Last Meet etc.).

Is there a plugin I can look at to see how they obtain the data that appears in the Summary tab?

Also, I see there are different TYPES (for example 262146 is it for last call or next call or does it depend in what table it's in ACTIVITY or HISTORY) where can I get a listing of all the different types?

Thank you in advance.

[Reply][Quote]

SLX_Novice
Posts: 246

Thanks in advance. Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 11 Apr 07 12:09 PM

thanks in advance

[Reply][Quote]

Ron Buchanan
Posts: 72

Re: Getting fields from the Summary tab for an account Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 11 Apr 07 12:33 PM

My advice... don't depend on the summary fields.

I think you may find that you're better off using max(completeddate) on history for the activity type and account you're looking for.

Hope this helps,
Ron B.

[Reply][Quote]

SLX_Novice
Posts: 246

Re: Getting fields from the Summary tab for an account Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 11 Apr 07 1:34 PM

Where can I get a list of what all the TYPES are. All I see are numbers instead of phone, email...etc.

[Reply][Quote]

Ryan Farley
Posts: 2265

Re: Getting fields from the Summary tab for an account Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 11 Apr 07 1:49 PM

Quote:

Originally posted by Fabian Garcia

Where can I get a list of what all the TYPES are. All I see are numbers instead of phone, email...etc.

See http://saleslogixblog.com/rfarley/archive/2004/04/09/522.aspx

-Ryan

[Reply][Quote]

SLX_Novice
Posts: 246

Re: Getting fields from the Summary tab for an account Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 11 Apr 07 3:28 PM

Thanks Ryan that was helpful.

Is the main difference between the ACTIVITY and HISTORY tables, that the ACTIVITY table only holds activities that have not been completed, while the HISTORY table contains all completed activities?

[Reply][Quote]

Bob (RJ)Ledger
Posts: 1103

Re: Getting fields from the Summary tab for an account Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 13 Apr 07 6:05 AM

Correct.
They exist as separate tables for historical/performance reasons.
--
rjl

[Reply][Quote]

SLX_Novice
Posts: 246

Re: Getting fields from the Summary tab for an account Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 13 Apr 07 7:46 AM

Thanks!

[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): 6/18/2025 2:29:41 AM