Changing Contact Process Statuses in Bulk

Recently, I was asked if it was possible to cancel a group of running contact processes.

The answer is yes it is.  Changing the STATUS in the PROCESS table will allow for this. 

Here are the following valid STATUS values:

-100 is Completed
-101 is Aborted
1 is In Process
2 is Starting
 
Also, if you want you can also set the SUSPENDED field to 1 to suspend a process and then change it back to 0 to resume it.
 
If
you have some way of identifying the records you want to end the
process you could write a query like the following (this example will
abort any contacts having a active process with a last name of “Smith”):
 
update
process set status=’-101′ where targetid in (select contactid from
contact where lastname=’smith’) and status not in (‘-101′,’-100′)

 

ABOUT THE AUTHOR

Kris Halsrud

Kris Halsrud is a Senior Analyst / Developer for Customer FX Corporation.

Submit a Comment

Your email address will not be published. Required fields are marked *

Subscribe To Our Newsletter

Join our mailing list to receive the latest Infor CRM (Saleslogix) and Creatio (bpm'online) news and product updates!

You have Successfully Subscribed!