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 Contact Process Information

Jeff McDonald
Posts: 2

Getting Contact Process Information Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 03 Aug 07 6:40 PM

When using a script (legacy or VBS) as a task of a contact process, is there any way I can determine the processid of the process when the script runs? For example, if I needed to know the value of the STARTERID column in the PROCESS table when I run the script task, how could I get the value?
Thanks for any help.
Jeff McDonald

[Reply][Quote]

Walter Shpuntoff
Posts: 167

Re: Getting Contact Process Information Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 04 Aug 07 5:55 AM

One of the biggest problems with Contact Processes is that they are blind to where they are.

You have to reverse engineer the processid.
The gist of it is you take a look in the process table for the process that was last executed for the current user and that should be the process that you are in now.

I've pasted in an old, old legacy script that was gathering dust.
You can adapt it to active...

Option Explicit
'***************************************************************************
****
' Script: Personal: CurrentProcessId
'
' Description: Determines the CurrentProcessId
'
' Called By: Any process
'
' Calls:
'
' Comments:
'
' History: 02/07/02 W.Shpuntoff - Initial Coding
'***************************************************************************
****
Sub main
Dim sProcessId as string
Dim sSQL as string
Dim hnd as long

sSQL = "Select ProcessId From Process Where "
sSQL = sSQL & "(USERID = '" & CurrentUserId & "')"
sSQL = sSQL & "And (TARGETID = '" & CurrentContactId & "')"
sSQL = sSQL & " And LastAction = (Select Max(LastAction) from Process
where "
sSQL = sSQL & "(USERID = '" & CurrentUserId & "')"
sSQL = sSQL & "AND (TARGETID = '" & CurrentContactId & "'))"
hnd = DBOpenSQL(sSQL, True)
sProcessId = DBGetValue(hnd, "ProcessId")
DBClose hnd
GlobalInfoSet "CurrentProcessId", sProcessId
InvokeSetResult sProcessId
End Sub

HTH

ws

[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/19/2025 4:48:21 PM