You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Batch Processes - Scheduled & One-Time

Question
20
Views
0
Comments
edited Jul 24, 2018 7:31PM in Integrations and APIs

Content

Hi,

    I just wanted to share a recent solution I did for handling batch processes - scheduled & one time. 

Usually, I see people suggesting Multi Edit Workspaces & Cron jobs (scheduled batch processes) to handle batch processes. 

But, both have limitations or not very flexible (cron job). 

An Alternative solution, is to use Analytics Reports with custom scripts (PHP). 

Sample Requirement

Assume Incident has custom field - Expiration Date. 

Query all Incident records which have Expiration Date = Today(). Then, update the Status = Expired. 

Analytics Report

  1. Create a new grid report based on Incident. 
  2. The first field must be Incident ID. 

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!